DB2 for LUW: Performance & Tuning in Linux/UNIX/Windows Environments


Theis course is designed to teach how to develop, implement and maintain DB2 applications using advanced functions and features, with a view to optimising their performance. The course combines formal classroom tuition with realistic, practical exercises.

Objectives

On successful completion of this course you will be able to:

  • describe effective techniques for advanced database management
  • develop DB2 applications with optimised performance attributes
  • maintain and tune applications for optimised performance.

Who Should Attend

Systems Administrators, Database Administrators and technical personnel who are involved in designing, planning, implementing and/or maintaining DB2 for LUW databases, within a Linux, UNIX, or Windows environment.

Prerequisites

A sound practical understanding of DB2 for LUW.

Duration

3 days

Fee (per attendee)

P.O.A.

Course Code

DUPT

Contents

Day 1

DB2 UDB Review

Introduction; The DB2 Family.

Advanced Database Management

Advanced database management ( up to DB2 9.7); Tuning The Database; Database Configuration File; Partitioned Database; Advanced Tablespace Management; Advanced Table Management; Table Partitioning Feature.

MQT

Generating DDL; Set Integrity; Deep Compression.

DB2 System Catalog

Attributes, including changes up to version 9.7; Consolidation of DDL with regard to efficiency and Version 9.
Followed by Practical Exercise 1.

Locking Strategy

What resources can be locked; How To Set The Locking; Locking Configuration Parameters; Locking Terms; Duration of a lock; Commit/Rollback; Logging; How to find out what Locks are held; Savepoints.
Followed by Practical Exercise 2.

Day 2

Indexing

Physical data management; Page; Indexes; Type 1/ 2 Indexes; Design Advisor; Utilities; Runstats; Reorg; Autonomic Utilities; Reorgchk; Access Strategy; Single Table Access Paths; Multi table access path.

EXPLAIN

Introduction; Explain Tables; Executing from the CLP; Executing from the Command Centre; DB2EXPLN; Visual Explain.

Clustering

Multidimensional Clustering; Range Clustered Tables; The Organize by Key Sequence Clause; Statistical View.

Triggers

Stored Procedures; Development center; Types of stored procedure; An external procedure; The catalog; SPL; Stored procedure builder; User Defined Functions.

Day 3

Security

Security levels; Security administrator authority level; Label based access contro; Security label component; Security structure examples.

Utilities

BACKUP; RESTORE; LOAD; IMPORT/EXPORT; Introduction to Automatic Computing; Configuration Parameters; Collecting Catalog Statistics; Health Center; Remote Administration; DB2 Administration Server.

Logs

Logs, Snapshot ,Event Monitor, Db2pd And Trace; Types of Logging; Configuring Database; Logging Information; DB2DIAG; Manual Reading of the Log; Snapshot & Event Monitor; DB2PD; TRACE DB2TRC.


© RSM Technology 2017