CL800G DB2 9.8 pureScale Implementation and Control for DB2 LUW Administrators

Il centro presenta a continuazione il programma pensato per migliorare le tue competenze e permetterti di realizzare gli obiettivi stabiliti. Nel corso della formazione si alterneranno differenti moduli che ti permetteranno di acquisire le conoscenze sulle differenti tematiche proposte. Inscriviti per poter accedere alle seguenti materie.

• List the basic components and functions in a DB2 pureScale database system
• Describe the types of information managed in the Cluster Caching Facility for a DB2 pureScale database
• Explain how Remote Direct Memory Access (RDMA) is used to efficiently process requests within a DB2 pureScale database
• Describe the workload balancing and automatic client routing options used for application connections to a pureScale database
• List the steps used to perform restart light processing when a database member fails
• Compare some of the characteristics of a DB2 partitioned database to the cluster implementation used by a DB2 pureScale database

• Describe the use of local and global locking to support application concurrency in a DB2 pureScale database
• Explain the use of page level locks with a pureScale database
• Monitor lock related statistics for a a DB2 pureScale clustered database
• Explain how multiple log streams are used and managed for a pureScale database
• Describe the use of local and group buffer pools for reading pages with pureScale
• Monitor the buffer pool efficiency of local and group buffer pools
• Explain how page reclaims are used in pureScale databases to access pages being changed by multiple database members
• Describe how castout processing is used to perform page writes with DB2 pureScale databases

• Use db2start and db2stop commands to manage the components of a DB2 pureScale cluster
• Examine the db2instance command report to check the current status of the pureScale cluster
• Configure database manager and database member options for a DB2 pureScale cluster
• Invoke the db2iupdt command to add or remove database members or cluster caching facilities from the cluster
• Quiesce a host system in a pureScale cluster to perform system maintenance
• Explain how Automatic Client Reroute is used to maintain high availability for application client systems
• Implement transaction-level workload balancing for application client systems to improve cluster resource usage
• Configure client affinity for application systems that need to control connections to specific database member host systems

• Explain the difference between Member Crash Recovery and Group Crash Recovery
• Plan for online or offline database BACKUP for a DB2 pureScale database
• Use the RESTORE utility or the RECOVER DATABASE command to perform database recovery or to make a database copy for a pureScale database
• Describe the impact of database cluster topology changes on database backup and recovery operations
• Explain the impact of multiple log streams for database roll forward processing with a standby database copy

• Select a set of supported system hardware and software components for a DB2 pureScale cluster
• Perform the pre-installation planning to insure the system software includes all necessary functions and service levels
• Choose the cluster interconnect network options for the pureScale cluster
• Estimate Cluster Caching Facility (CF) CPU and memory resources that will be needed to support your databases in the cluster
• Set the DBM and database configuration options and DB2 registry variables used to allow multiple active databases
• Perform the DB2 pureScale feature installation for the DB2 cluster

• List the steps required to migrate an existing DB2 9.7 database system to a DB2 9.8 pureScale cluster
• Select the best method to migrate any non-automatic storage table spaces into automatic storage table spaces based on the application requirements and current database structure
• Implement the GPFS file systems planned to support the DB2 pureScale database

• Use the db2cluster command to create the GPFS file systems needed to support DB2 pureScale databases
• Describe the difference between DB2 managed and user managed GPFS file systems
• Select the number of automatic storage paths that will be used to support the DB2 databases
• Create a new DB2 pureScale database using GPFS based file systems
• Use the db2cluster command to add and drop disk devices with DB2 managed GPFS file systems
• Utilize the - rebalance option of db2cluster to improve efficiency of DB2 managed GPFS file systems

• Monitor application activity in a DB2 pureScale database cluster
• Utilize db2pd commands to display Cluster Caching Facility memory allocations and connection pool information
• Use the db2instance and db2cluster commands to show the current status and alter information for database members and cluster hosts
• Query the DB2 cluster status using SQL functions and views
• Perform problem determination using the diagnostic messages generated by the DB2 instance and Cluster Caching facilities
• Use TSA lssam report to view status of cluster resources
• Examine the message logs maintained by DB2 Cluster Services components

• Unit 1: DB2 pureScale Database Concepts
• Unit 2: Inside a DB2 pureScale database
• Unit 3: Managing a DB2 pureScale Database Cluster
• Unit 4: DB2 pureScale Database Backup and Recovery

• Unit 5: Planning and Installation for a DB2 pureScale Database Cluster
• Unit 6: Migrating a DB2 LUW database to a DB2 pureScale Database Cluster
• Unit 7: Storage Management for a DB2 pureScale Database Cluster
• Unit 8: Monitoring and Problem Determination for a DB2 pureScale Database Cluster

Dotazione:
Each participant will have a station set up with operating systems and software needed for the exercises.