Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

DB2 11 for z/OS System Administration

IBM Course Code: CV852G

Vendor# CV852G

GK# 1500

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

  • Relate the z/OS IPL process to a DB2 subsystem
  • Explain effects of stopping and starting DB2
  • Explain how DB2 sets and use Integrated Catalog Facility (ICF) catalog names
  • The use of DSN command processor running in batch and foreground
  • Use views to minimize users' ability to see into the DB2 catalog
  • See how the catalog (through grant activity) controls access to data
  • Search the catalog for problem situations
  • Use the catalog and DB2 utilities to determine data recovery requirements
  • Describe Internal Resource Lock Manager (IRLM) in a DB2 environment
  • Implement DB2 and Resource Access Control Facility (RACF) security
  • Describe DB2 program flow for all environments
  • Display normal and problem threads and database status
  • See how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
  • Interpret lock displays
  • Identify and cancel particular threads
  • Describe available DB2 utilities to manage system and user page sets

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.

    From

    $3595 CAD

    5 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.

    From

    $3595 CAD

    5 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • 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

Who Needs To Attend

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

Course Outline

Download Course Outline