IBM CL801G - DB2 10.5 pureScale Implementation and Management for DB2 LUW Administrators

Objectives:List the basic components and functions in a DB2 pureScale database system, including DB2 Cluster Services and GPFS file systemsDescribe the types of information managed in the Cluster Caching Facility (CF) for a DB2 pureScale databaseExplain how page reads utilize local buffer pools on a member as well as the global buffer pool on the CFDescribe the workload balancing and automatic client routing options used for application connections to a pureScale databaseDescribe the use of local and global locking to support application concurrency in a DB2 pureScale databaseList the components that interact with DB2 Cluster Services to manage cluster availabilityUse db2start and db2stop commands to manage the components of a DB2 pureScale clusterExamine the db2instance command report to check the current status of the pureScale clusterConfigure database manager and database member options for a DB2 pureScale clusterChoose the cluster interconnect network options for the pureScale clusterEstimate Cluster Caching Facility (CF) CPU and memory resources that will be needed to support your databases in the clusterPerform an installation of DB2 pureScale creating a DB2 instance and configuring the cluster hostsList and describe the steps required to migrate an existing non-pureScale database system to a DB2 10.5 pureScale clusterSelect the best method to migrate any non-automatic storage table spaces into automatic storage table spaces based on the application requirements and current database structurePlan for online or offline database BACKUP for a DB2 pureScale databaseUse the RESTORE utility or the RECOVER DATABASE command to perform database recovery or to make a database copy for a pureScale databasePlan and implement High Availability Disaster Recovery (HADR) for a DB2 pureScale databaseDescribe how a DB2 pureScale cluster handles failures of membersExplain how the DB2 Cluster Services component detects various cluster problems like network failures or shared file system issuesCreate a new DB2 pureScale database using GPFS based file systemsUse the db2cluster command to add and drop disk devices with DB2 managed GPFS file systemsMonitor application activity in a DB2 pureScale database clusterUtilize db2pd commands to display Cluster Caching Facility memory allocations and connection pool informationUse the db2instance and db2cluster commands to show the current status and alter information for database members and cluster hostsExplain the states shown in the db2instance –list report for pureScale members, hosts and CFsLocate the various message logs for the DB2 instance, GPFS and TSAUse the db2cluster command to list and clear active alertsImplement transaction-level workload balancing for application client systems to improve cluster resource usageSet DB2 client options for non-Java applications in the db2dsdriver.cfg fileConfigure client affinity for application systems that need to control connections to specific database member host systemsExplain how member subsets can be used to manage how an application views the topology of the pureScale database environment