DB2 for z/OS Database Administration

Course

In High Wycombe

£ 1,645 + VAT

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

High Wycombe (Buckinghamshire)
See map
24 - 28 Crendon Street, HP13 6LS

Start date

On request

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Objectives
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.
Who Should Attend
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

£ 1,645 + VAT