DB2 UDB for z/OS and OS/390 Version 7 Utility Transition
 

This 1 day course:

is an in-depth look at the many new and enhanced features of DB2 UDB for z/OS and OS/390 Version 7 utilities. Attend this course prior to implementing Version 7 utilities to obtain the knowledge required to build and implement optimally performing utilities that best fit your environment. The course covers new and changed functionality of the DB2 utilities.

Topics Covered:

• DB2 Utility with DB2 V7 Overview and New Packaging
• New Utilities
• New UNLOAD utility
• CopyToCopy
• Cross Loader
• Dynamic Utility Jobs
• Improved Utilities
• LOAD
• REORG
• Misc.
• Statistic History

Duration: 1 day

Delivery: Class lecture

Audience: 

All personnel who require update information pertaining to DB2 UDB for z/OS and OS/390 Version 7 utilities. This course assumes the attendee has a good working knowledge of the DB2 Version 6 utilities.

Outline:

1.  DB2 Utility with DB2 V7 Overview and New Packaging

     What's New?
     DB2 V7 Packaging
     Release incompatibilities
     Planning Task List

2.  New Utilities

     UNLOAD utility
          Functionality
           Syntax
           Unloading from tablespaces
           Unloading from copy datasets
           Samples
     CopyToCopy
          Functionality
          Syntax
           Samples
     Cross Loader
           Functionality
            EXEC SQL
            LOAD INCURSOR
           Samples

3.  Dynamic Utility Jobs

     Overview
     OPTIONS
     LISTDEF
     TEMPLATE
     Samples

4.  Improved Utilities

     LOAD
           Performance Enhancements
           SHRLEVEL CHANGE
           Samples
     REORG
           Performance Enhancements
           Samples
     Misc. Utility Improvements
     Statistic History
           History Tables
            HISTORY control statement
           MODIFY STATISTICS
           Samples