This IBM Redbooks publication is intended for those familiar with most of the IBM-provided iSeries performance tools that are generally available through the i5/OS operating systems commands and iSeries Navigator interfaces and the additional-cost Performance Tools for iSeries, 5722-PT1, licensed program. iDoctor for iSeries is a set of software performance analysis tools and associated services that extend your ability to evaluate the health of your iSeries-based system by gathering detailed information and providing automated, graphical analysis of this data. One of these tools, Job Watcher, is the key next-step advanced tool for analyzing detailed performance data. This book: This book's objective is to enhance the performance analyst’s proficiency in using Job Watcher as a key tool in the performance analysis tool kit.

Originally developed for mainframes but highly portable across platforms-from servers to desktops to handhelds-Rexx is an easy yet powerful scripting language that's widely used for rapid application development. Covers Rexx interpreters for specialized functions-object-oriented, mainframe, and handheld. There are 8 different free Rexx interpreters optimized for different platforms and uses. This book shows how to use them all. Shows how to script for GUIs, databases, web servers, XML, and other interfaces. Details how to make the best use of Rexx tools and interfaces, with examples for both Linux and Windows. Includes a tutorial with lots of examples to help people get up and running.

This book is designed to take Microsoft Access users to the next step in programming. Its five parts cover an intro-duction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. With more than 300 hands-on examples and 11 custom projects, users can quickly build the toolset required for developing their own database solutions. Learn how to write and debug your programming code with the Visual Basic Editor, and understand and use common VBA programming structures such as conditions, loops, arrays, and collections. Learn how to create and manage databases with ActiveX Data Objects (ADO), and perform database tasks with Jet/Access Structured Query Language (SQL) and its Data Definition Language (DDL) component. Learn how to query and manipulate your database from a web browser with Active Server Pages (ASP) and export and import Access data to and from XML both manually and programmatically.

Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix Paul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others

This IBM Redbooks publication demonstrates the relative ease with which SAP users can migrate to the IBM TotalStorage Enterprise Storage Server (ESS) 800. It describes how this can be accomplished in numerous ways, across a variety of hardware and software platforms.

Patterns for e-business are a group of proven, reusable assets that can be used to increase the speed of developing and deploying e-business applications. This IBM Redbooks publication focuses on the architecture and implementation of pervasive solutions using currently available IBM products. Part 1 uses the Patterns for e-business to describe the Application and Runtime patterns applicable to pervasive solutions. IBM product mappings are applied to these patterns. Part 2 describes the technologies key to building pervasive solutions. It also describes the IBM development tools for building these solutions. Part 3 consists of eight pervasive scenarios. Each scenario implements an IBM product mapping, and provides design, development, and runtime guidelines for building these scenarios. Please note that the additional material referenced in the text is not available from IBM.

Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years, this book provides: Clear and concise information on advanced database administration with Oracle 10g Practical examples and insights drawn from the authors' real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards You'll also find authoritative coverage of key exam topics, including: Configuring Recovery Manager Understanding the Flashback Database Recovering from User Errors Working with Globalization Support Using the Scheduler to Automate Tasks Monitoring and Managing Storage Securing the Oracle Listener Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace.

In 1978 IBM introduced the System/38 as part of its midrange platform hardware base. One of the many outstanding features of this system was the built-in Relational Database Management System (RDMS) support. The system included a utility for defining databases, screens, and reports. This utility used a form named Data Description Specifications (DDS) to define the database physical (PF) and logical (LF) files (base tables, views, and indexes). In 1988, IBM announced the AS/400. The OS/400 operating system also contained a built-in RDMS, however, IBM offered Structured Query Language (SQL) as an alternative to DDS for creating databases. In addition, SQL Data Manipulation Language (DML) statements were made available as an ad hoc query language tool. These statements could also be embedded and compiled within high level language (HLL) programs. SQL Data Definition Language (DDL) has become the industry standard for defining RDMS databases. Many customers are in the process of modernizing their database definition and the database access. This IBM Redbooks publication will help you understand how to reverse engineer a DDS-created database along, and provides you with tips and techniques for modernizing applications to use SQL as the database access method. Additional Resources on DB2 for i Modernization:

