home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
DB2 for z/OS database administration

Objectives

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; table partitioning
  • 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-, role-, multilevel-, 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
  • 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
  • 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

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 and 11.

Background

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

Training method

Theory with ample room for practical exercises.

Course leader

Peter Vanroose.

Duration

4 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
19 Jun4ELeuven  (BE)2100 EUR  (excl. VAT) 
10 Oct4NWoerden  (NL)2100 EUR  (exempt from VAT) 
18 Dec4?Leuven  (BE)2100 EUR  (excl. VAT) 

Global score

   
4.0/5 (based on 108 evaluations)

Reviews

     
zeer diepgaand, niet alle onderwerpen zijn uitgebreid behandeld. had zeker 2 dagdelen langer mogen duren (, )
     
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. (, )
     
een hele goede cursus (, )
     
trop technique pour mon activité (, )
     
Wellicht had ik teveel voorkennis, de theorie was wel degelijk onderwezen, maar de praktijk op basis ervan, kan soms moeilijk worden gelinkt. (, )
     
confrom de afspraken en verwachtingen (, )
     
Zeer goed. Misschien iets meer oefeningen (, )
     
Zeer compleet, soms iets teveel informatie.Dit kun je laternatuurlijk zelf filteren (, )
     
Excellent course (, )
     
goede weergave van de verwachting. goede interactie (, )

Refresh this page to see other comments.