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 LUW DBA - Core competences

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 information 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

  • The DB2 for LUW Instance • Memory segments • Bufferpools • Agents • Engine Dispatchable Units
  • DB2 for LUW Physical storage
  • Database scalability • Parallelism • Partitioning
  • db2 - Command Line Processor
  • Instances: set-up • configuration • administration • Fault Monitor Facility
  • Databases: Creating • Physical structure • Database configuration • Configuration Advisor
  • DB2 for LUW System Information
  • The Catalog • LIST command • administration logs (db2diag) • Using db2pd • Memory tracking • SYSIBMADM Views
  • Tablespace Types: SMS Tablespaces • DMS Tablespaces • Automatic storage table spaces • Storage groups
  • Tablespace Design Issues: Page sizes • Extent size • Prefetch size • Bufferpools
  • Logical Objects
  • Tables: Internals • Large objects • Table 'space' management • Range partitioning • Time travel
  • Indexes: Structure • Internals • Types • Design Advisor
  • Looking at objects and object behaviour
  • Export: concepts • Import: concepts • Loading Data: concept • Load Phases • Load indexing mode
  • Analyzing integrity problems
  • Moving databases around: db2move • db2look
  • Reorgchk utility • Reorganizing table and/or index • Runstats Utility • Rebind Utility • QUIESCE Command
  • Automatic maintenance
  • Transactional logging • Types of logging
  • Backing Up the Database: Backup Types • The Recovery History File • Automatic database backup
  • Database Recovery: Crash recovery • Database Restore • Recovery Types: Roll forward - Cloning
  • Authentication configuration and fail-safe
  • Authorization levels: System • Database • Privileges
  • Roles • Trusted contexts and trusted connections • Encryption
  • RCAC (Row and Column Access Control)
 

Intended for

Database administrators who are going to use DB2 for LUW as an RDBMS. The course does not depend on a particular platform, version 10.5 is the version level of reference.

Background

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

Training method

Theory combined with exercises on Windows/Linux.

Course leader

Koen De Backer, Kris Van Thillo.

Duration

4 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
20 Jun4NWoerden  (NL)2000 EUR  (exempt from VAT) 
19 Dec4NWoerden  (NL)2000 EUR  (exempt from VAT) 

Global score

   
4.0/5 (based on 79 evaluations)

Reviews

     
All the sessions were very knowledgeable and give a good insight in to DB2. (, )
     
Uitstekend. Veel geleerd in een paar dagen. Bedankt! (, )
     
Zeer goede cursus, ruim uitgelegd met goede illustraties. Wel een hoog tempo (, )
     
Goed.De docent beschikt ook over veel parate kennis in relatie met oracle. dat was heel positief. (, )
     
goed en zeker aan te raden (, )
     
Nuttig, jammer alleen LUW. Geeft brede context, begrip van DB2 LUW. (, )
     
Goede indruk, genoeg praktijk, vragen kunnen stellen.Prima (, )
     
leerzaam, Goede indruk van DB2 gekregen. (, )
     
très instructif (, )
     
Gaat goed in op de reeds aanwezige kennis, vooral aandacht voor de verschillen LUW en Z/OS (, )

Refresh this page to see other comments.