The course provides detailed coverage of the concepts and operation of IBM's DB2 UDB for z/OS and OS/390 database management system. It is intended for staff performing DB2 application support roles. Students should have a basic knowledge of OS/390. The course includes practical exercises.
4 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. - Selection Criteria. - 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. - Entity and Referential Integrity. - Table Check Constraints. 9 Housekeeping Utilities - Load 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 - Triggers. - Distributed Database. - Stored Procedures. - Data Sharing. 14 Basic Operation - DB2 Definition. - Starting and Stopping DB2. - DB2 Commands. - DB2 Messages. 15 Controlling DB2 Databases - -START DATABASE. - -STOP DATABASE. - -DISPLAY DATABASE. - Object States. 16 Controlling Utilities - Controlling Utilities. - -DISPLAY UTILITY. - -TERM UTILITY. - -ALTER UTILITY. - Restarting Utilities. 17 Controlling IRLM 18 Controlling Connections - TSO, CICS, and IMS Connections. - Two Phase Commit. - Resolving In-Doubt URs. 19 Controlling DDF, Stored Procedures and UDFs. 20 Plans, Packages and Bind