z/OS and DB2 Basics for DB2 for z/OS DBA Beginners Course Details:

DB2 11 for z/OS beginning DBAs can develop fundamental skills or recognition through lectures and hands-on exercises of:

  • TSO/E and ISPF
  • Data sets
  • DB2 Objects
  • Structured Query Language
  • DB2 Commands
  • JCL and SDSF
  • DB2 Utilities
  • DB2 Logging
  • DB2 Program Preparation

The course materials cover DB2 11 for z/OS.

    Aug 15 2022

    Date: 08/15/2022 - 08/19/2022 (Monday - Friday) | 9:30 AM - 5:30 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:

    z/OS and DB2 Basics for DB2 for z/OS DBA Beginners

    August 15 - 19, 2022 | 9:30 AM - 5:30 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Nov 28 2022

    Date: 11/28/2022 - 12/02/2022 (Monday - Friday) | 9:30 AM - 5:30 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:

    z/OS and DB2 Basics for DB2 for z/OS DBA Beginners

    November 28 - December 2, 2022 | 9:30 AM - 5:30 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.
  • Describe several services provided in a z/OS environment
  • Explain workloads in the batch environment
  • Explain workloads in the online environment
  • Describe job roles in a z/OS environment
  • Log On to TSO/E
  • Navigate TSO/E and ISPF
  • Use TSO commands
  • Setup and utilize JCL (Job Control Language)
  • Utilize SDSF
  • Describe the different types of data sets in a z/OS environment
  • Allocate data sets and list data set information and content
  • Create and modify data set content
  • Give an overview of the DB2 9 environment
  • Describe and utilize DB2 Objects
  • Describe and utilize several DB2 Utilities
  • Describe the DB2I (DB2 Interactive Facility) environment
  • Use SPUFI (SQL Processing Using File Input) to compose andÿexecute SQL
  • Setup and execute DB2 Commands
  • Understand DB2 Logging
  • Describe DB2 program preparation process
  • Understand DB2 startup and shutdown
  • Understand and utilize DB2 recovery strategies

This beginning DB2 basic course is for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database in a z/OS environment.

Ready to Jumpstart Your IT Career?

CONTACT US NOW!