Db2 12 for zOS Advanced Database Administration CV880G

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

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

• 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

• 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.

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

• 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