Training offering
DB2 9 for z/OS Database Administration Part 2
Description
This course is a continuation of course CV830 and is designed to teach you how to perform additional database administration tasks. CV840 also covers several of the topics introduced in CV830 in much more depth.
Objectives
• Execute program preparation steps including resolving common problems, defining collections and packages, and versioning of packages
• Alter table characteristics such as data types of columns and identify the impact of making such changes
• Alter indexes to add columns or to change the varying length or clustering characteristics of the index, and identify the impact of making such changes
• React to the Advisory Reorg Database Exception Table state
• Make appropriate decisions to successfully handle table space versions
• Use parallel index build with the LOAD, REORG and REBUILD INDEX utilities
• Load partitions in parallel
• Determine the appropriate LOAD options to use while considering concurrency and performance requirements
• Choose appropriate options with REORG and UNLOAD to achieve optimal performance and availability
• Given the usage of the data, determine an appropriate option for dealing with the need for adding partitions or rebalancing data partitions
• Provide appropriate LISTDEF, TEMPLATE, and OPTIONS utility control statements for use in DB2 utilities
• Determine the applicability and implement user-defined distinct types, user-defined functions, stored procedures, triggers, and large objects
Participants
This course is for DB2 for z/OS database administrators who have the basic skills required to administer a DB2 database and want to extend their skills.
Prerequisite(s)
Students should have attended course DB2 9 for z/OS Database Administration Workshop Part 1 (CV830), or have attained a similar level of experience.
Options
• Program preparation and use of packages
• Online schema changes
• Utility performance and availability features
• Partition management
• Generic utility jobs
• User-defined distinct types, user-defined functions and stored procedures
• Triggers
• Large objects
• Performance-related topics
The course includes extensive machine exercises.
