As organizations strive to do more with less, DB2 Universal Database v8.1 on Windows Server 2003 brings unprecedented enterprise-class scalability to 32-bit and 64-bit Intel platforms. Supporting both vertical (scale up) and horizontal (scale out) scaling, DB2 UDB v8.1 represents over a decade of industry proven scalability with both non-clustered and clustered database architectures. This IBM Redbooks publication is designed as an informative guide to scaling DB2 UDB V8.1 with Windows Server 2003. It is intended for database and system administrators who need both an introduction and detailed information on scaling DB2 UDB on Windows Server 2003. We begin with an overview to scalability including the goals, measurements, and common approaches. We introduce the scalability features of DB2 UDB, Windows Server 2003, and the IBM xSeries Servers followed by some design considerations for scaling. We dedicate an entire chapter to running DB2 UDB on 64-bit Windows including installation, configuration, and 64-bit migration techniques. We discuss scaling up and how to leverage large memory support in a 32-bit environments. Finally, we include a chapter on scaling out including adding logical and physical database partitions.

"The individual perspectives on the concepts behind the XQuery language offered by XQuery from the Experts will be of great value to those who are seeking to understand the implications, opportunities, and challenges of XQuery as they design future information systems based on XML." —Michael Champion, Advisory Research and Development Specialist, Software AG XQuery answers the growing need for a functional XML search and transformation standard. Backed by the full weight of the World Wide Web Consortium (W3C), XQuery is being extremely well received by the IT community worldwide. The first major XML language that takes advantage of the benefits of strong typing provided by XML Schema, XQuery has the versatility to manipulate both XML and non-XML data and provides a valuable connection between the world of XML and relational databases. In , select members of the W3C's XML Query working group come together to discuss every facet of XQuery. From Jonathan Robie's introductory "XQuery: A Guided Tour" to Mary Mary Fernández, Jérôme Siméon, and Philip Wadler's "Introduction to the Formal Semantics," XQuery is revealed in a way that both novice programmers and industry experts can appreciate. XQuery from the Experts Edited by long-time XML expert and programmer Howard Katz, coverage ranges from strictly technical chapters to comparative essays such as Michael Kay's "XQuery, XPath, and XSLT," which explores the common ancestry of all three languages, and Don Chamberlin's "Influences on the Design of XQuery," which details the process behind XQuery's design. Key coverage includes: Denise Draper on "Mapping Between XML and Relational Data" Michael Rys exploring "Integrating XQuery and Relational Database Systems" Jim Tivy's analysis of "A Native XML DBMS" Mary Mary Fernández, Jérôme Siméon, and Philip Wadler, presenting "Static Typing in XQuery" Information presented in both a tutorial and a reference framework for use by XML professionals of any level For IT managers, professionals, programmers, or anyone involved with XML, is an invaluable resource. XQuery from the Experts 0321180607B07212003

Storage growth continues to accelerate, and the cost of disk can approach 80% of total system hardware costs. Yet, the storage in most businesses is typically only about 50% used. How can you take control of your storage assets to render utilization more efficient, and make the most of your storage dollars? The second edition of this book is updated for IBM Tivoli Storage Resource Manager Version 1.2 Please note that the additional material referenced in the text is not available from IBM.

Marketshare for DB2 has been growing steadily over the past 5 years and with the recent release of DB2 Universal Database V8, the product has never had more momentum. Not only is the product used in every company on the Fortune 500, but it is becoming very popular in the small to medium sized businesses as well. Sams Teach Yourself DB2 Universal Database in 21 Days, Second Edition, focuses on performing tasks using the graphical interfaces and wizards that are provided with DB2 on the Windows platform. (DB2 also runs on z/OS, OS/400, AIX, Linux, HP-UX, and Sun Solaris.) Readers are guided through performing all the commonly used tasks to run DB2, including installing DB2, setting up DB2, creating databases and tables, populating the database with data, accessing the data, ensuring the database is tuned for performance. This book differs from the competition in that it provides examples and scenarios making it very easy for the reader to learn complicated tasks. It gives them everything they need for the commonly used tasks in a simple to understand manner. Quizzes and exercises strengthen the knowledge gained and ensure concepts are learned rather than memorized.

