DB2 UDB Database Administration
|Duration: 5 days|
|Participants: Database administrators (DBAs) and other IS personnel involved in administering DB2 databases and evaluating DB2 performance.|
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.
- 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.|
Database administration vs data administration
- Data Architecture
DB2 data objects
Stogroups and VSAM
VSAM naming conventions and datasets
Table row formats
- Data Definition
Authorization and ownership
Data distribution considerations
- Data Design
Stogroup, database, tablespace, table, view, referential integrity
Indexes (unique, clustering, partitioning)
- DB2 Catalog
Catalog tables and columns
Systables, systablespace, systablepart
Syscolumns, sysindexes, sysindexpart
- Referential Integrity
- Utilities and Service Aids
Termination and restart
- Database Recovery
Active and archive logs
Error range recovery
- Performance Considerations
Rows and columns
- Version 5, 6, and 7 Differences