DB2 9 for z/OS Implementation Workshop  (CV860)

Compétences acquises

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 9 for z/OS to MVS
• Describe VSAM Catalog and Alias
• Identify system data sets and databases
• Initialize system data sets and databases
• Know DB2 9 for z/OS initialization parameters
• Recognize user authorization exits
• Record DB2 9 for z/OS data to SMF
• Establish subsystem security
• Verify the install
• Update subsystem parameters
• Create a new ZPARM
• Migrate DB2 V8 to DB2 9 Compatibility Mode
• Enable DB2 9 New Function Mode
• Verify Migration

Qui peut en profiter

Anyone responsible for maintaining, installing and/or migrating DB2 UDB for z/OS V8 to DB9 for z/OS or installing DB2 9 for z/OS.

Préalables

You should have an understanding of:

• the basic concepts and facilities of DB2
• the basic concepts of Structured Query Language (SQL)
• MVS Time Sharing Option (TSO) and the MVS interactive System Productivity Facility (ISPF)
• Course CV83 Database Administration or
• equivalent Work experience in a z/OS environment

You should have knowledge:

• CV85 Database Administration
• how to define and allocate MVS data sets using MVS job control language (JCL) or
• equivalent experience

Abstract

IBM Education Advantage Programs eligibility:

• YES - IBM Education Pack - online account