Overview
This course is for installers of DB2 9 z/OS and/or migration to DB2 10 for z/OS using the Install CLIST. You are involved in lectures that explain DB2 10 components and pointers, and the processes used to install or migrate from DB2 9 for z/OS. To reinforce the lectures, a series of labs are provided to give you hands-on experience installing DB2 9 for z/OS and migrating to DB2 10 for z/OS.
The hands-on labs include exercises to:
- Install DB2 9 for z/OS subsystem
- Verify with the sample applications
- Perform parameter updates
- Migrate to DB2 10 conversion mode
- Fall back to DB2 9 for z/OS
- Migrate again to DB2 10 conversion mode
- Enable new function mode
- Verify with the sample applications
- Precompile option NEWFUN(V9)
This course replaces course DB2 9 for z/OS Implementation Workshop (CV860). This is the Classroom version of Instructor-led online course DB2 for z/OS Implementation Workshop - Instructor Led Online (3V861).
Public
This intermediate course is for anyone responsible for maintaining, installing or migrating DB2 9 for z/OS to DB2 10 for z/OS, or installing DB2 10 for z/OS.
Prerequisits
Completion of the following courses is suggested:
- Database Administration (CV831) or equivalent Work experience in a z/OS environment
- System Administration (CV851)
The following prerequisites are suggested:
- 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)
- Defining and allocating MVS data sets using z/OS job control language (JCL) or equivalent experience
Objective
- 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 10 for z/OS data to SMF
- Establish subsystem security
- Verify the installation
- Update subsystem parameters
- Create a new ZPARM
- Migrate DB2 9 for z/OS to DB2 10 for z/OS Conversion Mode
- Enable DB2 10 for z/OS New Function Mode
- Verify migration
Topics
Please refer to Course Overview.