About this course

Course code TPZL1_CV851
Duration 5 Days

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 (CV860GB). This is the Classroom version of Instructor-led online course DB2 for z/OS Implementation Workshop - Instructor Led Online (3V861GB).

Prerequisites

Completion of the following courses is suggested:

  • DB2 10 for z/OS Database Administration Workshop Part 1 (CV831GB)or equivalent Work experience in a z/OS environment
  • DB2 10 for z/OS 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

Delegates will learn how 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 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

5 Days

Duration
Training delivered by an IBM Global Training Provider
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.