DB2 11 for zOS Implementation Workshop CV862G

Duration: 
5 days
Codes: 
CV862G,DB2
Versions: 
11

Overview

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.

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.

Skills Gained

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

Prerequisites

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 Outline

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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
London
London5 3750 £3750 2019-09-02
Live Virtual
Live Virtual5 3750 £3750 2019-09-23
London
London5 3750 £3750 2019-10-02
Live Virtual
Live Virtual5 3750 £3750 2019-11-11
Live Virtual
Live Virtual5 3750 £3750 2019-11-25
Somerset
Bath5 3750 £3750 2019-11-25
London
London5 3750 £3750 2019-12-02
Live Virtual
Live Virtual5 3750 £3750 2019-12-30