The Organization for the Advancement of Structured Information Standards (OASIS) recently approved OpenDocument as standard. OpenDocument is "a royalty-free, XML-based file format that covers features required by text, spreadsheets, charts, and graphical documents." OpenDocument serves as the native file format for OpenOffice.org version 2 and future versions of KOffice. OASIS OpenDocument Essentials—Using OASIS OpenDocument XML shows you how to take advantage of this format. In addition to explaining the basics of OpenDocument, this book has examples showing how to extract information from, transform, and programmatically create OpenDocument files.

IBM Lotus software has created IBM Lotus Workplace, an integrated family of products based on open standards. Lotus Workplace combines market-leading collaborative components that can be used with a variety of security-rich clients for simplified access and interaction with other people and a host of collaborative applications such as e-mail, calendaring and scheduling, instant messaging, Web conferencing, team spaces, document and Web content management, and e-learning. IBM Lotus Workplace products include: This IBM Redbooks publication is an installation and deployment guide for the Lotus Workplace 2.0.1 platform. We provide detailed installation procedures for installing the Lotus Workplace products on both a Microsoft Windows 2000 server and a Linux server running SUSE LINUX Enterprise Server 8.1. We also discuss important deployment and planning scenarios, as well as tips, best practices, and techniques for troubleshooting errors during installation.

This IBM Redbooks publication will help you get started with MQSeries for VSE V2R1.2. It explores why and how to use MQSeries with the VSE operating system and shows why MQSeries is more than just another queuing system. This book is meant for those who know VSE but have only a slight understanding of MQSeries and how to use it. This book contains an overview of the MQSeries installation and configuration, explains how to connect clients to servers and servers to servers, how to trigger applications, and the MQI programming interface. It describes the command interface, how the libraries are used, and how to edit, compile, test, and debug a program. This book also provides information about performance and security for the MQSeries for VSE V2.1.2. It explains what has to be done to use MQSeries for communication between VSE and other platforms, such as OS/390 and Windows XP. Examples are given to guide the user through the administrative process of defining connections between different systems, and information regarding security, backup, and recovery is also provided.

The problem: Your boss has demanded a database, and you don't know how to create one. It doesn't matter that it's just a simple one (for tracking invoices, inventory, and contacts), or that flexible, powerful software (FileMaker Pro 7) has already been purchased. If you've never created a database before, the task can be daunting. The solution: This low-priced, compact guide! Recognizing that you don't necessarily want or need to know about every FileMaker Pro 7 feature, this focused, four-color volume demonstrates the quickest route to creating a functional, organized database-nothing more and certainly nothing less. Using large color illustrations and a minimum of verbiage, it provides the basics you need to get going without bogging you down with detailed explanations of all of FileMaker's intricacies. It also serves as the perfect jumping-off point for more extensive database exploration-for example, through FileMaker Pro 7: Visual QuickStart Guide.

The Easy, Visual Guide to IBM DB2 V8.2 IBM DB2 Universal Database™ V8.2 for Linux®, UNIX®, and Windows® is a flexible, scalable, cost-effective, and easy-to-use enterprise database. Now, one book makes DB2 even easier. teaches DB2 V8.2 visually, step by step, with dozens of examples and case studies drawn from the authors' unsurpassed experience as DB2 consultants at IBM. Understanding DB2 doesn't just present the big picture. It thoroughly introduces every DB2 concept, procedure, and tool you'll need to get results as an administrator, user, or developer. You'll find authoritative coverage of installation, configuration, objects, database instances, storage, connectivity, security, performance, backup and recovery, SQL fundamentals, and much more. Virtually every new concept is explained with screenshots, diagrams, or tables, all designed to help you learn faster and remember more. Understanding DB2 For those preparing for certification, this book also contains over a hundred sample questions crafted by the authors to reflect the content and format of the IBM DB2 UDB Database Administration Certification exams, with answers and detailed explanations. Coverage includes Understanding the DB2 product family, DB2 commands, and the DB2 environment Configuring client and server connectivity: walkthroughs of four typical scenarios Managing DB2 storage: partitions, tablespaces, buffer pools, and more Leveraging the power of SQL: queries, inserts, deletes, and updates Implementing security: encryption, authentication, and authorization Administering and maintaining data, from LOAD and EXPORT to backup/recovery Providing high availability with online split mirroring and suspended I/O DB2 architecture: process and memory models Managing database performance and troubleshooting

