We are happy to advise you!
+49 40 253346-10     Contact
> > > CL464G

Db2 11.1 Advanced Database Administration (CL464G)

 

Who should attend

This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases

Prerequisites

  • Perform basic database administration tasks for a Db2 database server, including using Db2 commands like BACKUP and RESTORE
  • Utilize Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
  • These skills can be developed by taking:
    • CL207 Db2 11.1 Administration Workshop for Linux

Course Content

This course is designed to teach you how to: • Perform advanced monitoring using the Db2 administrative views and routines in SQL queries. • Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer. • Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation. • Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images. • Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. • Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements. • Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity. • Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory. • Adjust database or Db2 instance configuration options to improve application performance or processing efficiency. • Implement Db2 Self Tuning Memory management for specific database memory areas.

 

Classroom Training

Duration 2 days

Price (excl. tax)
  • Germany: 1,490.- €
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Digital courseware
 
Click on town name to book Schedule
Germany
16/09/2019 - 17/09/2019 Münster
04/11/2019 - 05/11/2019 Frankfurt
18/05/2020 - 19/05/2020 Hamburg
09/11/2020 - 10/11/2020 Frankfurt
Switzerland
18/11/2019 - 19/11/2019 Zurich
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!