In a few short years, e-business has gone from a simple concept to an undeniable reality, and for good reason. It works for everyone: Consumers, businesses, and governments. The primary values of e-business, such as cost savings, revenue growth, and customer satisfaction, are proving to be only the tip of the iceberg. Having realized the benefit of Web-enabling individual business processes, many companies now seek further Return On Investment (ROI) by integrating new and existing e-business applications and technologies. The key to their success is to find a way to give customers what they want without the expense of traditional business operations. This IBM Redbook explains the IBM approach to creating e-business solutions. This publication targets IT specialists and architects who want to learn about proven technologies, products, and solutions to build advanced e-business applications. This publication is also written for the technical professional who is planning to take IBM Certification Test 815, IBM e-business Solution Design. This is a revision of Test 811, Designing IBM e-business Solutions. This publication, written by the same people who created Test 815, IBM e-business Solution Design, is a guide to the style and thinking that went into each and every test question. The information in this book is designed to help you prepare for IBM Test 815 and includes helpful tips for taking the test and sample questions.

"The book that Microsoft should have written, but didn't." —Jeremy Allison, Samba Team "Your detailed explanations are clear and backed-up with source code—and the numerous bits of humor make a dry subject very enjoyable to read." —J.D. Lindemann, network engineer, Adaptec, Inc. The first developer's guide to Microsoft®'s Internet/Intranet file sharing standard For years, developers and administrators have struggled to understand CIFS, Microsoft's poorly documented standard for Internet file sharing. Finally, there is an authoritative, cross-platform guide to CIFS capabilities and behavior. Implementing CIFS not only delivers the priceless knowledge of a Samba Team member dedicated to investigating the inner workings of CIFS, it also identifies and describes crucial specifications and supporting documents. Provides essential information for designing and debugging large Windows® and/or Samba networks Offers clear, in-depth introductions to Server Message Block (SMB), NetBIOS over TCP/IP (NBT), browser services, and authentication Drills down into the internals of CIFS, exposing its behavior on the wire and at the desktop—and its strange quirks Presents illustrative code examples throughout Reflects years of work reviewing obscure documentation, packet traces, and sourcecode Includes the SNIA CIFS Technical Reference Implementing CIFS will be indispensable to every developer who wants to provide CIFS compatibility—and every administrator or security specialist who needs an in-depth understanding of how it really works.

"This volume offers relentlessly pragmatic solutions to help your business applications get the most out of XML, with a breezy style that makes the going easy. Mike has lived this stuff; he has a strong command of the solutions and the philosophy that underlies them." --Eve Maler, XML Standards Architect, Sun Microsystems Businesses running legacy applications that do not support XML can face a tough choice: Either keep their legacy applications or switch to newer, XML-enhanced applications. XML presents both challenges and opportunities for organizations as they struggle with their data. Does this dilemma sound familiar? What if you could enable a legacy application to support XML? You can. In e-commerce expert Michael C. Rawlins outlines usable techniques for solving day-to-day XML-related data exchange problems. Using an easy-to-understand cookbook approach, Rawlins shows you how to build XML support into legacy business applications using Java and C++. The techniques are illustrated by building converters for legacy formats. Converting CSV files, flat files, and X12 EDI to and from XML will never be easier! Using XML with Legacy Business Applications, Inside you'll find: A concise tutorial for learning to read W3C XML schemas An introduction to using XSLT to transform between different XML formats Simple, pragmatic advice on transporting XML documents securely over the Internet For developers working with either MSXML with Visual C++ or Java and Xerces: See Chapter 3 for a step-by-step guide to enabling existing business applications to export XML documents See Chapter 2 for a step-by-step guide to enabling existing business applications to import XML documents See Chapter 5 for code examples and tips for validating XML documents against schemas See Chapter 12 for general tips on building commerce support into an application For end users who need a simple and robust conversion utility: See Chapter 7 for converting CSV files to and from XML See Chapter 8 for converting flat files to and from XML See Chapter 9 for converting X12 EDI to and from XML See Chapter 11 for tips on how to use these techniques together for complex format conversions The resource-filled companion Web site (www.rawlinsecconsulting.com/booksupplement) includes executable versions of the utilities described in the book, full source code in C++ and Java, XSLT stylesheets, bug fixes, sample input and output files, and more. 0321154940B07142003

