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

DateLocationDurationCostEnrolEnquiry
2022-06-13Virtual2 Days £1200.00 (plus VAT)
Enquire
2022-10-10Virtual2 Days £1200.00 (plus VAT)
Enquire

Course Description


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