Download PDF
of this course

DB2 11 for zOS Implementation Workshop (CV862G)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 5 Days

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.

Who Should Attend

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 Certifications

This course is part of the following Certifications:


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)

  • 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 Objectives

After completing this course, you should be able to:

  •  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 exit

  •  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

Course Content

  •  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)

Course ID: CV862G

Show Schedule for 1 Month  3 Months  All 
Date Country Location Register