Ensuring 24/7 database availability is crucial to your company’s success. Discover the best ways to help keep your critical, Microsoft SQL Server 2000–based systems up and running—and secure—with this in-depth guide, straight from the source.

Rich Text Format, or RTF, is the internal markup language used by Microsoft Word and understood by dozens of other word processors. RTF is a universal file format that pervades practically every desktop. Because RTF is text, it's much easier to generate and process than binary .doc files. Any programmer working with word processing documents needs to learn enough RTF to get around, whether it's to format text for Word (or almost any other word processor), to make global changes to an existing document, or to convert Word files to (or from) another format.RTF Pocket Guide is a concise and easy-to-use tutorial and quick-reference for anyone who occasionally ends up mired in RTF files. As the first published book to cover the RTF format in any detail, this small pocket guide explains the syntax of RTF with examples throughout, including special sections on Unicode RTF and MSHelp RTF, and several full programs that demonstrate how to work in RTF effectively.Most word processors produce RTF documents consisting of arcane and redundant markup. This book is the first step to finding order in the disorder of RTF.

You will find every skill and technique you need to build enterprise, Web, and eBusiness applications with DB2 UDB v8. This book is IBM's official guide to becoming an IBM Certified Application Developer for the DB2 Universal Database v8 Family. New to the second edition is the inclusion of the information that you will need to prepare for the Fundamentals exam, a prerequisite to the Application Development exam. This section covers information about the DB2 products, tools, connectivity, data objects, manipulation, control, security, and concurrency. The application development section has been revised and updated to reflect new powerful features of DB2. You can review the DB2 client-server environment, the role of SQL, and the basic structure of a DB2 application; compare the programming interfaces available for DB2 application development, choosing the ones most appropriate to each project; and, of course, prepare for the Application Development Exam. As a bonus, information that is not needed to become an IBM Certified Application Developer for the DB2 Universal Database v8 Family has been provided by the authors to show you how to take advantage of IBM's powerful Extenders for DB2. Using Extenders, you can build searchable indexes to quickly find elements within text, audio, image, or XML objects stored in DB2. Section 1 covers all the fundamentals of DB2 to get you started and to prepare you for the DB2 UDB v8 Family Fundamentals Exam (test 700) Section 2 covers every DB2 v8 programming interface and strategy and will help prepare you for the DB2 UDB v8 Family Application Development Exam (test 703) Section 3 contains bonus materials including information about the many Extenders that are available to create powerful indexes for text, audio, image, and XML documents The accompanying CD-ROM contains a complete trial version of DB2 UDB v8 Personal Edition along with the Application Development Client.

The IBM eServer xSeries 450 is IBM’s new 64-bit Itanium Processor Family (IPF) Architecture server and is the first implementation of the 64-bit IBM XA-64 chipset, as part of the Enterprise X-Architecture strategy. This IBM Redbooks publication is a comprehensive resource on the technical aspects of the server, and is divided into five key subject areas: Chapter 1, Technical description introduces the server and its subsystems and describes the key features and how they work. This includes the new Extensible Firmware Interface, which provides a powerful replacement to the BIOS facility found on the IA-32 platform. Chapter 2, Positioning examines the types of applications that would be used on a server such as the x450. Chapter 3, Planning describes the considerations when planning to purchase and planning to install the x450. It covers such topics as configuration, operating system specifics, scalability, and physical site planning. Chapter 4, Installation covers the process of installing Windows Server 2003, Enterprise Edition and SuSE Linux Enterprise Server on the x450. Chapter 5, Management describes how to use the Remote Supervisor Adapter to send alerts to an IBM Director management environment.

