home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
DB2 for z/OS database administration

Intended for

Future database administrators and other users occupied with (part of) the tasks of a DBA.

Background

Knowledge of DB2 (see course Using DB2 for z/OS) and familiarity with the application development process.

Course leader

Peter Vanroose.

Duration

4 days.

Schedule

datelanguageplacepriceremarks
02/11/2010NWoerden1900 EUR
20/12/2010ELeuven1900 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

At the end of this course, the participant will:

  • know the tasks of the DBA in DB2;
  • have a thorough technical insight into the physical and logical structure of the different objects in DB2;
  • know scenarios for the translation of a logical data model in a physical database in test, acceptation and production environments;
  • be able to define and prepare the procedures for the management of the databases.

Main topics

  • PART 1: Database Implementation
  • The DataBase Administrator
  • Physical design and implementation of DB2 objects:
  • DB2 object definition: decision rules
  • implementing a test environment: DDL • test data • statistics
  • preparing for migration
  • Access control to DB2 objects:
  • scenarios for efficient security management
  • The Catalog and Directory:
  • contents • usage
  • PART 2: Database maintenance & integrity control
  • Using utilities:
  • DB2I & JCL • listdef & templates • terminate & restart
  • Data Utilities:
  • reorganisations • load & unload • check data & index • runstats & stospace
  • PART 3: Database recovery
  • Internal physical structure of DB2 data objects:
  • table- and indexspaces, partitions
  • DB2 backup and recovery utilities & service aids:
  • using utilities & service aids to backup, recover & verify integrity of data
  • using utilities & service aids to print and copy contents of DB2 data spaces.