DB2 9 for z/OS Database Administration - Part 2

Execute program preparation stepsAlter table characteristicsAlter indexes to add columns or to change the varying length or characteristics of the indexReact to the "Advisory Reorg" Database ExceptionMake decisions to successfully handle table space versionsDetermine an appropriate option for dealing with the need for adding partitions or rebalancing data partitions Determine the applicability and implement clone tables, user-defined distinct types, user-defined functions, stored procedures, triggers, and large objects. Gerichtet an: This course is for Database Administrators and System Programmers who would like to get insight into database administration tasks. The course lab exercises are performed on a DB2 9 for z/OS environment, but the content is appropriate for either DB2 9 or DB2 10 for z/OS.