Db2 12 for z/OS Introduction to System Administration

Learn the skills and knowledge needed to administer a Db2 12 for z/OS system.

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

    Apr 26 2021

    Date: 04/26/2021 - 04/28/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    May 17 2021

    Date: 05/17/2021 - 05/19/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jun 7 2021

    Date: 06/07/2021 - 06/09/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jun 28 2021

    Date: 06/28/2021 - 06/30/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Jul 19 2021

    Date: 07/19/2021 - 07/21/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Aug 9 2021

    Date: 08/09/2021 - 08/11/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Aug 30 2021

    Date: 08/30/2021 - 09/01/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Sep 20 2021

    Date: 09/20/2021 - 09/22/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Oct 11 2021

    Date: 10/11/2021 - 10/13/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 1 2021

    Date: 11/01/2021 - 11/03/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 22 2021

    Date: 11/22/2021 - 11/24/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

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


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Dec 13 2021

    Date: 12/13/2021 - 12/15/2021 (Monday - Wednesday) | 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 12 for z/OS Introduction to System Administration

    December 13 - 15, 2021 | 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.

After completing this course, students should be able to:

  • Start and stop a Db2 subsystem
  • Use the SET SYSPARM command
  • Access the system log to gather information about the subsystem initialization, operation, or shutdown
  • Describe the components and address space structure of a Db2 subsystem
  • Explain the use of RACF (or another external security program) for Db2 connection security
  • Explain the use of Roles and Trusted Contexts
  • Implement security procedures for a Db2 subsystem
  • Explain Db2 program flow for all environments
  • Explain parameter setting for the IRLM
  • Invoke and utilize Db2 TSO facilities
  • Use the Db2 Catalog to monitor subsystem authorizations
  • Work with the Active Log data sets
  • Explain Db2 logging
  • Use SET LOG SUSPEND and SET LOG RESUME
  • Use DSNJU004 to print log map and interpret the results
  • Use DSNJU003 to rename Db2 data sets
  • Plan for recovery of a BSDS failure
  • Monitor and control a Db2 subsystem
  • Explain transaction flow in IMS and CICS environments (optional)
  • Describe the CICS and DB2 environment (optional)

Explain the difference between JDBC and SQLJ

Participants should have the following knowledge and skills.

  • Understanding of the objects (such as databases, table spaces, tables, indexes, and so forth) used in a Db2 subsystem
  • Basic knowledge of SQL
  • At least one year as a z/OS systems programmer or equivalent knowledge

OR

  • At least one year as a Db2 for z/OS Database Administrator

System Administrators, #GOATs and Database Administrators

Ready to Jumpstart Your IT Career?

CONTACT US NOW!