home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » 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 » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
DB2 for LUW DBA - Core competences

Intended for

Database administrators who are going to use DB2 for LUW as RDBMS. The course does not depend on a particular platform.

Background

Some basic knowledge of the use of the operating system (see course Using DB2 for LUW), a thorough SQL experience (see course SQL workshop) and some programming experience are required.

Training method

Theory combined with exercises on NT/AIX.

Course leader

Koen De Backer, Kris Van Thillo.

Duration

4 days.

Schedule

datelanguageplacepriceremarks
26/06/2012NWoerden1880 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

This course follows the DB2 for LUW fundamentals course and mainly treats the structure and management of the Database Management system. Goal of the course is to provide the audience with the conceptual and practical iformation to cope with the day-to-day administration of a DB2 for LUW system.

At the end of the course:

  • the participant is able to set-up the correct product configuration for his environment;
  • the participant knows the physical set-up of the DB2 for LUW objects;
  • the participant is able to set-up the correct physical organisation and security of the DB2 for LUW data;
  • the participant has a good understanding of the use and scope of the database tools and db-system commands;
  • the participant is able to set up a troubleshooting approach based on the available error logging infrasctructure;
  • delegates have a good understanding of the DB2 for LUW logging mechanism;
  • delegates know about the recovery strategies in DB2 for LUW.

Main topics

  • Role and function of the DBA - DB2 for LUW Product Environment, DB2 for LUW Toolset
  • DB2 for LUW system structure overview
  • Understanding the installed product:

scenarios • profile registries • file system structure

  • Set-up and configuration of a DB2 for LUW instance
  • Finding information: directories • configuration files • catalog
  • Physical structure in detail: container characteristics • tablespace types • tablespace design issues • about bufferpools
  • Logical structure:
  • tables and tablespace choice • indexes
  • triggers, schema, special column types
  • Integrity: DB2 for LUW integrity implementation
  • Security: authentication • DB2 authorisation (levels and privileges) • client/server context • LDAP
  • DB2 for LUW utilities:
  • IMPORT/EXPORT • LOAD • DB2MOVE • DB2LOOK • SET INTEGRITY
  • REORGCHK and RUNSTATS • REORG • QUIESCE
  • BACKUP • RESTORE
  • Crash image • Roll-forward Recovery scenarios • cloning databases
  • Error logging infrastructure:

troubleshooting (intro to ...)

  • GUI tools:

pointing out the possibilities • infrastructure for "remote administration" (DAS server, client setup, security)