DB2 for z/OS Operations and Utilities UK Classes & Lessons (IBM DB2)

Talk to a Training Advisor

Tel. 0800 652 0202

Availability (sort by: location | date)

Request availability by clicking a date.

England

Somerset

Bath (BA1) 06/11/08 £ 650

Prices exc. VAT. Courses are vendor approved.

Need help? Contact us now.

Also known as: DB2OUGB

About this class

The course provides detailed coverage of the operation and recovery of IBMs DB2 UDB for OS/390 database management system.

Who will the lesson benefit?

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

What prerequisites are required

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

Contents of this class

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