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 11 for z/OS level.

• Implement a DB2 database design
• Use database utilities to load and reorganize data
• Define and implement a DB2 database recovery strategy
• Control access to database using DB2 authorization facilities

This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.

You should be able to:

• Design a relational table
• Describe the SQL data manipulation statements to access and change the contents of DB2 tables

You should also take DB2 Family Fundamentals (CE031G) and DB2 SQL Workshop (CE121G), or have equivalent experience.

• Setting up a DB2 database
• Referential integrity
• Getting data into and out of DB2
• Keeping your DB2 data in good shape
• Application data recovery basics
• Program preparation and Bind
• Security
• Serialization

The course includes extensive machine exercises.

Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.

GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process:

https://b25acidbw07.con.can.ibm.com/BCS/BCSVTEnrl.nsf/Billing%20Info?OpenPage

Once you enroll in a GTP class, you will receive a confirmation letter that should show:

• The current GTP list price
• The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.