The course provides detailed coverage of DB2 for z/OS System Recovery and Restart. It is intended for DBAs, systems programmers and anyone responsible for system-wide recovery.
Technical support staff that will be working with DB2, this includes system administrators, database administrators, systems programmers and operations support staff.
A basic understanding of z/OS operations, transaction processing, TSO and database fundamentals. A basic understanding of DB2 or attending Verhoef Training's Introduction to DB2 course would be helpful.
Course Objectives:The DB2 operational environment
Operational procedures and support
Proper backup and recovery procedures
DB2 commands and responses
How to utilise the various DB2 utilities and service aids
Pinpointing potential integrity problems
How to recover from system failures
How to recover the system objects (BSDS, LOGS, CATALOG and DIRECTORY)
How to recover database objects
Disaster recovery scenarios
Delegates will gain an understanding of how to operate DB2 in an MVS environment, to control the DB2 attachment interfaces and recover DB2 from a wide range of problems and/or DB2 databases.
In particular it will cover:
Key Topics:DB2 Concepts and Facilities
DB2 Basic Operations Environment
Monitoring and Controlling DB2
Database Backup and Recovery
Managing the Logs and BSDS
Termination and Restart
Additional Discussion Topics
DB2 utility termination and restart
DB2 system object recovery
DB2 disaster recovery
Last modified: 05-Jan-2016