Duration

4 days

Course Description

Administrators of DB2 UDB for z/OS can acquire a view of the architecture and fundamental processes required to manage a DB2 UDB for z/OS subsystem. Engage in lectures and hands-on labs to gain experience to: understand how DB2 sets and use Integrated Catalog Facility (ICF) catalog names, the use of DSN command processor running in batch and foreground, use views to minimize users' ability to see into the DB2 catalog, see how the catalog (through grant activity) controls access to data, search the catalog for problem situations, use the catalog and DB2 utilities to determine data recovery requirements, describe Internal Resource Lock Manager (IRLM) in a DB2 UDB environment, implement DB2 and Resource Access Control Facility (RACF) security, understand DB2 program flow for all environments, display normal and problem threads and database status, understand effects of starting and stopping DB2, see how the SQL Processor Using File Input (SPUFI) AUTOCOMMIT option defers the COMMIT/ROLLBACK decision, interpret lock displays, identify and cancel particular threads, describe available DB2 utilities to manage system and user page sets.

Audience

This is an intermediate course for system administrators, database administrators, and other technical individuals, who manage and implement DB2 UDB for z/OS Version 8.

Pre-requisites

Before taking this course, you should have an understanding of the objects (tables, indexes, databases, and so forth) used in DB2 systems, and of how those objects are created, managed, and recovered. These skills can be developed by taking the DB2 Database Administration Workshop (CF83) or through equivalent experience.

You should also have a working knowledge of SQL. The DB2 SQL Workshop (CF12) provides that.

In addition, you should have:

at least one year as a z/OS systems programmer or equivalent experience
or one year working with DB2 on the mainframe as a DBA on the mainframe or equivalent experience

Course Objective

Select the DB2 functions that best satisfy your site requirements
Implement security procedures for a DB2 environment
Describe the components and address space structure of a DB2 subsystem

Key topics

Basic Architecture and Fundamental Mechanisms

Explain the principles of the: START DB2 process, DSNZPARM member, DB2 address space structure, DB2 log, Catalog and directory, Data sharing feature, Connection process, Command routing process, Program preparation and execution processes, and Transaction and points of consistency

IRLM

Set up and tune the IRLM
Recognize the important IRLM parameters

System Security

Protect DB2 data sets when DB2 is up or down
Protect connections to DB2
Describe the high-level operation of DB2 security exits
Describe multilevel security

DB2 Program Flow for All Environments

Describe DB2 program execution
Explain what a DB2 thread is
Explain commit processing

TSO and Batch Environments

Describe the facilities of DB2I
Invoke the DSN command processor in various ways
Invoke DB2 utilities
Describe the QMF environment

DB2 Authorization

Provide appropriate authorization for your user community
Monitor authorization in the DB2 catalog
Effectively assign administrative authorities like SYSADM, DBADM, and BINDAGENT
Create objects for others

DB2 Audit Facility

Explain the purpose of audit trace
Set up audit trace usage on your system
Minimize the overhead of running audit trace on your system

Logging

Explain the basic algorithms of the DB2 logging facility
Set up and operate your log efficiently
Recover from BSDS failures
Recover from certain lost log data set situations
Explain the use of the log maintenance tools

DB2 UDB for z/OS Utilities

Categorize and discuss DB2 Utilities
Explain how to backup and recovery DB2 objects using BACKUP SYSTEM and RESTORE SYSTEM utilities

Application Recovery

Describe the different types of application recovery
Perform various health checks to detect damaged data
Read the log using DSN1LOGP
Avoid certain lost log scenarios

Transaction Flow in IMS and CICS

Describe the two-phase commit process
Explain thread recycling and the complete connection process for a DB2 thread
Describe the input to and output from a SIGNON exit

CICS - DB2 Environment

Set up and administer a CICS/DB2 environment
Define efficient CICS to DB2 connections
Use the DSNC transaction
Encourage CICS thread recycling

Operations (Monitoring and Controlling DB2)

Operate DB2
Train operators at your local site
Avoid certain problem situations

System Recovery/Restart

Describe the DB2 restart process following both normal and abnormal terminations
Prevent restart failures
Recover from restart failures
Begin planning for offsite recovery

IMS - DB2 Environment

Integrate IMS transactions into the DB2 environment
Integrate IMS BATCH jobs into the DB2 environment
Control which plans, subsystems, and connection IDs transactions and batch jobs use

WebSphere - DB2 Environment

Explain the differences between JDBC and SQLJ
Categorize the different JDBC driver types
Explain the basics of Universal Driver for SQLJ and JDBC
Describe WebSphere application connectivity to DB2 for z/OS and OS/390

Programme scope, delivery arrangements and suitability are confirmed during enquiry.