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

Home

distance-learning center

Distance-learning Distance-learning_Building

Professional Distance-learning

IT Training Services

MFRDB57

 Db2: Database Administration - Advanced
DURATION: 4 days

FEE: $1,980

PRIVATE GROUP FEE: $
Based upon a class size of six students.

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

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Programmer
  • Database Administrator
  • IT Professional
  
   

DATES:

 CONTENT AND OBJECTIVES:
    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.
    Virtual Classroom   Blended Learning    

↓
Synchronous
Instruction		 Asynchronous
Instruction

Effective February 27, 2012, the course dates listed on the CETi 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. CETi makes no representation regarding ownership in any of the software products that we train on.

CETi 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 CETi course and that the employer has a licensed version of the software.

Certain courses only should be taught by the source software company training company and open source purveyor.