“Riordan covers core skills for any developer—database design and development—in a perfect amount of detail. This book should be on every professional developer’s reading list.” — Duncan Mackenzie, developer, Microsoft (MSDN) “Designing a database is not a trivial subject. Riordan brings experience and clear explanations to a fundamental part of software development.” — Patrick Birch, database and technical writing consultant “If you buy only one book on database design, make it this one. Riordan has a talent for explaining technical issues in simple language, without over simplifying.” — Brendan Reynolds, developer, Dataset IT Systems and Microsoft Access MVP “A book that will expertly guide you in how to develop a database for a client— and how to do it right the first time!” — Kenneth D. Snell, Ph.D., ACCESS developer and Microsoft Access MVP “Riordan has produced a unique book that brings together a formal, yet commonsense, approach to relational database design...and then goes further! Many database designers will find immense value in the steps to developing practical data warehouse designs. If you are seeking a framework for designing transactional databases, or want to step out into the world of analytical databases, Riordan’s book excels at bridging both worlds.” — Paul Irvine, vice president, engineering, Via Training “Riordan takes a complex subject and makes it easy. If you’re over your head on a database design project, this book will help bail you out!” — Mike Gunderloy, contributing editor, Application Development Trends “This book covers a wide range of database design and data modeling topics in a well-organized, easy to understand format.” — Amy Sticksel, Sticksel Data Systems, Inc. “In Riordan’s style, wit, and attention to detail are outstanding.” Designing Effective Database Systems, — Sandra Daigle, Microsoft Access MVP The Software Developer’s Step-by-Step Guide to Database Design World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren’t database experts. No matter how messy or complex your data challenge, shows you how to design an effective, high-performance database to solve it. Designing Effective Database Systems Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field’s clearest introduction to dimensional database modeling—practical insight for designing today’s increasingly important analytical applications. One task at a time, the author illuminates every facet of database analysis and design for both traditional databases and the dimensional databases used for data warehousing, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability. This book will teach you to Understand relational database models, structures, relationships, and data integrity principles Define database system goals, criteria, scope, and work processes Construct accurate conceptual models: relationships, entities, domain analysis, and normalization Build efficient, secure database schema Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more Architect and construct easy, efficient interfaces for querying and reporting Learn from practice examples based on Microsoft’s Northwind sample database Riordan has helped thousands of professionals master database design and development, earning Microsoft’s coveted MVP honor for her exceptional contributions. Nobody is more qualified to help you master database design and apply it in your real-world environment.

The need to integrate heterogeneous environments without replacing existing IT infrastructures is growing more and more. Standard application providers offer a wide range of business applications, running on different platforms, and implemented in different languages. A sophisticated Enterprise Service Architecture is required to overcome the challenges implied by such a heterogeneous infrastructure and make the whole enterprise controllable. The WebSphere Business Integration architecture provides different Integration brokers and a multitude of application and technology adapters. It is an essential software component in IBM's e-business on demand strategy. SAP Exchange Infrastructure is SAP’s strategic technology platform for process integration and connectivity of SAP components and non-SAP components. This IBM Redbooks publication illustrates how to integrate data and processes located in SAP back-end systems using WebSphere Business Integration middleware technology. It describes two WebSphere Business Integration adapters: IBM WebSphere Business Integration Adapter for SAP V5.5.0 These adapters are utilized to demonstrate the integration capabilities they provide. Please note that the additional material referenced in the text is not available from IBM.

