AUDIENCE:   Technical Support staff who will be working with IBM’s DB2 for z/OS database management system. DBA’s, Systems Programmers and Operators in particular will find the content ideally suited. PREREQUISITES:   A basic understanding of z/OS Operations, Transaction Processing, TSO and Database fundamentals. A basic understanding of DB2 or attending Verhoef's DB2 Overview course would be helpful. DURATION:   3 days. Hands on. OBJECTIVES:   The course provides detailed coverage of the operation and recovery of IBM's DB2 for z/OS database management system. COURSE CONTENT:   DB2 Objects Tables. Storage Groups and Databases. Tablespaces: Simple, Segmented, and Partitioned. Indexes. Free Space. Large Objects. DB2 Catalog and Directory. Software Structure DB2 Address Spaces. Connections and Threads. RDS, Data Manager and Buffer Manager. Buffer Pools. Basic Operation DB2 Definition. Starting and Stopping DB2. DB2 Commands. DB2 Messages. Controlling DB2 Databases START DATABASE. STOP DATABASE. DISPLAY DATABASE. Controlling Utilities DISPLAY UTIL. TERM UTIL. Restarting Utilities. Controlling IRLM Controlling Connections TSO, CICS, and IMS Connections. Two Phase Commit. Tracing Facilities Recovery Overview DB2 Utilities Standard Recovery Utilities. Utilities that Impact Recovery. Stand Alone Utilities. Invoking Utilities. Standard Backup and Recovery Image Copy, Recovery, and Index Recovery. Mergecopy, Report Recovery, and Modify. Concurrent Copy and Inline Image Copies. Recovery Data Data Object States Possible Statuses. Changing States. Resetting States set by DB2. Check Data, Check LOB, Check Index. Repair. Error Range and LPL. Recovery to a Prior Point in Time Point of Consistency. Quiesce and Report Tablespaceset. Recovery to POC. Catalog & Directory Recovery Subsystem Shutdown & Restart Shutdown. Restart Processing. Resolving In-Doubt URs. Deferred Restart. Log and BSDS Failures Log and BSDS Errors. Print Log Map and Change Log Inventory Utilities. Conditional Restart. Disaster Recovery