4levels teams with the top technology providers to enhance your operations   |   Domains & Hosting   |  Get Support   | My 4levels
GET IN TOUCH
+27 (0)11 848 6229

IBM

4levels-IT-Default-Header

DB2 11 for zOS System Administration


Course Description


Overview

Administrators of DB2 11 for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 11 for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to:

Audience

This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 10 for z/OS.

Prerequisites

You should have:
  • an understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered. These skills can be developed by taking the DB2 Database Administration Workshop (CF83G) / (CV830) or through equivalent experience.
  • a working knowledge of SQL. The SQL Workshop (CE120G) / (3E12G) provides that.
  • At least one year as a z/OS systems programmer or equivalent experience
  • Or, one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience

Key topics

Please refer to course overview for description information.

Objectives

  • Start and stop the DB2 subsystem
  • Explain the allocation CLIST used at logon for DB2 data sets
  • Use Set SYSPARM command
  • Locate the Command recognition character for the DB2 subsystem
  • Query the system log to gain knowledge about the IPL process and information in the system log when DB2 is initialized or stopped
  • Explore DB2 Address Spaces information
  • Select the DB2 functions that best satisfy your site requirements
  • Explain the use of RACF for DB2 connection security
  • Explain the use of Roles and Trusted Context
  • Implement security procedures for a DB2 environment
  • Describe the components and address space structure of a DB2 subsystem
  • Explain DB2 Program Flow for all environments
  • Invoke and use DB2 TSO Facilities
  • Use the DB2 Catalog to monitor authorizations
  • Increase the size of the Active Log data sets
  • Explain DB2 Logging
  • Use SET LOG SUSPEND and SET LOG RESUME
  • Use DSNJU004 to Print Log Map
  • Interpret the output of the Print Log Map Utility DSNJU004
  • Use DSNJU003 to rename DB2 data sets
  • Plan for recovery of a BSDS failure
  • Monitor and control DB2
  • Explain transaction flow in IMS and CICS
  • Describe the CICS and DB2 environment
  • Make use and inplement the extended 10-byte RBA and LRSN

Course Duration

5 days
  • Brands we have partnered with to add value to your business


    We are committed to helping our clients reach their business goals

    4levels’ preferred access to the latest technologies, premier technical support and advanced training helps provide you with specialist and customized solutions that help you achieve your business goals.

4levels Solutions sign up form


Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur excepteur sint occaecat cupidatat non

4levels Solutionslogin form