Alle Seminare

Kurs-ID: IBMe_CV042G

Kurs Db2 12 for zOS: Basics for DBA Beginners (CV042G)

Db2 12 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 PreparationThe course materials cover Db2 12 for z/OS

Anfrage stellen


  • 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.



Das Training findet auf Deutsch statt.

Noch Fragen?

Unsere FAQ klären auf.

Lassen Sie sich von uns beraten!

Jetzt anrufen