Home About Courses Schedule Services Webinars Contact Search

Db2 for z/OS Utilities Suite

SEE SCHEDULE

Duration: 3.0 days

Method: Instructor led, Hands-on workshops

Price: $1800.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

  1. Db2 Utility Suite Overview
    • Utility grouping
    • LISTDEF & TEMPLATEs
    • Dataset requirements
    • Related Commands
  2. Loading Databases
    • Build and execute LOAD utility
    • Make informed choices of Keyword options
    • Interpret Utility statuses and messages
    • Working with special purpose table spaces
  3. Check Utility
    • Data Integrity validation using CHECK DATA
    • LOB validation
    • Index validation
  4. 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
  5. 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
  6. 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
  7. REORG Utility
    • Overview and options
    • Build & execute REORG for optimum concurrency
    • On-line REORG Alterable options
    • Incorporate inline COPY & STATS in your REORG
  8. UNLOAD, Service Aids and Sample Applications
    • Unload utility for data movement
    • IBM Stand-Alone Service Aids
    • IBM supplied Sample Applications
    • IBM supplied Stored Procedures