This IBM Redbooks publication discusses how to install, tailor, and configure the IBM 2109 M12 FICON Director, in conjunction with the FICON topologies supported by IBM eServer zSeries (800, 900, and 990) and 9672 Generation 5 and Generation 6 servers. We focus on the hardware installation, as well as the software definitions needed to provide connectivity for the supported FICON environments. This book provides planning information and FICON Director setup information. We also include helpful utilities for monitoring and managing the IBM 2109 M12 FICON Director. This document is intended for system engineers, SAN administrators, and system programmers who will plan and install IBM 2109 M12 FICON Directors. A good background in systems planning, hardware and cabling infrastructure planning, and zSeries I/O definitions (HCD or IOCP), as well as Fibre Channel or FICON Directors, is assumed.

Take your database expertise to the next level! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds for Microsoft Office Access 2003 in concise, fast-answer format.

This IBM Redbooks publication introduces the reader to the world of EDI. In addition to general terms about EDI, it also introduces a number of products in this area. WebSphere Data Interchange is discussed as the translation engine to map EDI documents to and from documents in other formats. This book also introduces two communication products that use Internet technologies: iSoft’s P2PAgent and Trading Partner Interchange. In addition to product introductions, the book describes several implementation scenarios in a multi-partner and multi-product environment. Besides a network where trading partners only use iSoft’s P2PAgent, we also look at a setup where trading partners use a combination of the two products. For each communication product, we investigate several integration options with internal applications and other middleware. We discuss the integration options with the translation product WebSphere Data Interchange and with the process integration product WebSphere BI Interchange Server. The integration technique can be file-based or messaging-based. Finally, we take a look at options to combine the flexibility of the Internet with the reliability of value-added networks. When Internet connectivity is temporarily not available, a trading partner has the ability to use Expedite to dial into IBM’s network and send or receive EDI documents. By exploiting the recycle mechanics in iSoft's P2PAgent, we can implement a solution that provides a highly available connection between trading partners. For more up-to-date information about WebSphere B2B, please refer to the following books: Please note that the additional material referenced in the text is not available from IBM.

The IBM eServer Cluster 1600 server, which was introduced to meet the rigorous demands of mission-critical enterprise applications, continues to offer outstanding performance, scalability, reliability, availability, serviceability, and management capabilities. In this IBM Redbooks publication, we highlight the benefits of using a Cluster 1600, and describe which hardware components can be managed by either Parallel System Support Programs (PSSP) Version 3, Release 5, or Cluster Systems Management (CSM) Version 1, Release 3, Modification 2.

"I can pretty much guarantee that anyone who uses SQL Server on a regular basis (even those located in Redmond working on SQL Server) can learn something new from reading this book." --David Campbell, Product Unit Manager, Relational Server Team, Microsoft Corporation The latest book from the highly regarded and best-selling author Ken Henderson, is the consummate reference to Microsoft SQL Server. Picking up where documentation and white papers leave off, this book takes an all-inclusive approach to provide the most depth and breadth of coverage of any book on SQL Server architecture, internals, and tuning. The Guru's Guide to SQL Server Architecture and Internals Blending in-depth discussion with practical application, the guide begins with several chapters on the fundamental Windows technologies behind SQL Server, including processes and threads, memory management, Windows I/O, and networking. The focus then moves on to the architectural details of SQL Server and how to practically apply them. The entire SQL Server product is covered--not just the functionality that resides within the core executable or product features that have been in place for years. SQL Server has matured and broadened substantially with each release, and the author explores the "fringe" technologies that have yet to be covered elsewhere, including Notification Services, Full Text Search, SQLXML, replication, DTS, and a host of others. Throughout the book, the author uses WinDbg, Microsoft's free downloadable symbolic debugger, to look under the hood of SQL Server. Armed with new debugging and coding skills, readers will be ready to master SQL Server on their own. The accompanying CD-ROM is packed with additional material, including full source code for the book's 900+ examples, as well as three invaluable tools: DTSDIAG, the VBODSOLE Library, and DTS Package Guru. DTSDIAG allows developers and administrators to simultaneously collect Profiler traces, perform logs, blocking script output, system event logs, and SQLDIAG reports from a specified SQL Server. The VBODSOLE Library features more than twenty new COM-based functions for Transact-SQL, including T-SQL enhancements such as array-manipulation routines, financial functions, string-manipulation functions, and system functions. DTS Package Guru is a .NET-based package editor for SQL Server's Data Transformation Services that allows editing of any modifiable package and supports the automation of mass package changes. is the essential guide for database developers and admin- istrators alike, regardless of skill level. The Guru's Guide to SQL Server Architecture and Internals 0201700476B10012003

