DB2 for z/OS Database Administration
Course
In High Wycombe
Description
-
Type
Course
-
Location
High wycombe
-
Duration
5 Days
On successful completion of this course, attendees will be able to: describe the internal structure of DB2 UDB for z/OS databases, assess logical database design blueprints, design and implement physical databases covering: storage groups, databases, table spaces, tables, indexes, aliases, synonyms, etc., assess security and related requirements, use DB2 commands to monitor. Suitable for: DB2 database administrators.
Facilities
Location
Start date
Start date
About this course
Attendees should be familiar with the DB2 environment and have knowledge of SQL or have attended the DB2 concepts and SQL courses.
Reviews
Course programme
On successful completion of this course, attendees will be able to:
- describe the internal structure of DB2 UDB for z/OS databases
- assess logical database design blueprints
- design and implement physical databases covering: storage groups, databases, table spaces, tables, indexes, aliases, synonyms, etc.
- assess security and related requirements
- use DB2 commands to monitor and control DB2 objects, processes and operations
- use the full complement of DB2 data and recovery utilities.
DB2 database administrators.
Prerequisites
Attendees should be familiar with the DB2 environment and have knowledge of SQL or have attended the DB2 concepts and SQL courses.
Duration
5 days
Course Code
DDA
Contents
The Relational Model
Data structure; Data manipulation; Data integrity.
DB2 Environment
DB2 address spaces; Attachments; lLg data sets; Catalog; Directory; Buffer pools and hiperpools.
DB2 Attachments
Connection control; Authority checking; Controlling attachments; Thread creation and control.
Monitoring and Control
Controlling the DB2 system; Controlling logging, databases, procedures, functions, traces, etc.
Buffer Pool Usage
Buffer pools, hiperpools, data spaces; thresholds; hit ratio; considerations.
Basic SQL Usage
SQL & DB2I overview; Basic data manipulation.
DB2 Security and DCL
The grant and revoke statements; Explicit and implicit privileges; Administrative authorities; Install SYSADM/SYSOPR.
Pageset Properties
Pageset structure; Page structure; Index structure; Row structure.
Table Design
Data concepts; E-R diagrams; Normalisation; Table creation; DB2 data types and attributes; constraint & domain management; temporary tables.
Index Design
Index structure; when to index; composite keys; clustering; creating indexes
Physical Design Considerations
Basic object definition; Performance considerations; statistics; space allocations; free space; buffer pools; work files.
Predicates, Access Paths, & I/O Types
Access paths, stage 1, stage 2, indexable & non-indexable predicates; predicate evaluation; sequential & list preftech; index lookaside.
Utilities Overview
Utility packaging; Online utilities; stand-alone utilities; control statements; LISTDEF; TEMPLATE; OPTIONS.
Online Data Utilities
LOAD; UNLOAD; REORG; RUNSTATS; STOSPACE; CHECK; REPAIR.
Online Recovery Utilities
COPY; COPYTOCOPY; MERGECOPY; REPORT; QUIESCE; RECOVER; REBUILD; MODIFY; BACKUP SYSTEM; RESTORE SYSTEM.
Stand-alone Utilities
DSN1COPY; DSN1PRNT, DSN1LOGP; DSN1COMP; DSN1CHKR; DSNJU003; DSNJU004; DSNJLOGF.
Resource Serialisation &Llocking
Resource serialisation; claims and drain; concurrent utility/applications processing; lock control; locking options; lock compatibility; bind options; lock avoidance.
DB2 Optimiser and EXPLAIN
Input to the optimiser; statistics; EXPLAIN tables; using EXPLAIN; optimisation hints.
Program Preparation
Precompiler; bind options; package options; versions.
Practicals
Data manipulation language; normalisation & table design; table creation; using data utilities; using backup & recovery utilities; using EXPLAIN.
DB2 for z/OS Database Administration