Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course Overview 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. Audience Future DB2 UDB for OS/390 database administrators. who want to acquire the basic skills required to administer a DB2 database. Skills Gained - On completion you will 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
- Reorganise DB2 data
- Unload DB2 data in external format
- Recover a damaged table space o Compress data
- Bind a DB2 application program
- Control access to DB2 objects
- Describe the basic access paths used by DB2
- Describe DB2 serialisation.
Prerequisites - 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)
How to make a booking for the CF831AGB course
|
