DB2 Operations

    

Summary:
This course introduces students to the concepts of relational databases and the strengths of DB2. It covers the major components of DB2 and their fit into the OS/390 environment.

Duration:
2 Days/Lecture & Lab

Audience:
The course is designed for operation personnel who need to gain a better understanding of DB2 and its environment.

Topics:

• Constructs and Concepts
• How DB2 fits into the MVS environment
• Batch and On-line Execution
• Application SQL
• DB2 Catalog, Indexes, Optimizer and Security
• Batch and On-line Utilities
• Reliability in the Production Environment
• Performance Monitoring, Reporting and Tuning

Prerequisites:
Students should have a basic understanding of DB2 terminology and concepts.

Last Update: May 20, 2012