The course provides the information needed to administer IBM's DB2 for z/OS Version 7 or Version 8 database management system. It is intended for DBAs and others who need a similar level of knowledge. Students should have a basic knowledge of z/OS MVS. The course includes practical exercises.
5 days
1 Relational Database Concepts 2 DB2 Features 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 Physical Database Organisation 5 Program & User Interface - The SQL Language. - Dynamic and Static SQL. - End User Access. 6 Reading Data - Select. - Functions and Group By. - Arithmetics. - Join, Subquery, and Union. 7 Software Structure - Operational Environment. - Connections and Threads. - RDS, Data Manager and Buffer Manager. - Buffer Pools. 8 Updating & Integrity Control - Adding, Deleting and Updating Rows. - Concurrency and UOW. - Locking, Commit and Rollback. - Constraints. 9 Housekeeping Utilities - Load, Unload, and Reorg. - Runstats and Check. 10 Backup & Recovery - Logs and BSDS. - Copy and Recover. - Dynamic Utilities. 11 Security 12 Third Party Utilities 13 Other Things 14 Basic Operation - DB2 Definition. - Starting and Stopping DB2. - DB2 Commands and Messages. 15 Controlling DB2 Databases - -START DATABASE. - -STOP DATABASE. - -DISPLAY DATABASE. - Object States. 16 Controlling Utilities - Controlling Utilities. - -DISPLAY UTIL. - -TERM UTIL. - Restarting Utilities. 17 Controlling IRLM 18 Controlling Connections - TSO, CICS, and IMS Connections. - Two Phase Commit. 19 Controlling DDF, Stored Procedures and UDFs. 20 System Performance Overview - Buffer Pools, EDM Pools, and Logging. 21 Application Performance Overview - Access Paths. - Explain. 22 Plans, Packages and Bind