Db2 for z/OS Utilities Suite

COURSES / Db2 for z/OS Utilities Suite

Db2 for z/OS Utilities Suite

Duration: 3.0 days

Method: Instructor led, Hands-on workshops

Price: $1920.00

Course Code: DB3015

Audience

Database Administrators, System Administrators and experienced Application personnel who will be working with the IBM Db2 utilities

Description

Are you a new DBA? Changing from vendor utilities to Db2 utilities? Need an in depth knowledge of how to implement and manage Db2 utilities? Then this course is for you. We'll guide you through the development of utility procedures, utility management and help you build best practices.

Prerequisites

Experience in creating or working with Db2 Database objects

Topics

Db2 Utility Suite Overview
- Utility grouping
- LISTDEF & TEMPLATEs
- Dataset requirements
- Related Commands
Loading Databases
- Build and execute LOAD utility
- Make informed choices of Keyword options
- Interpret Utility statuses and messages
- Working with special purpose table spaces
Check Utility
- Data Integrity validation using CHECK DATA
- LOB validation
- Index validation
Preparing for Recovery
- Identify critical resources required for Recover
- Build an execute the following utilities:
  - COPY
  - MERGECOPY
  - COPYTOCOPY
  - QUIESCE
  - MODIFY
- Establish Backup procedure to match service level agreements
- Establish consistency points to facilitate Recovery
Recovery
- Backup and Recovery Procedures and Choices
- What happens during Recovery
- Implementing Recovery Cycles
- Recover Database Objects to current or prior points in time
- Recovery from various failures
RUNSTATS & STATISTICS
- Build and execute RUNSTATS Utility
- Identify critical statistical criteria
- Choose appropriate statistics to gather
- Profiles and Autonomic Stats
- MODIFY STATISTICS utility
- STOSPACE utility
REORG Utility
- Overview and options
- Build & execute REORG for optimum concurrency
- On-line REORG Alterable options
- Incorporate inline COPY & STATS in your REORG
UNLOAD, Service Aids and Sample Applications
- Unload utility for data movement
- IBM Stand-Alone Service Aids
- IBM supplied Sample Applications
- IBM supplied Stored Procedures