Managing IT costs requires repeatable and measurable processes such as the best practices for service level management (SLM) documented in the IT Infrastructure Library (ITIL). Central to the ITIL best practices are the service management processes. These are subdivided into the core areas of service support and service delivery. This IBM Redbooks publication takes a top-down approach that starts from the business requirement to improve service management. This includes the need to align IT services with the needs of the business, to improve the quality of the IT services delivered, and to reduce the long-term cost of service provision. It focuses on how clients accomplish this by implementing SLM processes supported by IBM Tivoli Service Level Advisor and IBM Tivoli Business Systems Manager. For IT managers and technical staff who are responsible for providing services to their customers, use this book as a practical guide to SLM with IBM Tivoli products. It takes you from a general outline of SLM to specific implementation examples of banking and trading that incorporate the Tivoli monitoring products.

Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book provides: Clear and concise information on database administration with Oracle 10g Practical examples and insights drawn from the authors' real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards You'll also find authoritative coverage of key exam topics, including: Installing Oracle Database 10g Software Creating and Controlling Oracle Databases Administering Users Managing Schema Objects and Data Implementing Oracle Security Features Monitoring Performance Performing Database Backup and Recovery Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace

This IBM Redbooks publication describes how to install and configure the Cisco MDS 9000 family in an IBM Fibre Connection (FICON), Fibre Channel Protocol (FCP), and Fibre Channel over IP (FCIP) environment. We have tried to consolidate as much of the critical information as possible while covering procedures and tasks that are likely to be encountered on a daily basis. Each of the products described has much more functionality than we could ever hope to cover in just one book. The IBM/Cisco SAN portfolio is rich in quality products that bring a vast amount of technicality and vitality to the SAN world. Their inclusion and selection is based on a thorough understanding of the storage networking environment that positions Cisco and IBM, and therefore its customers and partners, in an ideal position to take advantage by their subsequent deployment. In this book we cover the latest announcements related to the IBM/Cisco SAN family. We show how these announcements and the products can be implemented in both a mainframe and an open systems environment. We address some of the key concepts that they bring to the market, and in each case, we give an overview of those functions that are essential to building a robust SAN environment in an effective and concise manner.

This book explains how to architect and deploy high availability (HA) solutions with Oracle Real Application Clusters (Oracle RAC) in a Sun™ Cluster 3.x environment. It presents information to help you decide when an Oracle RAC and Sun Cluster software solution is appropriate to satisfy the availability requirements of your business. In addition, this book explains the technology behind these products, describes successful customer deployments, and provides technical tips and preferred practice recommendations. This book features detailed case studies, including A large German bank that has implemented an Oracle RAC and Sun Cluster software solution to meet the ever-increasing business demands of the banking industry. One of the largest companies in Europe for alpine skiing that has implemented Oracle RAC and Sun Cluster software to support HA requirements in a consolidated environment. A benchmark case that describes the use of Oracle RAC with Sun’s Remote Shared Memory (RSM) technology to improve the performance of single-instance databases. A large financial institution that uses Sun Cluster’s HA Oracle agent to provide the necessary level of HA required for their database.

This IBM Redbooks publication provides an overview of the new functions and enhancements in IBM Information Management System (IMS) Version 9. IMS Version 9 contains over 50 enhancements, in all areas of the product. that address availability, scalability, capacity, usability, manageability, operations, on demand business, and application development requirements from its huge customer base. All of the enhancements in this new version resulted from specific customer requirements. The major enhancements include: Improved database availability for HALDB databases is provided by the long-awaited online reorganization (OLR) enhancement. The functionality of the IMS Connect product is included as an integrated function of IMS. DBRC provides a new API that allows assembler programs to query the RECON. IMS Java users will have new JDBC SQL calls and DLI Model Utility support for retrieving existing IMS data in XML format as well as storing, indexing, searching, and retrieving valid XML documents into new or existing IMS databases. We describe these enhancements and all other major changes in IMS Version 9. This book gives you the essential information that you need when you are migrating your IMS systems to IMS Version 9.

