Objectives

On successful completion of this course, attendees will be able to:

• appreciate the latest on-line schema enhancements
• use LISTDEF and TEMPLATE to generate generic utility tasks
• appreciate the enhanced facilities to manage partitions
• identify and use the latest performance and availability enhancements for loading, unloading and reorganising data
• describe how large object data is held, and its recovery implications
• identify the need for and definition of user defined distinct types, user defined functions, triggers and stored procedures
• identify the use and relevance of packages and collections in program preparation.

Who Should Attend

DBAs responsible for the design, implementation and ongoing support of DB2 databases wishing to expand their knowledge and skills.

Prerequisites

An understanding of the DB2 relational database management system and database administration tasks in general. This can be gained by attending the RSM course DB2 Database Administration.

Duration

4 days

Fee

£1675 (ex. VAT)

Course Code

ADBA

Contents

DB2 9 for z/OS enhancements overview

New data types; NOT LOGGED tablespaces; Index enhancements; Cloned tables; Universal tablespaces; etc. This segment introduces many of the enhancements introduced with DB2 9

On-line schema enhancements

Changing data types and lengths; amending indexes to have true VARCHAR columns; separating partitioning and clustering. This segment introduces the enhancements introduced to assist with on-line schema management.

Generic utility tasks

Using LISTDEF to build reusable object lists; using TEMPLATE to generate data set names and attributes and simplify JCL; the use of the OPTIONS statement to control execution parameters. This segment examines the use of LISTDEF, TEMPLATE and OPTIONS statements in setting up and controlling utility jobs.

Utility performance and availability

LOAD enhancements; REBUILD INDEX enhancements; REORG enhancements; UNLOAD enhancements. This segment describes the major enhancements in the utilities mentioned.

Enhanced partition management

Index defined vs table defined partitioning; adding new partitions; rotating partitions; rebalancing partitions. This segment describes the enhancements available to assist with partition management.

UDTs, UDFs and stored procedures

Need and definition of schema; need for, definition of and use of user defined distinct types (UDTs); need for, definition of and use of user defined functions (UDFs); need for, definition of and use of stored procedures; UDT, UDF and stored procedure security. This segment examines the role of UDTs, UDFs and stored procedures, their definition and control.

Large object and XML data types

Large object data; relationship between base and auxiliary tables; large object locking considerations; large object logging and recovery considerations; XML data support; XML data model; XML data storage; Indexing XML data; XML data backup & recovery. This segment covers the use, definition, and recovery of large object and XML data types.

Program preparation

Program preparation steps; relevance of packages and collections; package versioning; accessing different tables at execution time; common problems. This segment examines program preparation and the options available to provide flexibility within applications.

Hands-on exercises

Hands-on exercises complement the course material to assist in full understanding of the subject matter.