DB2 UDB Version 7 for z/OS & OS/390 Utility Implementation
 

This 2 day course:

is an in-depth look at the DB2 UDB for z/OS and OS/390 utilities. Attend this course if you have limited or no prior knowledge of the DB2 utilities in order to obtain the knowledge required to build and implement optimally performing utilities that best fit your environment.

Topics Covered:

• DB2 Utility Overview and Packaging
• Online Utilities to Populate your Database
• Statistics and REORG
• Backup & Recovery Utilities
• Standalone Utilities
• Sample Applications and Stored Procedures

Duration: 2-day workshop

Delivery: Class lecture

Audience: 

All personnel who require a working knowledge of the DB2 UDB for z/OS and OS/390 utilities. This course assumes the attendee has a good working knowledge of DB2 but has not previously worked with the utilities.

Outline:

1. DB2 Utility Overview and Packaging

     DB2 Utility Packaging
     Types of Utilities
          Online Utilities
           Standalone Utilities
           Sample Programs
     Invoking Online Utilities
          Control statements
           Data sets used
          DSNUPROC
          Monitoring and Controlling Utilities

2. Utilities to populate your Database

     LOAD Utility
     UNLOAD Utility
     CHECK Utility
     COPY
     CopyToCopy
     Cross Loader
           EXEC SQL
          LOAD INCURSOR

3.  Dynamic Utility Jobs

     Overview
     OPTIONS
     LISTDEF
     TEMPLATE
     Samples

4.  Statistics and REORG

     STOSPACE
     RUNSTATS
     REORG TABLESPACE
     REORG INDEX
     Statistic History
           History Tables
          HISTORY control statement
          MODIFY STATISTICS

5 .  Backup & Recovery

     COPY
     MERGECOPY
     QUIESCE
     RECOVER TABLESPACE
          Current Point in Time
          Prior Point in Time
     RECOVER INDEX
     REBUILD INDEX
     MODIFY RECOVERY
     REPORT UTILITY
     REPAIR

6.  Stand-alone Utilities

     Overview
     Invoking stand-alone utilities
     Selected stand-alone utilities

7.  Sample Applications and Stored Procedures

     Overview
     Using the sample applications
     Stored Procedures shipped with DB2