home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
DB2 for z/OS systems performance and tuning

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

datelanguageplacepriceremarks
27/02/2012EHigh Wycombe825 GBP
28/05/2012EHigh Wycombe825 GBP
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

This course examines and explains the critical factors that affect DB2 for z/OS performance in a non-data sharing environment. Monitoring and tuning tools are an integral part of all tuning topics. 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

  • Planning for performance:
  • DB2 traces:
  • DB2 system parameters:
  • Accounting reports:
  • Statistics reports:
  • Tuning DB2 pools:
  • Tuning DB2 logging:
  • DB2 thread tuning: