Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Db2: Database Administration - Advanced


distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services


Db2: Database Administration - Advanced
DURATION: 4 days

FEE: $1,980

Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

There is a surcharge associated with training two or fewer students.


  • Programmer
  • Database Administrator
  • IT Professional


    1. Locking
      • Collect lock event data and generating lock reports.
    2. Monitoring
      • Obtain a snapshot of all databases in an instance to provide general statistics.
    3. Problem determination
      • Inspect a database for integrity, testing the pages of the database for page consistency such as an index to data.
    4. Parallelism
      • Observe the degree of parallelism used at run-time.
    5. Tablespace Management
      • Allocate spaces using Database Managed Storage and check current disk space.
    6. Data Movement
      • Compare the execution speed of an import and a load.
    7. Table Reorganization
      • Update table and index statistics in the catalogs using the db2nodes.cfg file.
    8. Db2 Stored Procedures
      • Invoke a built-in routine to execute an administrative command.
    9. Multiple Dimension Clustering
      • Identify the advantages and performance concerns.
    10. Automatic Db2 Utilities
      • Configure automatic maintenance and include backup and reorganization of data in tables.

    Web-based Training   Blended Learning    


Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.