CV880G - DB2 12 for zOS Advanced Database Administration - 2 Days

Course Description

Students needing to augment their skill set in administering a Db2 12 for z/OS database environment.


Pre-requisites

Before attending this course you should have:

  • Familiarity with the z/OS operating system, including TSO, ISPF, and SDSF.
  • Familiarity with SQL DML (SELECT, INSERT, UPDATE, DELETE, and MERGE) and DDL (CREATE, ALTER, DROP) statements.
  • Basic skills administering a Db2 12 for z/OS database environment, including the use of basic utilities, serialization, and basic database security.


Objectives

This course will introduce the student to advanced database administration skills, including program preparation and the use of packages, online schema changes, partition management, and stored procedures; as well as performance and availability features of utilities (including LOAD, REBUILD INDEX, REORG, and UNLOAD). This course does not cover distributed data processing, nor does it cover data sharing.


Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.


Course Details

Program Preparation and the use of Packages Part 1
Program preparation overview
Execution time errors
BIND actions
Package status and REBIND
Deleting a package
Determining the table/view qualifier

Online Schema Changes Part 1
Changing data type
Adding columns to a table
Renaming columns in a table
Renaming indexes
Adding columns to indexes
Versioning

Online Schema Changes Part 2
Pending online schema changes
Dropping columns from a table
Converting to UTS
Other pending changes
Impact of pending changes on immediate options
Restrictions and considerations

Partition Management Part 1
Adding partitions
Rotating partitions

Partition Management Part 2
Modifying limit keys
Rebalancing partitions

Stored Procedures Part 1
External stored procedures
WLM-established application environments
Altering and dropping a stored procedure
Commands for stored procedures
Execution privileges
Catalog information

LOAD and REBUILD INDEX
LOAD with parallel index build
LOAD partitions in parallel
REBUILD INDEX
Inline image copies and statistics
LOAD SHRLEVEL CHANGE
LOAD REPLACE SHRLEVEL REFERENCE

REORG
Performance features of REORG
Online REORG
Inline image copies and statistics
Consideratons for PBG table spaces
Online REORG with LOBs (optional)

UNLOAD
Overview
Image copy specification
Table-only input specification
SHRLEVEL option
Modes of operation

Program Preparation and the use of Packages Part 2 (Optional)
Table mirroring
Package versioning
Plan management
Other REBIND PACKAGE options
Application compatibility

Stored Procedures Part 2 (Optional)
Native stored procedures
Native procedure deployment


Course Enquiry