DB2 11 for zOS Implementation Workshop

Schedule

Start End Duration Location Details

Course Details

DB2 11 for zOS Implementation Workshop

Course Code: CV862G

Duration: 5 Days

Prerequisites: 
•    The basic concepts and facilities of DB2
•    The basic concepts of Structured Query Language (SQL)
•    z/OS Time Sharing Option (TSO) and the z/OS interactive System Productivity Facility (ISPF)
•    Course CV832 Database Administration Part I or equivalent Work experience in a z/OS environment
•    Course CV852 System Administration or equivalent
•    Work experience in a z/OS environment
•    Defining and allocating z/OS data sets using z/OS job control language (JCL) or equivalent experience.

Course Description:

This course is for installers of DB2 10 z/OS and/or migration to DB2 11 for z/OS using the Install CLIST. The participants are involved in lectures that explain DB2 11 components and pointers, and the processes used to install or migrate from DB2 10 for z/OS. To reinforce the lectures, a series of labs are provided to give each participant hands-on experience installing DB2 10 for z/OS and migrating to DB2 11 for z/OS.
Students access a mainframe environment for the labs.

Course Objectives: 

•    Prepare z/OS TSO environment to run the Install CLIST
•    Provide appropriate parameters for the Install CLIST
•    Execute the Install CLIST
•    Define DB2 10 for z/OS  
•    Define VSAM catalog and alias
•    Define system data sets and databases
•    Initialize system data sets and databases
•    Define DB2 10 for z/OS initialization parameters
•    Define user authorization exits
•    Record DB2 11 for z/OS data to SMF
•    Establish subsystem security
•    Verify the DB2 10 for z/OS installation
•    Update subsystem parameters
•    Create a new subsystem parameter module
•    Migrate DB2 10 for z/OS to DB2 11 for z/OS Conversion Mode
•    Enable DB2 11 for z/OS New Function Mode
•    Verify migration
•    Convert the BSDS and Catalog/Directory to 10-byte RBA and LRSN usage    

Intended Audience:

Anyone responsible for maintaining, installing or migrating DB2 10 for z/OS to DB2 11 for z/OS, or installing DB2 11 for z/OS.

Course Outlines:

•    Installation preparation for DB2 10 for z/OS
•    Installation CLIST
•    Installing the DB2 10 subsystem
•    Verification of DB2 10 with the sample applications
•    Performing parameter update
•    Migrating to DB2 11 conversion mode
•    DB2 10 enabling-new-function and new-function modes
•    Verification of DB2 11 with the sample applications 10-byte RBA and LRSN (new)