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.


A sound practical understanding of Db2 for LUW.


3 days

Fee (per attendee)


Course Code



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.


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


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.


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


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


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

Day 3


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


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


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 2021