Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course Overview The course provides detailed coverage of the operation and recovery of IBMs DB2 UDB for OS/390 database management system. Audience Technical Support staff who will be working with IBMs DB2 UDB for OS/390 database management system. DBAs, Systems Programmers and Operators in particular will find the content ideally suited Prerequisites A basic understanding of OS/390 Operations, Transaction Processing, TSO and Database fundamentals. A basic understanding of DB2 or attending The Introduction to DB2 course would be helpful Course Outline - 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
How to make a booking for the DB2OU course
|
