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
date | dur. | lang. | location | price | |
16 Dec | 4 | Woerden | 2100 EUR (exempt from VAT) | ![]() | |
20 Apr | 4 | Leuven | 2200 EUR (excl. VAT) | ||
15 Jun | 4 | Woerden | 2200 EUR (exempt from VAT) | ||
SESSION INFO AND ENROLMENT |
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.2/5 (based on 26 evaluations; the most recent ones are shown below)
|
Goeie introductie tot het DBA-werk
| (N.N., KBC Groep, ) |
zeer goed. Legt voldoende basis om als beginneling binnen de functie direct aan de slag te kunnen gaan.
| (N.N., KBC Groep, ) |
tres bon, parcours des outils necessaire pour mon day to day job
| (Jean-Christophe, ) |
Goede cursus, op een enthousiaste manier aangeboden door docent.
| (Erik Koetzier, ICU IT Services, ) |
Interessante en leerzame cursus
| (Jurendy, ) |
Zeer prettige presentatie van de lesstof. Fijn om zelf veel uit te proberen op het systeem.
| (Robert, ) |
Geweldig. Vooral tijdens de eerste twee bijeenkomsten vielen veel puzzelstukken op hun plek
| (Bryan, ) |
De cursus heldert voor een ontwikkelaar DBA-aspecten op. Dat kan resulteren in een beter ontwerp.
| (N.N., Ordina SI&D, ) |
Click here to see more comments...
Heel veel stof in korte tijd, wel heel nuttig als extra kennis.
| (N.N., ) |
zeer diepgaand, niet alle onderwerpen zijn uitgebreid behandeld. had zeker 2 dagdelen langer mogen duren
| (Leen Westmaas, Ordina T&C, ) |
goede weergave van de verwachting. goede interactie
| (N.N., ) |
Uitstekende cursus als beginpunt als DBA.
| (N.N., ) |
Deze cursus was heel goed qua inhoud, ik denkt vier dagen waren kort. Misschien 5 dag was goed genoeg.
| (Armin Faezi Marian, Belastingdienst - B/CICT, ) |
Le cours m'a permis d'avoir une idée plus précise des mécanismes utilisés dans DB2 et ainsi, je l'espère, mieux maîtriser les effets de chaques opérations appliquées sur le sous système DB2.
| (Vincent, ) |
een hele goede cursus
| (Hans van Duist, Atos Origin - Flight Forum, ) |
Good, but to specific for my day to day job.
| (N.N., ) |
trop technique pour mon activité
| (N.N., ) |
SESSION INFO AND ENROLMENT |