This IBM Redbooks® publication is divided into several sections to share the following experiences that are gained while Oracle Database 11gR2 is installed and tested:
Interested readers include database consultants, installers, administrators, and system programmers. This book is not meant to replace Oracle documentation but to supplement it with our experiences while Oracle products are installed and used.
Its primary objective is to bring together in one place information that is already available, but widely dispersed. It also presents a different perspective on planned outage avoidance. Most businesses care about application availability rather than the availability of a specific system. Also, a planned outage is not necessarily a bad thing, if it does not affect application availability. In fact, running for too long without an IPL or subsystem restart might have a negative impact on application availability because it impacts your ability to apply preventive service. Therefore, this book places more focus on decoupling the ability to make changes and updates to your system from IPLing or restarting your systems.
We discuss the collection of statistics for the verification of performance of the various components of the DB2 system and accounting for tracking the behavior of the applications.
We have intentionally omitted considerations for query optimization; they are worth a separate document.
Use this book to activate the right traces to help you monitor the performance of your DB2 system and to tune the various aspects of subsystem and application performance.
Underlying the operation of any database management system are the utilities. With the number of database objects growing exponentially, managing utility jobs, meeting service level agreements (SLAs), and ensuring recoverability can be overwhelming. IBM offers DB2 Tools solution packs that assist in the DB2 utilities management process. Solution packs combine several products into a single consolidated solution providing everything necessary to ensure the execution of a set of database administration functions. The goals are to reduce the operational complexity and reduce cost.
The objective of this IBM Redbooks® publication is to document the added value in terms of productivity and performance for database administrators when using the IBM DB2 Utilities Solution Pack and the IBM DB2 Fast Copy Solution Pack. We show the functions of the tools provided by the solution packs as used in real-life scenarios and adopting utilities best practices.
This book is one of a series of IBM Redbooks publications that take a modular approach to providing information about the updates that are included within z/OS V2R2. This approach has the following goals:
- Provide modular content
- Group the technical changes into a topic
- Provide a more streamlined way of finding relevant information that is based on the topic
We hope you find this approach useful. We value your feedback.
This IBM Redbooks® publication shares experiences that are gained while installing and testing Oracle Database 12c Release 1:
This IBM Redbooks® publication provides information to help you evaluate and implement Linux-HA release 2 by using Heartbeat 2.0 on the IBM System z platform with either SUSE® Linux Enterprise Server version 10 or Red Hat® Enterprise Linux® 5. To begin, we review the fundamentals of high availability concepts and terminology. Then we discuss the Heartbeat 2.0 architecture and its components. We examine some of the special considerations when using Heartbeat 2.0 on Linux on System z, particularly Linux on z/VM®, with logical partitions (LPARs), interguest communication by using HiperSocketsTM, and Shoot The Other Node In The Head (STONITH) by using VSMSERVE for Simple Network IPL (snIPL).
By reading this book, you can examine our environment as we outline our installation and setup processes and configuration. We demonstrate an active and passive single resource scenario and a quorum scenario by using a single resource with three guests in the cluster. Finally, we demonstrate and describe sample usage scenarios.
Many environments today are heterogeneous with a high quantity and diversity of data. In this IBM® Redbooks® publication, we help enterprise architects and IT managers with these environments make decisions for a centralized database or data warehouse. We recommend a centralized data management environment on Linux® on System z®. We include guidance for IBM z/VSETM and Linux specialists to reorganize existing IBM DB2® VSE data and build a database environment with continuous operation in Linux on System z.
We begin this book by describing the possibilities and advantages of enterprise data management and different technical ways to realize it. Then we discuss planning, which is important for setting the foundation of the architecture that is implemented. We explain the hardware considerations for capacity and performance planning. For the z/VSE system and Linux on System z, we describe considerations for operation in a logical partition (LPAR) and in a virtualized environment with IBM z/VM®. In addition, we discuss the disk behavior for different workloads, storage dependencies, network connections, and DB2 database considerations.
We also guide you in customizing the DB2 server for z/VSE, z/VM, and DB2 on Linux to allow existing z/VSE and z/VM applications to access the database on Linux on System z. We include the data migration, application considerations, dependencies, compatibility, monitoring, and tuning possibilities in such an environment.
The size of the LPAR or z/VM resources depends on the workload and the applications that run that workload. We examine a typical web server environment, Java applications, and describe it by using a database management system, such as IBM DB2®.
Network decisions are examined with regards to VSWITCH, shared Open Systems Adapter (OSA), IBM HiperSocketsTM and the HiperPAV, or FCP/SCSI attachment used with a storage area network (SAN) Volume Controller along with performance and throughput expectations.
The intended audience for this IBM Redbooks publication is IT architects who are responsible for planning production environments and IT specialists who are responsible for implementation of production environments.
This book assumes that you have a general familiarity with System z technology and terminology. It does not assume an in-depth understanding of z/VM and Linux. It is written for those clients who want to get a quick start with z/VM and Linux on the mainframe.