DB2 Operations

Course Number:  598-TF
Recommended Duration:  3 days

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

Course Overview
This course is designed to help operational personnel work with DB2 commands, utilities, and resources.  In addition to including an overview of DB2 concepts, the course provides hands on exercises for DB2 operators.

Objectives
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.

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

Topics

• 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