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
Contents
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.