Back to Search Results

Training Course Summary:

Ambitions as a DB2 UDB for z/OS and OS/390 Database Administrator? This course offers you an extensive hands-on workshop in physical database design, implementation and maintenance. CF03U and CF12GB or equivalent required, CF18U helpful.

Pre-Requisites:

Describe the SQL data manipulation statements to access and change the contents of DB2 tables by attending DB2 Family Fundamentals (CF03U), DB2 SQL Workshop (SQL1), or have equivalent experience, it would be an advantage to take Relational Database Design (CF18U) or have equivalent experience.
DB2 Family Fundamentals (CF03U)

Who Should Attend:

*Future DB2 UDB for OS/390 database administrators. who want to acquire the basic skills required to administer a DB2 database.

Training Course Overview/Content:

On completion you will be able to:
o Define and maintain the objects that make up a DB2 database
o Resolve referential and check constraint violations
o Load external sequential input data into DB2 tables
o Gather statistics about DB2 data
o Reorganise DB2 data
o Unload DB2 data in external format
o Recover a damaged table space o Compress data
o Bind a DB2 application program
o Control access to DB2 objects
o Describe the basic access paths used by DB2
o Describe DB2 serialisation.