CV880G Db2 12 for zOS Advanced Database Administration
Duration: 2 Days
Level: Advanced
Audience: Systems Administrator
Next Sessions
| Start (YYYY-MM-DD) | End (YYYY-MM-DD) | Language | Amount | |
|---|---|---|---|---|
| 2024-05-09 | 2024-05-10 | English | 1450 EUR | |
| 2024-05-23 | 2024-05-24 | English | 1450 EUR | |
| 2024-06-06 | 2024-06-07 | English | 1450 EUR | |
| 2024-06-20 | 2024-06-21 | English | 1450 EUR | |
| 2024-07-04 | 2024-07-05 | English | 1450 EUR | |
| 2024-07-18 | 2024-07-19 | English | 1450 EUR | |
| 2024-08-01 | 2024-08-02 | English | 1450 EUR | |
| 2024-08-15 | 2024-08-16 | English | 1450 EUR | |
| 2024-08-29 | 2024-08-30 | English | 1450 EUR | |
| 2024-09-12 | 2024-09-13 | English | 1450 EUR | |
| 2024-09-26 | 2024-09-27 | English | 1450 EUR | |
| 2024-10-10 | 2024-10-11 | English | 1450 EUR | |
| 2024-10-24 | 2024-10-25 | English | 1450 EUR | |
| 2024-11-07 | 2024-11-08 | English | 1450 EUR | |
| 2024-11-21 | 2024-11-22 | English | 1450 EUR | |
| 2024-12-05 | 2024-12-06 | English | 1450 EUR | |
| 2024-12-19 | 2024-12-20 | English | 1450 EUR |
Overview
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.
Prerequisites
- 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
• 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
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
• Considerations 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