DB2 for z/OS database administration (EN/NL/FR)

At the end of this 4 day ABIS course, the participant will:

• have a clear overview of the 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 DB in test/acceptance/production environments;
• have practical skills to define and prepare procedures for the management of the databases.

Intended for (new) database administrators and users occupied with (part of) the tasks of a DBA. Participants should have basic experience with Db2.

Remark: Course description in English; Dutch and French versions are available on the ABIS website. Courses are planned in Dutch, English, and French. Consult the ABIS website for alternate course formats.

Description:

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.

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

Intended for/Audience: 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/Prerequisites: Basic practical experience with Db2.

Training Method/Didactics: Theory with ample room for practical exercises.

Duration: 4 days.