The course provides detailed coverage of the operation of IBM's DB2 UDB for z/OS and OS/390 Version 7 database management system. It is intended for operators and operations analysts. The course includes practical exercises.
3 days
1 Relational Database Concepts 2 DB2 Features - What is DB2? - What is SQL? - DB2I. 3 DB2 Objects - Tables. - Storage Groups and Databases. - Tablespaces: Simple, Segmented, and Partitioned. - Indexes. - Free Space and Compression. - Large Objects. - DB2 Catalog and Directory. 4 Software Structure - Operational Environment. - DB2 Address Spaces. - Connections and Threads. - RDS, Data Manager and Buffer Manager. - Buffer Pools. 5 Housekeeping Utilities - Invoking Utilities. - Load and Cross Loader. - Reorg. - Runstats. - Check. - Unload. 6 Backup & Recovery - Why Recovery? - Logs and BSDS. - Copy and Recover. - Dynamic Utilities. 7 Basic Operation - DB2 Definition. - Starting DB2. - Stopping DB2. - DB2 Commands. - DB2 Messages. 8 Controlling DB2 Databases - -START DATABASE. - -STOP DATABASE. - -DISPLAY DATABASE. - Object States. 9 Controlling Utilities - Controlling Utilities. - -DISPLAY UTILITY. - -TERM UTILITY. - -ALTER UTILITY. - Restarting Utilities. 10 Controlling IRLM 11 Controlling Connections - TSO Connections. - CICS Connections. - IMS Connections. - Two Phase Commit. - Resolving In-Doubt URs. 12 Tracing Facilities - DB2 Instrumentation Facility. - Monitoring & Reporting. - Trace Types. - Trace Commands. 13 Controlling DDF, Stored Procedures, and UDFs 14 Data Sharing - Overview. - Console Messages. - DB2 Commands. - MVS XCF Commands. - Retained Locks. - Command Scope.