Course Description

DB2 Operations

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page

Benefits

Students who complete this course will learn the operational aspects of DB2  and how application programs access DB2 resourses. They will also learn how to invoke DB2 utilities, issue appropriate commands, monitor the DB2 subsystem, and resolve operational problems.

Audience

Operational personnel who need to work with DB2 systems and who provide operational support for applications that make use of DB2.

Prerequisites

The student should have experience using TSO/ISPF, and have an understanding of MVS data set concepts.

IBM Materials Required

DB2 Command Reference
DB2 Utility Guide and Reference
DB2 Messages and Codes

• Relational data base concepts
• DB2 concepts
• DB2 address spaces
• DB2 interfaces
• SQL - SELECT
• COMMIT / ROLLBACK
• DB2 objects
• SPUFI
• DB2 system catalog
• DB2 commands
• BIND / REBIND / FREE
• Security and Authorization
• Locks
• Problem diagnosis
• DB2 utilities
• DB2 logs
• Batch processing methods
• Threads
• Monitoring performance

Exercises

There are six standard machine exercises, and one optional machine exercise.