The course provides an introduction to the main concepts and components of IBM's DB2 UDB for z/OS and OS/390 database management system. It is intended for DBAs, analysts, programmers, and systems programmers. Students should have a basic knowledge of OS/390.
2 days
1 Relational Database Concepts - The Relational Model. 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 Physical Database Organisation - Tablespace Layout. - Index Structure. 5 Program & User Interface - The SQL Language. - Dynamic and Static SQL. - Data Definition and Control. - Data Manipulation. - Views. - Cursors. - End User Access. 6 Reading Data - Select. - Selection Criteria. - Functions and Group By. - Arithmetics. - Join, Subquery, and Union. 7 Access Paths - Tablespace Scan. - Matching Index Scan. - Non-Matching Index Scan. - Catalog Statistics. 8 Software Structure - Operational Environment. - Connections and Threads. - RDS, Data Manager and Buffer Manager. - Buffer Pools. 9 Updating & Integrity Control - Adding, Deleting and Updating Rows. - Concurrency and UOW. - Locking. - Commit and Rollback. - Entity and Referential Integrity. - Table Check Constraints. 10 Housekeeping Utilities - Load and Reorg. - Runstats. - Check. 11 Backup & Recovery - Logs, BSDS, and Image Copies. - Rollback and Forward Recovery. - Recovery. - Dynamic Utilities. 12 Performance Monitoring - Access Paths. - Explain. - Performance Measurement. - Resource Accounting. 13 Security - Granting and Revoking Privileges. - Bundled Privileges. 14 Other Things - Triggers. - Distributed Database. - Stored Procedures. - Data Sharing.