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

This course has been developed for those of you who are new to both z/OS and DB2. DB2 for z/OS is a so called z/OS subsystem. Due to this fact, it is important for you to gain at least basic knowledge not only about DB2, but also about the hosting operating system. With this course you'll gain both as a starting point.

View this course in other countries

Training Paths that reference this course are:

• DB2 for z/OS
• Database Administration Introduction

Back to top

IBM Education Advantage Program Eligibility:

• Yes - IBM Education Pack - online account

Back to top

This is a basic course for system programmers, operators, and other technical personnel who are to learn about z/OS and DB2 on z/OS.

Back to top

You should have a basic knowledge of Windows based operating systems.

Back to top

After completing this course you should be able to complete the firsts tasks as DB2 for z/OS system programmers, Database Administrators (DBAs) or operators. In detail learn how to:

• Explore z/OS as hosting operating system for DB2 for z/OS
• Navigate under Time Sharing Option (TSO) using Interactive System Productivity Facility (ISPF)
• Create, delete, copy, change data sets
• Acquire basic Virtual Storage Access Method (VSAM) Knowledge
• Outline Job Control Language (JCL) basics
• Define usage of System Display and Search Facility (SDSF)
• Explore basic concepts of DB2 for z/OS
• Acquire basic knowledge of language SQL
• Define what the DB2 Catalog is, what it is used for and how you can access it using SQL statements
• High level introduction of DB2 utilities such as LOAD, COPY, QUIESCE, REORG, RECOVER TS, REPORT
• Handle job and utility failures
• Interpret DB2 messages and codes.
• Use DB2 commands
• Interpret the output of DB2 commands
• List basics about the DB2 address spaces and Internal Resource Lock Manager (IRLM).
• Explain what DB2 threads are and how to deal with it
• Explore Best practices stopping and (re)starting DB2 subsystems

Back to top

• Introduction
• Time Sharing Option/Extensions (TSO/E) and ISPF
• Data Sets (Part 1)
• Introduction and Concepts
• Structured Query Language (SQL)
• DB2 Objects
• Data Sets (Part 2)
• DB2 Overview
• DB2 Commands
• JCL and SDSF
• Utilities
• DB2 Logging
• Shutting down and restarting the DB2
• DB2 program preparation

Back to top

• Edit your profile

Easy ways to get the answers you need.

• Online text chat

or call us at
Call 1-800-426-8322

Open M-F 9AM-7PM ET.

• My enrollments

• My training plan

• How to get to class

• Subscribe to IBM Training RSS feeds

• Training paths will help you decide

• Subscribe to IBM Training News

• IBM Training Flyer (98KB)

• Certification flyer (355KB)

• Training special offers

• IBM Education Pack

  Save on training

• Get Adobe® Reader®