DB2 Database: 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.

What you will learn

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

Day 1

Db2 UDB Review

Introduction; The Db2 Family.

Advanced Database Management

Advanced database management; 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 control; 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.