The Oracle SQL every DBA needs—fast and easy! Covers all the core day-to-day tasks DBAs are responsible for Quick access to SQL commands, operators, functions, data dictionary views, and more Includes dozens of easy-to-understand syntax diagrams The fast, practical Oracle SQL reference for every Oracle DBA! If you're a working Oracle DBA, here's the Oracle SQL reference you've been searching for—simple, straightforward, and incredibly easy to use! There's no faster way to discover the exact syntax you need...refresh your memory about that option you haven't used lately...find the name of that view you know exists...start using that new Oracle 9 i feature you haven't tried yet. Keep it by your desk, near your server...wherever you need fast, reliable answers right this minute! Covers Oracle SQL through Oracle9 i Release 2 Clear, well-organized tables of operators, functions, format models, privileges, and reserved words Complete command reference: syntax and options for every Oracle SQL command Standard "railroad" syntax diagrams make it easy to write correct syntax Handy listings of data dictionary views and dynamic performance tables

This IBM Redbooks publication recommends strategies that you can use to replace the Distributed Computing Environment (DCE) dependencies in your environment and move to new technologies. The following topics are covered: This book is a valuable information source if you are an executive, administrator, or developer of an IBM customer environment that uses IBM DCE for a distributed systems and application infrastructure. Although strategies for replacing DCE are described, the book does not cover strategies for replacing dependencies to IBM products that use DCE, such as DFS and TXSeries. Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication is the third volume of a series of redbooks called IMS in the Parallel Sysplex. These redbooks describe how IMS exploits the Parallel Sysplex functions and how to plan for, implement, and operate IMS systems working together in a Parallel Sysplex. This book encompasses two parts. Part 1, Implementation, is a description of the tasks an IMS installation must execute to enable each of the functions. Part 2, Operations, addresses the operational issues associated with running an IMSplex that include startup and shutdown, steady state operations, online change, and recovery from failure. IMS in Parallel Sysplex, Volume I: Reviewing the IMSplex Technology, SG24-6908

This IBM Redbooks publication will help you to migrate batch VSAM applications to exploit transactional VSAM. DFSMStvs is available in a z/OS environment and offers the ability for VSAM data to be shared for both read and write operations while maintaining integrity and recoverability. DFSNStvs allows logging of changes to recoverable VSAM data sets. Batch programs can use commit and backout functions. This book assumes that you are familiar with the material in the companion book DFSMStvs Overview and Planning, SG24-6971, and refers extensively to material published in that book. We also assume some familiarity with CICS Transaction Server and z/OS. The book is intended for application developers who want to understand how to change applications to make best use of the facilities offered by DFSMStvs and to coexist well with other batch applications and with CICS systems sharing the same VSAM data sets. We assume that you are familiar with the development of batch applications and with the facilities and use of VSAM. The tasks involved in setting up DFSMStvs and the hardware and software prerequisites are not discussed in this book; they are described in DFSMStvs Overview and Planning, SG24-6971.

This IBM Redbooks publication describes the High Availability Large Database (HALDB) capability available with IMS. IMS HALDB was introduced with IMS Version 7. It allows IMS databases to grow to almost unlimited sizes while providing increased availability. This book updates IMS Version 7 High Availability Large Database Guide, SG24-5751, as well as adding topics that were not covered in the previous book. This publication provides a broad explanation of HALDB and its uses. Specific areas covered include: -HALDB overview, definition, and structure This publication documents our hands-on experience in a test environment. It includes migration and administration examples. Some IBM Data Management Tools for IMS are also discussed in this publication. Special emphasis is given to the IMS HALDB Conversion and Maintenance Aid product. Examples of the use of these tools are provided.

Today's corporate computing environment is too often characterized by silos of data in enterprise applications like ERP, CRM, and supply chain management. Integrating these applications involves hardwiring connections between them, often resulting in a rigid and inefficient IT infrastructure.Packaged Composite Applications (PCAs) are an innovative answer to this dysfunctional scenario. Originated by SAP, one of the worlds foremost technology companies, PCAs represent a new architectural paradigm for enterprise computing. Using web services, they combine new functionality with services from existing applications to enable flexible, cross-functional automation. But is this new model right for your business? That's where this book comes in.Packaged Composite Applications is the result of a systematic search through the brain trust of SAP for all of the relevant arguments, examples, concepts, and analogies related to Packaged Composite Applications. This book is not a marketing treatise about neatly-shaped colored boxes. It is not a backward-looking, outdated description of a product without context. This book, rather, combines the approach of a forward-looking analyst with the perspective of an executive who must make things work, without skimping on the relevant technical details. The author examines the ideas driving PCAs forward in the marketplace and the problems and solutions that an executive and technologist will encounter in implementation. The result is an authoritative text that allows all interested parties to assess the value of PCAs for their lives as executives, technologists, analysts, sales representatives, and users.

