This IBM Redbooks publication explains the benefits and technical merits of integrating IBM Tivoli Workload Scheduler Distributed and IBM Tivoli Workload Scheduler for z/OS with other IBM products. Scheduling is a mission critical process for any company. However, when you talk about scheduling, you are really talking about an ecosystem. In this ecosystem, each solution is a building block that adds value to the overall solution. With IBM Tivoli Workload Scheduler, you can collect and add data to and from each component. In addition, expanding the scheduling ecosystem to include monitoring, management, help desk, storage, and business systems management provides greater value. Please note that the additional material referenced in the text is not available from IBM.

Mid-market companies are looking for complete solutions from the solution providers who know their businesses and specialize in a particular solution category such as warehouse management or supply chain integration, within their industry. In order to provide an environment for the business solution, either the solution provider or the end customer must obtain the software needed to run the provider’s application program. This software normally consists of a database, a Web server, and an application server. These components, which are not actually part of the business solution, but are required to support the application program, are called middleware. The process of obtaining, installing, configuring, and supporting the middleware components is a complex process for the solution provider, who currently has to absorb the cost of setting up the environment. The provider has to work with multiple suppliers who have multiple terms and conditions, different license structures, and multiple departments to work with on the contracts and support structures, all of which leads to added infrastructure costs and inefficiency. IBM designed the Express Runtime offering to address the needs of the solution providers serving mid-market customers. The main design criteria were reducing complexity for the providers by offering a pre-integrated and pre-configured middleware solution with a single contract, one license, one set of contracts, and a very competitive price. With Express Runtime, you get WebSphere Application Server - Express, DB2 UDB Express, and IBM HTTP Server with a single install, one contract, and a significantly lower cost compared to purchasing the individual components. Express Runtime includes quick start samples and documentation to get you up and running quickly and easily. Please note that the additional material referenced in the text is not available from IBM.

As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too-- no programming experience required! After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage. Best of all, the book's examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database..

The systems management hardware that is part of IBM xSeries and BladeCenter servers serves as an important part of the overall management strategy for customers. This hardware, either integrated into the server or BladeCenter chassis, installed at the factory as an adapter, or available as an option, provides vital information back to the administrator and gives the administrator the ability to remotely control the server, even when the operating system is not running.

Blade servers are a relatively new technology. They have captured industry focus because of their modular design, which can reduce cost with a more efficient use of valuable floor space. They offer simplified management, which can help to speed such tasks as installing, reprovisioning, updating, and troubleshooting hundreds of blade servers. You can do all of this remotely using one graphical console with IBM Director systems management tools. In addition, blade servers provide improved performance by doubling current rack density. By integrating resources and sharing key components, costs decrease and availability increases. The IBM eServer BladeCenter boasts innovative modular technology, leadership density, and availability. It was designed to help solve a multitude of real-world problems. This IBM Redbooks publication takes an in-depth look at the IBM eServer BladeCenter JS20. This is a two-way blade server for applications requiring 64-bit computing. It is ideal for computer-intensive applications and transactional Internet servers. This book helps you to install, tailor, and configure the IBM eServer BladeCenter JS20.

This IBM Redbooks publication is a study guide for IBM Tivoli Configuration Manager Version 4.2.2 and is aimed at the people who want to get IBM Certifications in this specific product. The IBM Tivoli Configuration Manager Certification, offered through the Professional Certification Program from IBM, is designed to validate the skills required of technical professionals who work in the implementation of the IBM Tivoli Configuration Manager Version 4.2.2 product. This book provides a combination of theory and practical experience needed for a general understanding of the subject matter. It also provides sample questions that will help in the evaluation of personal progress and provide familiarity with the types of questions that will be encountered in the exam. This publication does not replace practical experience, nor is it designed to be a stand-alone guide for any subject. Instead, it is an effective tool that, when combined with education activities and experience, can be a very useful preparation guide for the exam. Please note that the additional material referenced in the text is not available from IBM.

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.

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.

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:

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 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

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.

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 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.