Overview

This course is designed to prepare DB2 Linux, UNIX and Windows database administrators for planning, installing, managing and monitoring a DB2 pureScale database system. This course covers the features and functions of the DB2 pureScale feature for DB2 10.5, including fixpack levels 4 and 5. This is a lecture-only course.

Skills Covered

  • List the basic components and functions in a DB2 pureScale database system, including DB2 Cluster Services and GPFS file systems
  • Describe the types of information managed in the Cluster Caching Facility (CF) for a DB2 pureScale database
  • Explain how page reads utilize local buffer pools on a member as well as the global buffer pool on the CF
  • Describe the workload balancing and automatic client routing options used for application connections to a pureScale database
  • Describe the use of local and global locking to support application concurrency in a DB2 pureScale database
  • List the components that interact with DB2 Cluster Services to manage cluster availability
  • 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
  • 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
  • Perform an installation of DB2 pureScale creating a DB2 instance and configuring the cluster hosts
  • List and describe the steps required to migrate an existing non-pureScale database system to a DB2 10.5 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
  • 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
  • Plan and implement High Availability Disaster Recovery (HADR) for a DB2 pureScale database
  • Describe how a DB2 pureScale cluster handles failures of members
  • Explain how the DB2 Cluster Services component detects various cluster problems like network failures or shared file system issues
  • 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
  • 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
  • Explain the states shown in the db2instance –list report for pureScale members, hosts and CFs
  • Locate the various message logs for the DB2 instance, GPFS and TSA
  • Use the db2cluster command to list and clear active alerts
  • Implement transaction-level workload balancing for application client systems to improve cluster resource usage
  • Set DB2 client options for non-Java applications in the db2dsdriver.cfg file
  • Configure client affinity for application systems that need to control connections to specific database member host systems
  • Explain how member subsets can be used to manage how an application views the topology of the pureScale database environment

Who Should Attend

This intermediate course is intended for experienced DB2 LUW database administrators.

Course Curriculum

Prerequisites

  • DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3G) or
  • DB2 10 for LUW: Basic Administration for AIX (CL213G) or
  • DB2 10 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL485G)
  • Or have equivalent experience.

Download Syllabus

Request More Information

Training Options

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Frequently Asked Questions