DB2 11 for z/OS System Administration

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 with hands-on labs to gain experience.

Note: While class exercises are performed within a DB2 11 for z/OS environment, our expert instructors can provide guidance on all versions and their differences. 

    May 24 2021

    Date: 05/24/2021 - 05/28/2021 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    May 24 - 28, 2021 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jun 14 2021

    Date: 06/14/2021 - 06/18/2021 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    June 14 - 18, 2021 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jul 26 2021

    Date: 07/26/2021 - 07/30/2021 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    July 26 - 30, 2021 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Aug 16 2021

    Date: 08/16/2021 - 08/20/2021 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    August 16 - 20, 2021 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Sep 27 2021

    Date: 09/27/2021 - 10/01/2021 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    September 27 - October 1, 2021 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Oct 18 2021

    Date: 10/18/2021 - 10/22/2021 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    October 18 - 22, 2021 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 8 2021

    Date: 11/08/2021 - 11/12/2021 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    November 8 - 12, 2021 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 29 2021

    Date: 11/29/2021 - 12/03/2021 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    November 29 - December 3, 2021 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jan 10 2022

    Date: 01/10/2022 - 01/14/2022 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    January 10 - 14, 2022 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jan 31 2022

    Date: 01/31/2022 - 02/04/2022 (Monday - Friday) | 9:00 AM - 5:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.
    REQUEST MORE INFO:

    DB2 11 for z/OS System Administration

    January 31 - February 4, 2022 | 9:00 AM - 5:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?


*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
  • Relate the z/OS IPL process to a DB2 subsystem
  • Effects of stopping and starting DB2
  • How DB2 sets and use Integrated Catalog Facility (ICF) catalog names
  • 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
  • Internal Resource Lock Manager (IRLM) in a DB2 environment
  • Implement DB2 and Resource Access Control Facility (RACF) security
  • DB2 program flow for all environments
  • Display normal and problem threads and database status
  • How the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision
  • Interpret lock displays
  • Identify and cancel particular threads
  • Available DB2 utilities to manage system and user page sets
  • 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
  • A working knowledge of SQL 
  • 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

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

Ready to Jumpstart Your IT Career?

CONTACT US NOW!