DB2 Administration

This course will cover DB2 Physical Storage, Data Definition, Application Programming Considerations, Load Related Utilities, Performance Issues, Referential Integrity Implications, DB2 Catalog, Security end Auditing, and the Backup and Recover Processes.

Application programmers may find this course to be an excellent tool to sharpen their DB2 skills helping them to bridge the traditional gap between programmers and database administrators.

Target Audience:

Project managers, team leaders, data analysts, database administrators, systems administrators and systems programmers who will be working with DB2.

Recommended Prerequisites:

Some experience with MVS and TSO is assumed as well as introductory level knowledge of DB2

Course Objectives:

Upon completion of this course, student should be able to:

• Install the DB2 product and related attachments

• Alter the install parameters with DSNZPARM overrides

• Describe DB2 storage management techniques

• Implement a DB2 database and it's performance considerations.

• Manage the system objects

• Manage the DB2 life-cycle

• Perform a DB2 design review for proper working set and performance estimates

• Implement DB2 security control

• Describe the DB2 effect on standards and procedures

Key Topics:

• Introduction to relational database systems

• Using SQL for data definition

• Using SQL for basic data retrieval

• Using SQL for advanced data retrieval

• Using SQL for data modification