This IBM Redbooks publication implements a solution that integrates IBM Tivoli Workload Scheduler and IBM DB2 Content Manager OnDemand products to provide centralized output processing for job logs (job outputs, message files, and audit files) from IBM Tivoli Workload Scheduler and IBM Tivoli Workload Scheduler for z/OS. The solution provides immediate benefit by integrating the job logs into an online, electronic information archive and retrieval system, which is used for quick search and problem resolution purposes. We include all scripts that make up this solution so that you will be able customize the solution according to your needs. We anticipate that the solution covered in this book will provide great value for IBM Tivoli Workload Scheduler and IBM Tivoli Workload Scheduler for z/OS customers who are planning to deploy a centralized job logging and browsing system. Please note that the additional material referenced in the text is not available from IBM.

Enterprise Integration Patterns provides an invaluable catalog of sixty-five patterns, with real-world solutions that demonstrate the formidable of messaging and help you to design effective messaging solutions for your enterprise. The authors also include examples covering a variety of different integration technologies, such as JMS, MSMQ, TIBCO ActiveEnterprise, Microsoft BizTalk, SOAP, and XSL. A case study describing a bond trading system illustrates the patterns in practice, and the book offers a look at emerging standards, as well as insights into what the future of enterprise integration might hold. This book provides a consistent vocabulary and visual notation framework to describe large-scale integration solutions across many technologies. It also explores in detail the advantages and limitations of asynchronous messaging architectures. The authors present practical advice on designing code that connects an application to a messaging system, and provide extensive information to help you determine when to send a message, how to route it to the proper destination, and how to monitor the health of a messaging system. If you want to know how to manage, monitor, and maintain a messaging system once it is in use, get this book.

Sams Teach Yourself XML in 21 Days, written by expert author Steve Holzner, offers hundreds of real-world examples demonstrating the uses of XML and the newest tools developers need to make the most of it. In Week One, he starts from basic syntax, and discusses XML document structure, document types, and the benefits of XML Schema. Week Two covers formatting using either CSS or the Extensible Sytlesheet Language, and working with XHTML and other tools for presenting XML data on the Web, or in multimedia applications. The final chapter of week two discusses XForms, the newest way to process forms in XML applications. Week Three applies XML to programming with Java, .NET or JavaScript, and building XML into database or Web Service applications with SOAP. Along the way, Steve shows readers the results of every lesson and provides both the "how" and "why" of the inner working of XML technologies.

This IBM Redbooks publication helps you to implement Lotus Enterprise Integrator (LEI) 6 on the IBM eServer iSeries server. It is targeted for system administrators who plan to implement or upgrade to LEI 6 in their organization. The book provides tips and techniques to help you successfully deploy and administer LEI 6 on an iSeries server. Please note that the additional material referenced in the text is not available from IBM.

