Home > DB2 for z/OS > DB2 Subsystem Performance & Tuning

DB2 Subsystem Performance & Tuning

Course Code:	DZOSPT
Duration:	4 days (non-data sharing) 5 days (including data sharing)
Audience:	Database Administrators, System Administrators and Capacity Planners.
Prerequisites:	A working knowledge of DB2 objects and architecture.
Summary:	This course places particular emphasis on the monitoring, performance and tuning of the DB2 for z/OS subsystem. This includes: The DB2 workload assessment Response times and throughput Buffers, EDM, RID and Sort pools Threads Data set placement/management Locking & concurrency IRLM Logging Database Services Address Space (DBM1) optimisation CICS considerations Data sharing considerations (5^th day – optional) Central to tuning the above-listed facilities are the accounting and statistics reports and DB2 commands (e.g., -DISPLAY BUFFER/THREAD).
Objectives:	Upon completion of this presentation, the participant should be able to: Plan performance tuning Determine which tools to use Measure system performance Determine if subsystem will be cost-effective Determine the cause of performance problems Decide when and what to tune Interpret relevant accounting and statistics reports Tune DB2 subsystem facilities
Lab:	Numerous exercises involving accounting reports, statistics reports and command displays.
Detailed Outline

Course Schedule