DB2 10 for z/OS System Performance Analysis and Tuning Eğitimi

Ön Kayıt ve Fiyat Bilgi Formu




Tarih ve lokasyonlar


Bu eğitimi özel sınıf olarak kendi kurumunuzda talep edebilirsiniz.
Lütfen bizimle iletişime geçin:


info@bilginc.com

+90 212 282 7700

Talep Formu

DB2 10 for z/OS System Performance Analysis and Tuning (CV951G)

IBM Course Code: CV951

This course explains how to monitor and tune DB2 10 for z/OS from a system point of view.

What You'll Learn

  • Describe DB2 processes as they relate to DB2 performance
  • Interpret DB2 Trace Output
  • Understand the steps needed to analyze and tune a DB2 subsystem
  • Provide good input to system programmers to allow them to effectively tune the z/OS system for best DB2 performance

These objectives are met by discussing how to:

  • Monitor and control the DB2 workload
  • Monitor and tune IMS/CICS/DDF performance
  • Monitor and tune DB2 buffer pools, EDM pool,logging and IRLM execution
  • Tune DB2 attachments, including the DB2 side of distributed requests
  • Analyze bottlenecks
  • Communicate with systems people about DB2-related issues
  • Communicate with application developers on DB2 performance topics
  • Interpret DB2 statistics and accounting traces
  • Establish guidelines which enhance DB2 system performance
  • Understand how DB2 works well enough to be able to react effectively to various situations

Who Needs to Attend

This advanced course explains how to monitor and tune DB2 10 for z/OS from a system point of view. This course is suitable for DB2 system tuners, Enterprise capacity planners and System programmers.

Prerequisites

  • DB2 10 for z/OS Database Administration Workshop Part 1 (CV831) / DB2 10 for z/OS Database Administration Workshop Part 1 (ILO) (3V831), or have equivalent experience
  • DB2 10 for z/OS Database Administration Workshop Part 2 (CV842) / DB2 10 for z/OS Database Administration Workshop Part 2 (ILO) (3V842), or have equivalent experience
  • DB2 10 for z/OS System Administration (CV851) / DB2 10 for z/OS System Administration - ILO (3V851), or equivalent experience
  • DB2 10 for z/OS Utilities for Database Administrators (CV871) / DB2 10 for z/OS Utilities for Database Administrators (ILO) (3V871), or have equivalent experience

Follow-On Courses

There are no follow-ons for this course.

Course Outline

  • DB2 system performance analysis and tuning introduction
  • The DB2 trace
  • Introduction to the operating system and hardware
  • Service time, queuing time, Case A transaction analysis
  • Introduction and analysis of case E
  • The DB2 attachments
  • In-depth application of the DB2 system
  • The disk subsystem and DB2 I/O
  • Capacity analysis and massive Batch



Eğitim içeriğini PDF olarak indir

Diğer IBM, Database Management & Development Eğitimleri