- 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
Dein INCAS Team
powered by Borlabs Cookie