Db2 for z/OS database administration

Obtain a deep, broad understanding of Db2 for z/OS during the 4-day intensive training at ABIS.

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 a training?

Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

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 on Db2, and other Db2 users occupied with (part of) the tasks of a DBA.

Database administrators of Db2 who want a refresh, specifically regarding new possibilities in versions 12 or 13.

Background

Sufficient practical experience with Db2 (see course Db2 for z/OS fundamentals course).

You can test for yourself to see whether you have sufficient background by filling out the online self-test "Db2".

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 and physical design:
      • normalisation, datatypes, referential integrity (primary/foreign keys);
      • check constraints, triggers, sequence objects and identity columns;
      • XML, LOBs, views, aliases, ...;
      • index and tablespace design;
      • partitioning;
      • "time travel" tables
    • schema evolution: possibilities of ALTER (esp. for tablespaces and tables); 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 on 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)
    • RACF-based access control
    • plans, packages, and bind & rebind options
  • The Catalog and the Directory:
    • contents • usage • management
    • effective use of the real-time statistics (RTS)
    • manipulation of a.o. optimizer statistics

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 index • runstats • statistics profiles • catmaint
  • Related aspects:
    • dynamic allocation of datasets (with or without SMS)
    • (re)partitioning of tables; moving data to other volumes
    • the 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
    • using DSN1PRNT and DSN1COPY
  • 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.

Certificate

At the end of the session, the participant receives a "Certificate of Completion".

Duration

4 days.

Course leader

Peter Vanroose (ABIS).

Reviews

4.3/5 (based on 16 evaluations; the most recent ones are shown below)

Cursusduur (4 dagen) was voor de stof (700 blz syllabus) aan de korte kant. De uitleg van de theorie door de docent was uitstekend, maar de tijd voor de praktische oefeningen was krap.

 
  (, )

Goede cursus, goed overzicht van alle DBA aspecten.

 
  (, )

Ik had al een fundamentele cursus gedaan. Deze is wat dieper, veel zaken nog onbekend omdat ik nog niet op z/os werk. Door fundamentale cursus zijn veel termen toch wel bekend.

 
  (, )

Ik heb hier heel veel van geleerd!

 
  (, )

Goed, maar de docent zou af en toe iets minder mogen uitweiden over zaken.

 
  (, )

Veel geleerd, wel erg intensief.

 
  (, )

Très bonne connaissance de la part de l'instructeur.

 
  (, )

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT