IBM Db2 12 for zOS Advanced Database Administration
Skills Gained
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
Who Can Benefit
Students needing to augment their skill set in administering a Db2 12 for z/OS database environment.
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.
Outline
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
Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com
Request a Date