DB2 for z/OS Administration

Course: DB2A

Duration: 5 Days

Level: I

Topics Covered In This Course

Data Modelling

Entities and attributes; entity-relationship diagrams; normalization.

Relational Table Design

DB2 data types; null values; generated values; key columns; referential integrity; other constraints; table exit routines; performance considerations; creating tables.

Physical Database Design

Catalog and directory databases; other system databases; DB2 data objects; creating and modifying DB2 objects; deleting DB2 objects.

Physical Data Storage

VSAM dataset requirements; naming convention; page set structure; large object considerations; storage calculation and estimation.

Indexes & Access Paths

Index structure; index keys and pointers; choosing indexes; index creation; access path determination; filter factors; using EXPLAIN; optimization hints.

Data Integrity & Locking

Entity integrity; referential integrity; reasons for locking; lock types; lock compatibility; lock size; lock duration; lock avoidance.

Security and Authorisation

Security overview; security terminology; implicit, explicit and grouped privileges; maintaining security using data control language; ownership considerations.

Introduction to Utilities

Utility packaging; on-line utilities; stand-alone utilities; LISTDEF and TEMPLATE; invoking and controlling utilities.

Data Integrity Utilities

CHECK DATA; CHECK INDEX; CHECK LOB; REPAIR.

Back-up and Recovery Utilities

COPY; COPYTOCOPY; MERGECOPY; QUIESCE; RECOVER; REBUILD; REPORT; MODIFY; BACKUP SYSTEM; RESTORE SYSTEM.

Data Utilities

LOAD; REORG; RUNSTATS; STOSPACE; UNLOAD.

DB2 Stand-alone Utilities

DSN1COPY; DSN1PRNT; DSNJU003; DSNJU004; DSN1LOGP; DSN1CHKR, DSN1COMP; DSN1LOGF; DSNJCNVB.

Program Preparation

Precompile; bind; bind authorizations; collections, packages and plans.

What You Can Expect

The materials in the course reflect DB2 UDB for z/OS Version 8/9. This course provides attendees with a comprehensive introduction to designing and administering DB2 databases. The course covers the complete spectrum from initial data model, through logical and physical database design, data security, and ongoing administration to ensure that the data remains complete, consistent, and in its most efficient state. After completion delegates will know:

- Data modelling techniques.

- The process of normalisation of data.

- Mapping data models to DB2 objects.

- Choosing the correct data types, and physical design characteristics.

- Data integrity issues.

- Page layouts and storage estimations.

- Indexing, locking strategy and other performance implications.

- Use of utilities and service aids in ongoing maintenance.

- Security and auditing considerations.

Who Should Take This Course

This course will be of interest to anyone needing an understanding of the design, implementation, support and maintenance of DB2 databases at versions 8.x or 9.

Recommended Prerequisites

A fundamental understanding of the DB2 relational database management system is assumed, as is an understanding of data processing in general. Familiarity with the z/OS operating systems and TSO/ ISPF would also be of benefit.

« Hide The Details

Related Courses

Code	Course Title	Duration	Level
DB2AU	DB2 Administration for Linux, Unix and Windows	5 Days	I	Details
DB2M	Advanced DB2 Application Programming	3 Days	II	Details
DB2ST	DB2 System Performance Tuning	5 Days	II	Details
DB2M9	DB2 UDB/390 Version 9 Transition	2 Days	II	Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]