Db2 for z/OS database administration
At the end of this course, the participant will:
- have a clear overview of the very versatile tasks of a DBA in Db2;
- have a thorough technical insight into the physical and logical structure of the different objects in Db2;
- have learned to translate a logical data model into a physical database in test/acceptance/production environments;
- have practical skills to define and prepare procedures for the management of the databases.
Schedule
No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.
Intended for
New database administrators and other users occupied with (part of) the tasks of a DBA.
Database administrators of Db2 who want a refresh, specifically regarding new possibilities in versions 10 , 11, and 12.
Background
Sufficient practical experience with Db2 (see course Db2 for z/OS fundamentals course).
Main topics
- PART 1: Database Implementation
- Overview of the versatile tasks of a DBA.
- Physical design and implementation of Db2 objects:
- Db2 object definition: decision rules
- Possibilities for the implementation of a logical design: referential integrity (primary/foreign keys), check constraints, triggers, sequence objects, identity columns, distinct types, XML, LOBs, views and MQTs; index and tablespace design; partitioning; temporal tables and transparent archiving
- schema evolution: possibilities of ALTER; pending changes
- implementing a test environment: DDL • test data • statistics
- preparing for migration
- prepare the database for performance analysis (but see also course Db2 for z/OS SQL performance)
- Access control to Db2 objects:
- scenarios for efficient security management and auditing requirements
- details regarding the different possibilities: owner-based, role-based, multilevel-based, or object-based; trusted context; "separate security" possibilities (incl. row permissions and column masks)
- plans, packages, and bind & rebind options
- The Catalog and the Directory:
- contents • usage • management
- effective use of the real-time statistics (RTS)
- PART 2: Database maintenance & integrity control
- Data Utilities:
- Using utilities: Db2I & JCL • listdef and templates • exec sql • tablespace sets • terminate and restart
- online reorg • load & unload • check data & check index • rebuild • runstats & stospace • statistics profiles
- Related aspects:
- dynamic allocation of datasets (with or without SMS)
- (re)partitioning of tables; moving data to other volumes
- use of data compression
- possibilities of and potential problems with foreign keys
- PART 3: Database recovery
- Internal physical structure of Db2 data objects:
- tablespaces and indexspaces, partitions; page sets and fan sets; VSAM; BSDS
- Db2 backup and recovery utilities & service aids:
- using utilities & service aids to backup, recover & verify integrity of data
- inspect and copy the contents of Db2 datasets or selective pages
- point-in-time recovery and disaster recovery: best practices
Training method
Theory with ample room for practical exercises.
Duration
4 days.
Course leader
Peter Vanroose.
Reviews
4.5/5 (based on 11 evaluations; the most recent ones are shown below)
|
Goed, maar de docent zou af en toe iets minder mogen uitweiden over zaken.
| (Karin, ) |
Veel geleerd, wel erg intensief.
| (Jan, ) |
Très bonne connaissance de la part de l'instructeur.
| (Pierre, ) |
Prima cursus, losse puzzelstukjes vielen op hun plaats
| (Loek, ) |
zeer goed. Legt voldoende basis om als beginneling binnen de functie direct aan de slag te kunnen gaan.
| (N.N., KBC Groep, ) |
Goeie introductie tot het DBA-werk
| (N.N., KBC Groep, ) |
SESSION INFO AND ENROLMENT |