|
|
DB2 UDB Database Administration
(Version 7)
| Duration: 5 days |
| Participants: Database administrators (DBAs) and other IS personnel involved in administering DB2 databases and evaluating DB2 performance. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Administer DB2 UDB databases. - Create DB2 UDB tables and other objects using SQL DDL statements, and code DCL statements to grant or revoke authorization for the use of those objects. - Implement an effective database recovery strategy to maintain and recover records. - Plan and implement efficient DB2 physical database designs. - Define, create, and alter DB2 UDB tablespaces, tables, and indexes. - Evaluate database design performance options and implement effective alternatives. - Create database designs that reflect the impact of referential integrity and data distribution. |
|
Overview:
- This course teaches you to administer DB2 databases in a mainframe environment with consideration for distributed environments. Topics include denormalization, DB2 data architecture and objects, tuning considerations, application monitoring, EXPLAIN, utilities and service aids, referential integrity, and maintenance strategies. - This course covers the steps to take the logical design through to physical implementation. |
| Prerequisites: Understanding DB2 concepts including the relational model, DB2 system environment, and DB2 security; experience writing SQL with SPUFI or QMF; and knowledge of TSO/ISPF and MVS JCL. We recommend familiarity with logical database design and data modeling concepts, which can be obtained by taking our Data Modeling course. |
| Format: Lecture and discussion with class and hands-on exercises. |
|
Topic Outline:
- Introduction Database administration vs data administration Design review Business planning Logical design Normalization Physical design Denormalization Referential integrity - Data Architecture DB2 data objects Stogroups and VSAM VSAM naming conventions and datasets Tablespace types Tablespace formats Table row formats Index types Index formats - Data Definition Naming conventions Authorization and ownership Object dependencies Data distribution considerations - Data Design Stogroup, database, tablespace, table, view, referential integrity Indexes (unique, clustering, partitioning) Alter objects - DB2 Catalog Catalog tables and columns Systables, systablespace, systablepart Syscolumns, sysindexes, sysindexpart Systableauth, sysuserauth Runstats Stospace Manual update - Referential Integrity RI definition Referential sets Insert rule Update rule Delete rule Restrictions Primary keys Foreign keys DDL Utility considerations - Utilities and Service Aids Overview Execution options Control commands Termination and restart Authorization LOAD Functions Phases Control commands Recommendations REORG COPY utility DASD backups MERGECOPY utility RUNSTATS STOSPACE CHECK DATA CHECK INDEX DSNTEP2 - Database Recovery Recovery scenarios Active and archive logs Recovery control RECOVER utility Functions Phases Point-in-time recovery Error range recovery Control commands Recommendations QUIESCE utility REPORT utility - Performance Considerations Tablespace options Rows and columns Locking Modes SQL optimization Access paths EXPLAIN - Version 5, 6, and 7 Differences |
|
|