G551 DB2 Operations

Course Code: G-551
Recommended Duration: 3 Days

Benefits

Students who complete this course will learn the operational aspects of DB2 and how application programs access DB2 resources. 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 z/OS data set concepts..

Related IBM Materials

Classroom access to a set of DB2 Reference manuals is desirable, but not required.

Major Topics Include

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.

Course Description

DB2 Operations