The definitive, real-world guide to Oracle data warehousing Maximizing performance, flexibility, and manageability in production environments Hardware/software architectures, star schema design, partitioning, and more Industrial strength data loading and query optimization techniques By the world-renowned architect of 7-Eleven's multi-terabyte datawarehouse Maximize Oracle data warehouse performance, flexibility, and manageability Oracle DBAs finally have a definitive guide to every aspect of designing, constructing, tuning, and maintaining star schema data warehouses with Oracle 8i and 9i. Bert Scalzo, one of the world's leading Oracle data warehousing experts, offers practical, hard-won lessons and breakthrough techniques for maximizing performance, flexibility, and manageability in any production environment. Coverage includes: Data warehousing fundamentals for DBAs--including what a data warehouse isn't Planning software architecture: business intelligence, user interfaces, Oracle versions, OS platforms, and more Planning hardware architecture: CPUs, memory, disk space, and configuration Radically different star schema design for radically improved performance Tuning ad-hoc queries for lightning speed Industrial-strength data loading techniques Aggregate tables: maximizing performance benefits, minimizing complexity tradeoffs Improving manageability: The right ways to partition Data warehouse administration: Backup/recovery, space and extent management, updates, patches, and more

This is the second edition of the popular practitioner's guide to SQL, the industry-standard database query language. Like most computer languages, SQL can be overwhelming when you first see it, but for years readers have relied on this book to clear the confusion and explain how SQL works and how to use it effectively. Packed with tips, tricks, and good information, SQL Clearly Explained, Second Edition teaches database users and programmers everything they need to know to get their job done including · formulating SQL queries, · understanding how queries are processed by the DBMS,· maximizing performance,· using SQL to enter, modify, or delete data,· creating and maintaining database structural elements, and· embedding SQL in applications.Features· Updated and expanded to include changes in the SQL standard (SQL:1999) as well as recently implemented aspects of SQL-92.· Includes CD with examples from the book as well as MySQL, a popular open-source DBMS, on which the examples are based.· Web enhanced with extra features available online at www.mkp.com. * Second edition of classic SQL handbook Updated to cover changes in the SQL language standard (SQL:1999) Includes CD with MySQL software

Everything a company needs to know to plan, organize, and perform an SAP implementation in one book! This is the only book available that shows the reader how to actually plan an SAP Data Center, install mySAP components, and set up the tools and processes necessary to monitor and manage a productive SAP system. It covers how to perform a Total Cost of Ownership analysis to help refine your SAP Solution Vision, and then how to leverage SAP¿s technology partners to work through the SAP system landscape sizing process. Staffing the project, from the SAP Steering Committee all the way down to the primary SAP basis and computer operations teams, is covered as well. It also covers building high availability and disaster recoverability into your solutions, addressing critical training required by the SAP support team as well as end users, and how to use SAP-provided and a host of other 3rd party tools to manage your mySAP landscape. Finally, this is the only book that covers in detail how to address both functional and stress testing of your solution prior to going live. Throughout the book, knowledge and processes are provided that will help you hit the ground running and help you save money. The book is written by an SAP Technical Certified Consultant with seven years of experience in SAP design and implementation who offers tried and proven approaches, scripts, and tools similar to those used by new and existing SAP customer sites. The accompanying CD of documents, presentations, scripts, checklists, and various tools valued at $50,000 saves time and makes the reader productive fast. Coverage includes notated screen shots of real productive systems; custom checklists, how-to procedures, organization charts that can be leveraged immediately for staffing teams; PowerPoint presentations that can be used by management to sell, present, and provide status updates on their mySAP projects internally; tools, utilities, and XLS spreadsheets used to design, size, and understand SAP system architectures; actual Microsoft Project plans and implementation schedules to get the customer and 3rd party Project Manager's started quickly; and documentation templates and approaches that may be used at once.