This course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.
Note: This course material is at the DB2 9 for z/OS level.
- This is an intermediate course for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.
After completing this course, you should be able to:
- Define and maintain the objects that make up a DB2 database
- Resolve referential and check constraint violations
- Load external sequential input data into DB2 tables
- Gather statistics about DB2 data
- Reorganize DB2 data
- Unload DB2 data in external format
- Recover a damaged table space to current
- Compress data
- Bind a DB2 application program
- Control access to DB2 objects
- Describe basic DB2 serialization concepts