DB2 for z/OS Systems Administration

Objectives
On successful completion of this course, attendees will be able to:

• describe the address space structure and components of a DB2 subsystem
• understand the DB2 installation process
• identify DB2 functions that best suit the requirements of their site
• implement security for the DB2 system
• understand and implement DB2 system and data recovery and restart procedures
• understand the control and use DB2 trace information to perform system and application tuning
• administer packages and plans
• understand the basic problem determination tools.

Who Should Attend
System Programmers, technical DBAs and other technical support personnel responsible for implementing and/or managing a DB2 for z/OS system.

Duration
4 days

Course Code
DSA
Contents
DB2 system architecture
DB2 address spaces; attachments; buffer and EDM pools; system datasets and databases; logging; distributed and shared data concepts.
This segment examines the major components of the DB2 system.

DB2 system installation
Installation steps; install CLIST; installation jobs; compatibility, enable new function andf new function modes.
This segment identifies and describes the major tasks involved in installing a DB2 subsystem.

Connecting to DB2
DB2 attachments; controlling connections to DB2.
Introduces the various attachment facilities and how they are set up and invoked.

DB2 security
DB2 system security; GRANT and REVOKE statements; security privileges.
Covers the system security requirements and the SQL syntax to maintain DB2 security.

DB2 logging
Log buffers; active logs; archive logs; BSDS; checkpoints.
Describes the DB2 logging strategy and the components involved.

DB2 data recovery
Invoking DB2 utilities; backup and recovery utilities; point-in-time recovery.
Discusses the utilities available to backup and restore DB2 application and system data.

DB2 system recovery
BACUP SYSTEM and RESTORE SYSTEM utilities; starting DB2; start-up phases; deferred restart; conditional restart.
Examines the utilities to backup and recover the entire system and discusses the normal and specialised DB2 start-up processes.

DB2 monitoring & control
DB2 traces; controlling traces; using basic trace information to perform system and application tuning; controlling DB2 and attachments.
Describes the DB2 traces available, and their use in basic system and application tuning, and general control of the DB2 system.

Problem determination
DB2 messages and codes; diagnostic tools; problem identification and resolution.
Covers the DB2 messages and tools available to handle various problem scenarios.

Package and plan administration
DB2 program preparation; packages; plans; collections; BIND process.
Examines the steps involved in preparing a DB2 application for running, concentrating on the BIND process.

Performance & tuning
SLAs; performance aims; performance factors; tuning.
Covers general performance and tuning considerations.