Praise for XForms: XML Powered Web Forms “XForms is an exciting new technology for designing Web forms in an elegant and accessible way. Raman’s book provides strong motivations for flexibility in the design of human-machine interactions, and explains how to use XForms to this end in crystal-clear prose.” — Eve Maler XML Standards Architect, Sun Microsystems “Interactive forms technology is the logical evolution of Web user interface design. XForms represents a significant leap forward in that evolution.” — Sean McGrath CTO, Propylon “The greatest strength of this book is the skill with which T. V. Raman links the XForms technology with the larger context of the Web. The limitations of HTML forms, the ways in which XForms provides a better foundation for Web and Web service user interfaces, and the opportunities for an XForms-powered Web that is accessible to all users and devices are outlined and brought together in a compelling way.” — Michael Champion Advisory Research and Development Specialist, Software AG “Raman’s book gives the reader an excellent explanation of the emerging W3C XForms recommendation. It’s a well-organized and well-written book that begins with a gentle introduction to the concepts that motivated the development of XForms and then provides a reasonable overview of the relevant XML technology related to XForms. Most of the book covers XForms components: user interface controls, model properties, functions, actions, and events. It concludes with XForms as a Web service, offering multi-modal access and accessibility. In light of the October 2003 deadline for U.S. federal agencies to comply with the mandate of the Government Paperwork Elimination Act (GPEA) to give citizens the opportunity to provide information online, this important technical work comes none too soon. As T. V. masterfully elucidates, XForms provides the ‘last mile’ in ‘connecting users to their data.’ Insightfully, he also observes ‘the document is the human interface’ to data—an understanding without which the challenge to make eGov services ‘citizen-centered’ simply cannot and will not be met.” — Owen Ambur Cofounder and Cochair, XML Working Group, U.S. CIO Council “I found the author’s straightforward style quite comfortable and informative. I heartily recommend this book, especially for government XML developers interested in the broader area of E-Forms. Understanding XForms is key to developing robust and flexible E-Forms solutions that separate content, logic, validation, and presentation. You’ll never look at (X)HTML forms the same way after reading Raman’s book.” — Kenneth Sall GSA eGov Technical Architect/XML Specialist, SiloSmashers “Reusable components such as E-Forms are at the heart of the U.S. Federal Enterprise Architecture and E-Government, and XML standards-based solutions are starting to appear for use across the government. T. V. Raman’s book meticulously explains how XForms leverage the power of using XML for E-Forms and have been designed to abstract much of XML’s functionality into a set of components referred to as MVC (Model, View, Controller), which separates the model from its final presentation. This XForms component architecture serves as an excellent roadmap for the reader. T. V. eloquently shows how XForms make the original promise of ‘the document is the interface’ a reality so the collected data can be directly submitted to a Web service—thus putting a human face on Web services!” —Brand Niemann, Ph.D., Chair, XML Web Services Working Group, U.S. CIO Council XForms—XML-powered Web forms—are set to replace HTML forms as the backbone of electronic commerce. XForms enable the creation and editing of structured XML content within a familiar Web browser environment, which is likely to play a key role in enabling simple browser-based access to Web services. XForms leverage the power of XML in modeling, collecting, and serializing user input. In this book, World Wide Web Consortium (W3C) XForms specification editor T. V. Raman explains how programmers can create durable and dependable feature-rich forms accessible from multiple platforms and devices and available in multiple languages and modes. XForms play a key role in connecting humans to information technologies, deployed as Web services. This book begins by providing an overview of the XForms technology and the set of XML standards on which it is built, including XML Path Language (XPath), Dom2 events, XML events, XML namespaces, and XML Schema. Part II profiles the XForms architecture and its components. An introduction to the available user interface controls leads into a guide to creating complex user interfaces. The following chapters describe XForms model properties, functions, actions, and events. Each chapter’s increasingly complex examples illustrate the concepts discussed. The final part of the book details how XForms will be used to create a new generation of human-centric, multimodal, accessible Web transactions. Readers will learn: Why XForms can deliver better user interaction at less cost How the XForms technology works What comprises the XForms architecture How to use XForms to connect users to Web services How XForms can accommodate spoken and visual interaction How to ensure universal accessibility to Web content with XForms XForms will transform the way companies and consumers handle Web transactions. provides Web developers, IT professionals, and Web server administrators with a firm grasp of this standard, how it will shape emerging solutions, and how it will change the nature of their day-to-day work. XForms: XML Powered Web Forms

XQuery Kick Start delivers a concise introduction to the XQuery standard, and useful implementation advice for developers needing to put it into practice. The book starts by explaining the role of XQuery in the XML family of specifications, and its relationship with XPath. The authors then explain the specification in detail, describing the semantics and data model, before moving to examples using XQuery to manipulate XML databases and document storage systems. Later chapters discuss Java implementations of XQuery and development tools that facilitate the development of Web sites with XQuery. This book is up to date with the latest XQuery specifications, and includes coverage of new features for extending the XQuery language.