This IBM Redbook describes configuration management in general and how it is implemented in the Rational products ClearCase and ClearQuest. The target audience for this redbook is anyone considering a software configuration management (SCM) solution, and in particular, project managers and configuration management leaders responsible for medium and large UCM deployments. In Part 1 we introduce the general concept of software configuration management (SCM), and why software asset and lifecycle management is good business. We describe an SCM strategy that leads to the ClearCase and ClearQuest products. In Part 2 we provide the details for planning and implementing SCM using a ClearCase environment, focusing on the test environment, network, servers, and clients. In Part 3 we introduce ClearQuest, its terminology, the roles and responsibilities of the different types of users, and the infrastructure required for a UCM environment. We also provide the details for planning and implementing ClearQuest. In Part 4 we introduce unified change management (UCM) using ClearCase UCM and ClearQuest, including design considerations for an effective UCM implementation, and how UCM is used to manage complexity by raising the level of abstraction. In Part 5 we describe how to do parallel development in multiple geographical locations using ClearCase and ClearQuest MultiSite, including detailed procedures for planning and implementing MultiSite for a UCM environment.

Small and medium-sized businesses are among the fastest-growing segments of the global economy. As these businesses strive to capture opportunities in a rapidly changing marketplace, they often turn to independent software vendors (ISVs) for the IT solutions they need. Large enterprises also require customized solutions to help them stay competitive in the global marketplace. This IBM Redbooks publication describes how ISVs and corporate information technology centers can use IBM Integrated Runtime V1.1 to deploy solutions to their customers quickly and efficiently. By reducing the complexity of deploying complete solutions, Integrated Runtime shortens time-to-market for ISVs and reduces time-to-productivity for users. The result is efficient deployment of solutions by ISVs and corporate technology departments, rapid access to new solutions by users, and improved customer satisfaction. This book is intended for: Please note that the additional material referenced in the text is not available from IBM.

This IBM Redbooks publication discusses Portable Data Containers. Portable Data Containers are a tool that allows customers to migrate their applications from UNIX to Linux more seamlessly. They are a part of VERITAS Storage Foundations 4.0. With Portable Data Containers, a customer can migrate an application without moving that application's data. This book describes the concepts of storage management and the key features of VERITAS Storage Foundations 4.0 and . In addition, it discusses a number of considerations that you should review prior to a UNIX to Linux migration, and then takes you through a step-by-step migration from Solaris to Linux. It discusses the performance and scalability of Portable Data Containers and compares the throughput of Portable Data Containers with theoretical network throughput and disk transfer speeds. Finally, this book includes best practices for migrating applications to Linux using Portable Data Containers. In particular, it identifies the steps that are required to migrate an Oracle or DB2 database from a UNIX server to a Linux server. With this knowledge, customers can accelerate their migration plans to Linux to take advantage of the cost benefits provided by the open-source operating system. The audience for this book are IBM Clients and Business Partners as well as IT specialists and database administrators.

You own your own business. You have also created a website for your business that details the products or services that you offer, but it doesn't allow potential customers to purchase anything online. Don't risk losing business-learn to create a dynamic online environment using only three programs. PHP, MySQL and Apache are three popular open-source tools that can work together to help you create a dynamic website, such as an online shopping experience. Sams Teach Yourself PHP, MySQL and Apache All in One is a complete reference manual for all three development tools. Learn how they work individually and more importantly, how they work together to create your dynamic website. Use the book and the included CD to create a simple website, as well as a mailing list, online address book, shopping cart and storefront. Open your website to limitless possibilities with Sams Teach Yourself PHP, MySQL and Apache All in One.

This IBM Redbooks publication is a practical cookbook that provides up-to-date information about Cluster Systems Management (CSM) for AIX 5L for a pSeries environment. The book provides information about the latest CSM for AIX 5L enhancements, including implementation techniques, installation changes, installation tools, system management tools, monitoring tools, hardware control, file distribution, problem determination, and management server high availability. This book summarizes the latest news in CSM 1.4.0. It contains a Q&A chapter, a CSM installation scenario, a CSM advanced chapter, CSM migration scenarios, and a CSM cluster administration chapter. We include information about how to manage Linux nodes on pSeries hardware including operating system installation and node management in a mixed cluster environment. This book is targeted to technical professionals (consultants, IT architects, and IT specialists) who are responsible for providing pSeries clustering solutions.