logo


your one source for IT & AV

About Us | Careers | Contact Us | Locations  
Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

DB2 11 for zOS Implementation Workshop

SS Course: 44295

Course Overview

TOP

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.

                                                                  

Scheduled Classes

TOP
01/16/23 - TDV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)
03/06/23 - TDV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)

What You'll Learn

TOP

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

    Outline

    TOP
    Viewing outline for:

    Prerequisites

    TOP

    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.

        Who Should Attend

        TOP

        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.

          Next Step Courses

          TOP