Praise for Effective XML “This is an excellent collection of XML best practices: essential reading for any developer using XML. This book will help you avoid common pitfalls and ensure your XML applications remain practical and interoperable for as long as possible.” — Edd Dumbill, Managing Editor, XML.com and Program Chair, XML Europe “A collection of useful advice about XML and related technologies. Well worth reading both before, during, and after XML application development.” — Sean McGrath, CTO, Propylon “A book on many best practices for XML that we have been eagerly waiting for.” — Akmal B. Chaudhri, Editor, IBM developerWorks “The fifty easy-to-read items cover many aspects of XML, ranging from how to use markup effectively to what schema language is best for what task. Sometimes controversial, but always relevant, Elliotte Rusty Harold’s book provides best practices for working with XML that every user and implementer of XML should be aware of.” — Michael Rys, Ph.D., Program Manager, SQL Server XML Technologies, Microsoft Corporation “ Effective XML is an excellent book with perfect timing. Finally, an XML book everyone needs to read! Effective XML is a fount of XML best practices and solid advice. Whether you read Effective XML cover to cover or randomly one section at a time, its clear writing and insightful recommendations enlighten, entertain, educate, and ultimately improve the effectiveness of even the most expert XML developer. I’ll tell you what I tell all my coworkers and customers: You need this book.” — Michael Brundage, Technical Lead, XML Query Processing, Microsoft WebData XML Team “This book provides great insight for all developers who write XML software, regardless of whether the software is a trivial application-specific XML processor or a fullblown W3C XML Schema Language validator. Mr. Harold covers everything from a very important high-level terminology discussion to details about parsed XML nodes. The well-researched comparisons of currently available XML-related software products, as well as the key criteria for selecting between XML technologies, exemplify the thoroughness of this book.” — Cliff Binstock, Author, The XML Schema Complete Reference If you want to become a more effective XML developer, you need this book. You will learn which tools to use when in order to write legible, extensible, maintainable and robust XML code. Page 36: How do you write DTDs that are independent of namespace prefixes? Page 82: What do parsers reliably report and what don't they? Page 130: Which schema language is the right one for your job? Page 178: Which API should you choose for maximum speed and minimum size? Page 257: What can you do to ensure fast, reliable access to DTDs and schemas without making your document less portable? Page 283: Is XML too verbose for your application? Elliotte Rusty Harold provides you with 50 practical rules of thumb based on real-world examples and best practices. His engaging writing style is easy to understand and illustrates how you can save development time while improving your XML code. Learn to write XML that is easy to edit, simple to process, and is fully interoperable with other applications and code. Understand how to design and document XML vocabularies so they are both descriptive and extensible. After reading this book, you'll be ready to choose the best tools and APIs for both large-scale and small-scale processing jobs. Elliotte provides you with essential information on building services such as verification, compression, authentication, caching, and content management. If you want to design, deploy, or build better systems that utilize XML—then buy this book and get going!

This second edition of the bestselling Learning XML provides web developers with a concise but grounded understanding of XML (the Extensible Markup Language) and its potential-- not just a whirlwind tour of XML.The author explains the important and relevant XML technologies and their capabilities clearly and succinctly with plenty of real-life projects and useful examples. He outlines the elements of markup--demystifying concepts such as attributes, entities, and namespaces--and provides enough depth and examples to get started. Learning XML is a reliable source for anyone who needs to know XML, but doesn't want to waste time wading through hundreds of web sites or 800 pages of bloated text.For writers producing XML documents, this book clarifies files and the process of creating them with the appropriate structure and format. Designers will learn what parts of XML are most helpful to their team and will get started on creating Document Type Definitions. For programmers, the book makes syntax and structures clear. Learning XML also discusses the stylesheets needed for viewing documents in the next generation of browsers, databases, and other devices. Learning XML illustrates the core XML concepts and language syntax, in addition to important related tools such as the CSS and XSL styling languages and the XLink and XPointer specifications for creating rich link structures. It includes information about three schema languages for validation: W3C Schema, Schematron, and RELAX-NG, which are gaining widespread support from people who need to validate documents but aren't satisfied with DTDs. Also new in this edition is a chapter on XSL-FO, a powerful formatting language for XML. If you need to wade through the acronym soup of XML and start to really use this powerful tool, Learning XML, will give you the roadmap you need.

How profitable (or successful) is your e-business investment? How effective is your e-business at attracting new customers and retaining existing ones? What is the availability of your e-business Web server infrastructure and performance of your Web transactions? These questions, which are critical in measuring e-business success, are both behavioral and operational in nature. It is necessary to measure both e-business and IT metrics, which are closely linked, and have a direct effect on each other. For example, a spike in web traffic (or a single hit for that matter) has a direct effect on server load and the systems that process the transaction. Therefore, it is critical to analyze each of these metrics and draw correlations between them.

