home 
 
 
 
ennl
 
Home
A propos
Services
Cours
Ressources
Contacts
MyABIS
C
Tous les coursbalkjeGénéralités » Introduction HW & SW » Soft skills » Cycles completsSystèmes d’exploitation » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad et iPhone iOSBases de données et middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data et analyticsDéveloppement d’applications » Méthodiques et techniques » TOGAF » PRINCE2 » Agile et Scrum » Les langages de programmation » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesGestion de système » ITIL » SecuritybalkjeEn pratiqueInscriptions 
Cette page n'est pas disponible en français.
DB2 for z/OS: monitoring & tuning systems' performance

Objectives

This course examines and explains the critical factors that affect DB2 for z/OS performance from a systems perspective. The effective use of monitoring and tuning tools is an integral part of all tuning topics throughout the course. This course is appropriate for DB2 for z/OS environments up to and including DB2 11 for z/OS.

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

Main topics

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; Accounting trace classes; Audit trace classes; Statistics trace classes; Performance trace classes; Monitor trace classes; Global trace classes; IFCIDs activated; Other trace options; Controlling traces; Auditing tables; Audit policies.

  • Performance Monitoring

Monitoring & tuning overview; DB2 monitoring overview; DB2 Performance Expert (DB2PE); DB2PE report sets & traces; Statistics report example; Accounting trace classes and report details; Suspensions.

  • DB2 System Parameters

DB2 system parameters; Modifying system parameters; Specifying start-up parameters; Online parameter management; Changing parameters using commands; Producing a system parameters report; System parameters report.

  • Tuning Buffer Pools

Buffer pools; 64-bit architecture; Buffer pool size; Buffer pool pages; Buffer page processing; I/O types; Buffer pool thresholds; Fixed thresholds; Variable thresholds; Buffer page stealing; Buffer pool parameters; DISPLAY BUFFERPOOL command; DISPLAY BUFFERPOOL output; Buffer pool hit ratio; Hit ratio determination - DISPLAY BUFFERPOOL command; Hit ratio determination - DB2PE reports; Monitoring buffer pools (write activity); Monitoring buffer pools (I/O); Buffer pool tuning: number and size, thresholds; ALTER BUFFERPOOL command.

  • Tuning the EDM Pool

The EDM pool; Default EDM pool size; Modifying EDM pool size; Dynamic SQL caching; EDM pool parameters; EDM pool storage usage; Monitoring the EDM pool: general, dynamic SQL, I/O activity; Tuning the EDM pool.

  • Tuning the Sort Pool

The sort pool; Sort processing: sort phase, sort tree, merge phase; 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: list prefetch, multiple indexes, hybrid join; Monitoring RID pool; Tuning the RID pool.

  • Monitoring Application Performance

Monitoring overview; DB2 Performance Expert (DB2PE); DB2PE reports and traces; DB2PE accounting report: short, long; Accounting report: time distribution, application times, suspensions & highlights; Accounting report; Dynamic SQL caching; Other processing activity; Locking activity; Parallelism; Buffer pool & group buffer pool activity; DB2PE statistics reports.

  • Tuning Threads

Threads; Connection types; Controlling connections; Connection parameters; Connection processing; TSO connections; CAF connections; CICS connection control; IMS connections; IMS connection control; Monitoring threads (DB2 command); Monitoring threads (DB2PE); Thread tuning: general, TSO, CICS, IMS.

  • Tuning Locking & Concurrency

Locking overview; The Internal Resource Lock Manager (IRLM); Reasons for locking: lost updates, reading uncommitted data, repeatable read: Lock control; Lock options - installation; Locking parameters; Lock options - application development; Locks used by SQL statements; Lock compatibility: row or page locks, tablespace locks; Bind - ACQUIRE and RELEASE parameters; Bind - ISOLATION and CURRENTDATA parameters; Lock avoidance; Lock avoidance example; Monitoring locking: DB2 command, LOCKINFO, EXPLAIN, DB2PE; Tuning locking.

  • Tuning Data-Sharing

DB2 data-sharing; Coupling Facility structures: cache structure, lock structure; Lock table entries; Using the lock structure; Lock propagation; Coupling Facility structures - list structure; 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 (DB2PE); Monitoring data-sharing locking; Tuning data-sharing: Group Buffer Pool size, lock structure size, parallelism.

 

Intended for

All those responsible for DB2 systems performance.

Background

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

Training method

Lecturing.

Course leader

RSM Technology.

Duration

2 days.

Schedule

Il n'y a pas de sessions publiques a ce moment. Nous organisons volontièrement un cours en entreprise ou une session publique supplémentaire (en cas d'un nombre suffisant de participants). Intéressé ? Veuillez contacter ABIS.