Arrow Electronics, Inc.

DB2 10 for z/OS System Performance Analysis and Tuning

CÓDIGO: CV951G

DURACIÓN: 32 Hours (4 días)

Precio: €1.850,00

Descripción

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

Objetivos

  • 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

Público

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.

Requisitos Previos

You should complete:

  • 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

Programa

  • 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

Fechas Programadas