IBM DB2 Universal Database v8.1.2 will help you access any information, from any application, from anywhere in your organization, anytime—and do it all more easily and cost-effectively than you ever thought possible. Now, in DB2 Version 8: The Official Guide, a team of IBM DB2 experts shows experienced DB2 professionals exactly how to make the most of DB2 Version 8 in any environment—Linux®, UNIX®, or Windows®. The authors draw on extensive personal experience helping customers implement state-of-the-art DB2 solutions, and unparalleled access to the IBM DB2 development team. They offer detailed, never-before-published technical guidance for the key challenges you'll face in delivering high-performance DB2 databases, e-business infrastructure, and enterprise integration solutions. Coverage includes: Simplifying management with the Configuration Advisor, HealthCenter(, and Memory Visualizer Integrating the enterprise via Federated Web Services and the DB2 enhanced XML productivity tools Maximizing database scalability, availability, and robustness Using multidimensional data clustering and other integrated business intelligence tools Integrating with IBM WebSphere and Microsoft software development tools Leveraging key improvements in DB2 SQL functionality The accompanying CD-ROM contains a complete trial version of IBM® DB2® Universal Database Personal Edition Version 8.1, for Windows® Operating Environments, Evaluation Copy, plus the DB2 demonstration program for trying out the various SQL commands on your own machine. If you're an experienced DB2 professional who's ready to take DB2 Version 8 to the max, DB2 Version 8: The Official Guide is the book you've been searching for.

Oracle system performance inefficiencies often go undetected for months or even years--even under intense scrutiny--because traditional Oracle performance analysis methods and tools are fundamentally flawed. They're unreliable and inefficient.Oracle DBAs and developers are all too familiar with the outlay of time and resources, blown budgets, missed deadlines, and marginally effective performance fiddling that is commonplace with traditional methods of Oracle performance tuning. In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes. Optimizing Oracle Performance eliminates the time-consuming, trial-and-error guesswork inherent in most conventional approaches to tuning. You can determine exactly where a system's performance problem is, and with equal importance, where it is not, in just a few minutes--even if the problem is several years old. Optimizing Oracle Performance cuts a path through the complexity of current tuning methods, and streamlines an approach that focuses on optimization techniques that any DBA can use quickly and successfully to make noticeable--even dramatic--improvements.For example, the one thing database users care most about is response time. Naturally, DBAs focus much of their time and effort towards improving response time. But it is entirely too easy to spend hundreds of hours to improve important system metrics such as hit ratios, average latencies, and wait times, only to find users are unable to perceive the difference. And an expensive hardware upgrade may not help either.It doesn't have to be that way. Technological advances have added impact, efficiency, measurability, predictive capacity, reliability, speed, and practicality to the science of Oracle performance optimization. Optimizing Oracle Performance shows you how to slash the frustration and expense associated with unraveling the true root cause of any type of performance problem, and reliably predict future performance.The price of this essential book will be paid back in hours saved the first time its methods are used.

Easy Microsoft Office Access 2003 takes the work out of learning this powerful database by using short, easy-to-follow lessons that show you how to accomplish basic tasks quickly and efficiently! It is the perfect book for beginners who want to learn Microsoft's database application through a visual, full-color approach. More than 100 hands-on lessons are designed to teach the easiest, fastest, or most direct way to accomplish common Access tasks. The book is suited for new Access users, as well as those upgrading from an earlier version.

Microsoft Access 11 is a powerful, relational database software package that makes it easier for you to create and manage complex databases. With Access, you can create a database quickly from scratch or by using and Access database Wizard. Once you¿ve created your database, Access provides all the tools you need to enter and manipulate data. Using Access, you can do the following: Quickly start a new database by using the Database Wizard. Create tables from scratch or by using a Wizard. Add and edit database information by using both tables and forms. Manipulate data in a number of tables by using queries and reports.

Tom Kyte of Oracle Magazine’s “Ask Tom” column has written the definitive guide to designing and building high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.

Virtual Storage Access Method (VSAM) is one of the access methods used to process data. Many of us have used VSAM and work with VSAM data sets daily, but exactly how it works and why we use it instead of another access method is a mystery. This book helps to demystify VSAM and gives you the information necessary to understand, evaluate, and use VSAM properly. It clarifies VSAM functions for application programmers who work with VSAM. The practical, straightforward approach should dispel much of the complexity associated with VSAM. Wherever possible an example is used to reinforce a description of a VSAM function. This IBM Redbook is intended as a supplement to existing product manuals. It is intended to be used as an initial point of reference for VSAM functions. This book also builds upon the subject of Record Level Sharing and the new z/OS feature called DFSMStvs.