Price for this course



Classroom IBM


Available dates

Mon22Mar 21 TO Wed24Mar 21


Tech Data ILO UK
Connection details will be communicated separately
Instructor Led


Mon21Jun 21 TO Wed23Jun 21


Tech Data ILO UK
Connection details will be communicated separately
Instructor Led




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.


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


You should have taken:

  • 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.


  • 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

Course Outline

  • Unit 1: DB2 pureScale Database Introduction
  • Unit 2: Inside a DB2 pureScale database
  • Unit 3: Managing a DB2 pureScale Database Cluster
  • Unit 4: Planning a DB2 pureScale Database Cluster
  • Unit 5: Installation for a DB2 pureScale Database Cluster
  • Unit 6: Migration to DB2 pureScale from a non-pureScale DB2 database
  • Unit 7: DB2 pureScale Database Backup and Recovery Considerations
  • Unit 8: DB2 pureScale High Availability Behavior
  • Unit 9: Storage Management for a DB2 pureScale Database Cluster
  • Unit 10: DB2 pureScale monitoring and performance management
  • Unit 11: Problem Determination for a DB2 pureScale Database Cluster
  • Unit 12: Managing DB2 pureScale Client Availability and Workload Management


What do I need to bring with me to my public class?

All required learning materials and equipment are provided in the classroom.





When do public training course fees have to be paid?

For public training classes payment must be received no later than three business days prior to the first day of class in order to remain in the class and confirm your seat. Failure to provide payment by this date may result in removal from the class, and/or late cancellation fees applied. You can submit payment in the form of a Purchase Order or credit card.





On-site (private) Course Pricing:

To find out more about On-site training e-mail us at enablement@agilesolutions.co.uk or call one of our offices.





What is the cancellation policy?

Requests for cancellations or date transfers need to be received at least ten (10) business days prior to the event start date in order to receive a full refund. If a cancellation or reschedule request is received less than ten (10) business days before the start date, the penalty of 100% of the cost of the course will be applied, resulting in no amount of the fee being refunded. Refunds will not be allowed for “no-shows” in our public training or IVA courses. This cancellation policy is strictly enforced.





What happens if Agile Solutions needs to cancel or reschedule a course?

Agile Solutions reserves the right to cancel events for any reason at any time. Cancellation liability for Agile Solutions, if Agile Solutions cancels the course, is limited to the return of course payment ONLY. Agile Solutions will not reimburse registrants for any other costs including but not limited to any travel cancellation fees or penalties, including airfare and hotel costs. PLEASE NOTE: If your registration status is either “Approved”, or “Pending Payment” you have not been confirmed for the class and it is recommended that you do not make any travel arrangements until you have received a confirmation e-mail letting you know the class and registration is confirmed.





How will I know if my course has been rescheduled?

Agile Solutions reserves the right to reschedule or cancel a course due to low enrollment or if necessitated by other circumstances. Agile Solutions will contact you via e-mail or phone to inform you of the change of schedule. Once you have been notified you may reschedule or receive a full credit. Agile Solutions shall not be liable for any other costs including but not limited to any non-refundable travel arrangements if a course is rescheduled or cancelled.