DB2 10.5 pureScale Implementation and Management for DB2 LUW Administrators (CL801G)  Training Logo

DB2 10.5 pureScale Implementation and Management for DB2 LUW Administrators (CL801G) Training

Live Online & Classroom Enterprise Certification Training

Powered By

IBM Logo

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

ATP_Authorized Logo

Powered By

IBM Logo

Looking for a private batch ?

REQUEST A CALLBACK

Need help finding the right training?

Your Message

  • Certified Trainer

  • Authorized Courseware

  • Completion Certificate from ATP

  • Enterprise Reporting

  • Lifetime Access

  • CloudLabs

  • 24x7 Support

  • Real-time code analysis and feedback

What are the objectives of DB2 10.5 pureScale Implementation and Management for DB2 LUW Administrators (CL801G) Certification Training ?

  • 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 is DB2 10.5 pureScale Implementation and Management for DB2 LUW Administrators (CL801G) Certification Training for?

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

What are the prerequisites for DB2 10.5 pureScale Implementation and Management for DB2 LUW Administrators (CL801G) Certification Training?

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.

Available Training Modes

Live Online Training

18 Hours

Classroom Training

3 Days

Who is the instructor for this training?

The Trainer is IBM certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Course Logo

DB2 10.5 pureScale Implementation and Management for DB2 LUW Administrators (CL801G) Certification Training - Certification & Exam

  • SpringPeople is the Authorized Training Partner of IBM through Tech Data
  • For any queries, feel free to reach us at ibm@springpeople.com

Reviews