Overview

This course has been specifically designed to provide a thorough introduction to Db2 for z/OS, and covers all features up to and including V 12.<br>Taught from a Technical Support/Computer Operations perspective, this course introduces, describes and explains the fundamental principles of Db2 for z/OS. The course also explains the relational theory and concepts, and shows how Db2 adheres to them. The concepts of Db2 data storage, the Db2 system and its operation, Structured Query Language, the use of Db2 Interactive (Db2i), and the management of Db2 data using standard utility tasks are also introduced and explained. The course comprises formal classroom tuition along with a series of demonstrations and practical, hands-on exercises that reinforce the students' understanding at every stage.<br><br>This course is also available for one-company, on-site presentations and for live presentation over the Internet, via the Virtual Classroom Environment service.
Read more

Prerequisites

A conceptual-level knowledge of the z/OS environment and the ability to use TSO/ISPF and JCL.
Read more

Delegates will learn how to

  • describe the relational concepts and theory, and the advantages of a RDBMS
  • describe the components of the Db2 system, their function, and how they are controlled
  • identify the objects used to store Db2 data and the relationships between them
  • code the SQL statements needed to create and modify Db2 data objects, and control access to them
  • code SQL statements to read and modify Db2 data and interrogate the Db2 catalog
  • describe and fully utilise all the functions available with Db2 Interactive (Db2i)
  • understand the role of logging in Db2 system and data recovery
  • use online utilities to backup and restore data, and perform other data management tasks
  • describe the use of stand-alone utilities and identify situations where they may be required.
  • describe and use various Db2 commands to control and monitor the Db2 environment and objects
  • describe the actions taken during normal start-up, operation, and shut-down of the Db2 system
  • explain the actions to take during start-up following an abnormal termination
  • describe the steps involved in program preparation and the purpose of the Db2 precompiler and bind processes.
Read more

Outline

DBMS Overview

What is a database?; comparison of hierarchical, network & relational database management systems; a brief history of Db2.

Relational Theory & Concepts

Relational theory; relational model; relational algebra; entity, referential and user-defined integrity.

Db2 System & Operations

Architecture overview; Working Storage Areas; Buffer, Sort, RID & EDM pools; Buffer Pools - 64 bit addressing; EDM pool; Sort pool; RID pool; Db2 Attachments; System data sets & databases.

Introduction to Db2 Interactive (Db2i)

DB2i panels; SPUFI; other functions.

Introduction to SQL

Data Definition Language; Data Manipulation Language; Data Control Language; basic SQL SELECT, INSERT, UPDATE & DELETE statements; COMMIT and ROLLBACK processing; DB2 optimizer.

Physical Database Design & Data Definition Language

Pageset structure; Tablespace types and defaults; Db2 object definition; Understanding and choosing options for performance.

Db2 Monitoring & Control

Db2 commands; Controlling the Db2 subsystem; Controlling the IRLM; Controlling the TSO Attachment; Controlling the CICS Attachment; Controlling the IMS Attachment; Issuing commands using Db2 Interactive; Controlling Distributed Data Facility; Controlling logging; Controlling buffer pools; Controlling data sharing; Controlling utilities; Controlling Resource Limit Facility; Controlling databases; Controlling threads; Controlling procedures; Controlling functions; Db2 traces; Trace classes; Controlling traces.

Db2 Logging

Db2 Logging; Db2 log processing; Unit Of Recovery; Two-phase commit protocol; Active Log parameters; Checkpoint parameters; Checkpoint records; Logging commands - SET LOG; Logging commands - DISPLAY; Logging commands - ARCHIVE.

Managing Data with Db2 Utilities - Overview

Db2 utilities; Data backup & recovery utilities; System backup & recovery utilities; Data integrity & consistency utilities; Other online utilities; Stand-alone utilities; Using online utilities; Utility control statements; DB2I utilities - main menu; Db2i utilities - Data Set Names panel; Db2i utilities - Control Statement Data Set Names panel; Controlling utilities; Using LISTDEF & TEMPLATE; Using pattern matching; LISTDEF syntax; TEMPLATE ; Dataset sizing; Dataset naming variables; TEMPLATE syntax; OPTIONS syntax.

Db2 Shutdown, Startup & Recovery

Db2 command format; Starting Db2; Integrity - normal termination; Integrity - abnormal termination; Log Initialisation; Current Status Rebuild; Forward Log Recovery; Backward Log Recovery; Processing log records; In-doubt resolution; Deferred restart: effect on committed UORs, effect on in-flight UORs; Delaying backout of long running tasks; Effect of delaying backout; Conditional restart: Control Record, log Truncation / limit restart, bypass backout / cold start; Conditional restart implications; Maintaining data integrity with conditional restart; Stopping DB2; BACKUP SYSTEM utility; BACKUP SYSTEM control data; RESTORE SYSTEM utility; Restoring to a point in time.

Program Preparation & Execution

Precompile, bind, program preparation and execution; plans and packages; BIND PLAN; BIND PACKAGE; BIND QUERY.

Read more

Why choose QA

Dates & Locations

Frequently asked questions

See all of our FAQs

How can I create an account on myQA.com?

There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.

If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".

If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.

Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.

How do QA’s virtual classroom courses work?

Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.

We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting (more details in the link below) to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.

Learn more about our Virtual Classrooms.

How do QA’s online courses work?

QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.

All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.

Learn more about QA’s online courses.

When will I receive my joining instructions?

Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.

When will I receive my certificate?

Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.

Contact Us

Please contact us for more information