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

Tijdsduur

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

ABIS
Logo van ABIS
Opleiderscore: starstarstarstarstar_border 8 ABIS heeft een gemiddelde beoordeling van 8 (uit 1 ervaring)

Tip: meer info over het programma, prijs, en inschrijven? Download de brochure!

Startdata en plaatsen

Er zijn nog geen startdata bekend voor dit product.

ABIS biedt haar producten standaard aan in de volgende regio's: Brussel, Utrecht

Beschrijving

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 …

Lees de volledige beschrijving

Veelgestelde vragen

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Nog niet gevonden wat je zocht? Bekijk deze onderwerpen: IBM Db2 z/OS, z/OS, IBM Db2, Database ontwerp / design en Databases.

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.

Blijf op de hoogte van nieuwe ervaringen

Er zijn nog geen ervaringen.

Deel je ervaring

Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.

Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.

Download gratis en vrijblijvend de informatiebrochure

(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)
(optioneel)

Heb je nog vragen?

(optioneel)

Aanmelden voor nieuwsbrief

We slaan je gegevens op om je via e-mail en evt. telefoon verder te helpen.
Meer info vind je in ons privacybeleid.