DB2 for z/OS: Monitoring & Tuning for Systems Performance

In High Wycombe

£ 795 + VAT

Description

  • Typology

    Course

  • Location

    High wycombe

  • Duration

    2 Days

Description

On successful completion of this course, attendees will be able to: identify the DB2 and MVS factors that affect performance, plan for DB2 subsystem monitoring and tuning, detect poor performance using various techniques, identify tuning opportunities, carry out effective problem detection through the use of an established performance and monitoring policy, Implement and.
Suitable for: All those responsible for DB2 systems performance.

Facilities

Location

Starts

High Wycombe (Buckinghamshire)
See map
24 - 28 Crendon Street, HP13 6LS

Starts

On request

To take into account

A sound understanding of DB2 and z/OS (MVS) concepts is required.

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

Course programme

Objectives
On successful completion of this course, attendees will be able to:
  • identify the DB2 and MVS factors that affect performance
  • plan for DB2 subsystem monitoring and tuning
  • detect poor performance using various techniques
  • identify tuning opportunities
  • carry out effective problem detection through the use of an established performance and monitoring policy
  • Implement and interpret DB2 related trace outputs covering I/O tuning, buffer pool tuning, EDM pool tuning, IRLM tuning, thread tuning.
Who Should Attend
All those responsible for DB2 systems performance.
Prerequisites
A sound understanding of DB2 and z/OS (MVS) concepts is required.
Duration
2 days

Course Code
DPTS
Contents
Performance Overview
What is 'performance'?; Performance objectives; Workload categories; Service Level Agreements; Performance factors; System parameters; EDM pool size; Buffer pool sizes; Bufferpool thresholds; Database design factors; Application design factors; DB2 traces.


DB2 Traces
Activating traces; Trace types; Trace destination; Trace classes; IFCID types; Other trace options; Controlling traces.


Performance Monitoring
Monitoring & tuning overview; DB2 Performance Monitor (DB2PM); DB2 Performance Monitor reports; Accounting reports; Statistics reports; Monitoring response times; Suspensions.


DB2 System Parameters
DB2 system parameters; Modifying system parameters; DB2PM System Parameters report; Online parameter management; Online change parameter behaviour.


Tuning Buffer Pools
Buffer pools; Using hiperpools and data spaces; 64-bit architecture; Buffer pool size ; Buffer pool pages; Buffer page processing; I/O types; Buffer pool thresholds; Buffer page stealing; Buffer pool parameters; ALTER BUFFERPOOL command; DISPLAY BUFFERPOOL command; DISPLAY BUFFERPOOL output; Buffer pool hit ratio; Buffer pool writes; Buffer pool I/O; Buffer pool tuning.


Tuning the EDM Pool
The EDM pool; EDM pool storage; Modifying EDM pool size; Dynamic SQL caching; EDM pool & data spaces; EDM pool parameters; EDM pool storage usage; Monitoring the EDM pool; Tuning the EDM pool.


Tuning the Sort Pool
The sort pool; Sort pool storage; Sort processing; Sort pool size; Sort pool estimation; Sort pool parameters; Monitoring sorts; Sort performance; Sort tuning.


Tuning the RID Pool
Record Identifiers; RID pool storage; RID pool size; RID pool parameters; RID processing; Monitoring RID pool; Tuning the RID pool.


Tuning DB2 Logging
DB2 logging overview; Log writes; Log records; Logging parameters; Controlling the logs; Monitoring the logs; Tuning the log.


Tuning Threads
Threads; Connection types; Controlling connections; Connection parameters; Connection processing; Controlling threads; Monitoring threads; Thread tuning -general; Thread tuning.


Tuning Locking & Concurrency
Locking overview; The Internal Resource Lock Manager (IRLM); Reasons for locking - lost updates; Reasons for locking; Lock control; Locking parameters; Lock compatibility; Bind parameters; Lock avoidance; Monitoring locking; Tuning locking.


Tuning Data-Sharing
DB2 Data-sharing; Coupling Facility structures; Lock table entries; Lock Propagation; Installing data-sharing; Data-sharing parameters; Group Buffer Pool parameters; DISPLAY GROUP command; DISPLAY GROUPBUFFERPOOL command; DISPLAY GROUPBUFFERPOOL output; ALTER GROUPBUFFERPOOL command; Monitoring Group Buffer Pool activity ; Monitoring data-sharing locking; Tuning data-sharing.



DB2 for z/OS: Monitoring & Tuning for Systems Performance

£ 795 + VAT