• Objetivos del Cursos:

  - Understand DB2 processes as they relate to DB2 performance - Interpret DB2 trace output in DB2 Performance Monitor (PM) forma - Analyze concurrency and serialization issues - Tune a DB2 subsystem - Provide quality input to help system programmers make DB2 work well

• Cursos dirigido a:

  This is an advanced course for Information Technology (IT) individuals, who tune DB2 systems in the z/OS environments.

• Titulación del Cursos:

  Certicicación Técnica Profesional de IBM de DB2 for Z/OS System Performance and Tuning

• Contenido del Cursos:

  KEY TOPICS
  
  Course introduction
    - Identify which topics are going to be discussed, and which will not
    - Explain why some z/OS concepts and controls have important influences on DB2 performance
    - Describe how DB2 works so that you can begin to monitor and tune DB2
  
  DB2 instrumentation facility
    - Set up and handle DB2 traces for both continuous monitoring and for problem analysis
    - Relate when to start with statistics or with accounting reports, depending on the situation
    - Decide how to monitor and tune in your environment
    - Discuss basic principles of reading and understanding monitor reports
  
  DB2 workload
    - Describe how various types of processing are reflected on the reports
    - Find basic workload information on Statistics and Accounting reports
    - Break down a program\'s elapsed time into the individual components
    - Control the maximum number of jobs that can concurrently exist  within DB2
  
  Lab exercise part I
    - Examine standard reports to determine the workload for the lab environment
  
  Operating system and hardware considerations
    - Discuss operating system and hardware topics with other systems people
    - Describe the features and limits of certain hardware
    - Relate DB2-originated reports with system-originated reports
  
  The DB2 system
    - Monitor current usage (behavior) of important parts of DB2
    - Differentiate between good and bad behavior
    - Turn the tuning knobs on the DB2 system level
    - Assist application developers to exploit (if needed) certain features on the DB2 system level
    - Explain to application developers some things they should not do
  
  Lab exercise part II
    - Tune the DB2 subsystem, including the Internal Resource Lock Manager (IRLM), using statistics short and long reports and the system parameters report
    - Using these reports, determine the bottlenecks within the DB2 system
  
  Locking and concurrency
    - Monitor the working of DB2\'s concurrency mechanism
    - Report unusual events to application developers
    - Provide detailed reporting to enable application developers to solve certain problems
    - Adjust DB2 system control knobs
  
  The DB2 attachments
    - Obtain accounting information from the different environments (Time Sharing Option (TSO), CICS, and Information Management System (IMS))
    - Recognize accounting anomalies that may occur
    - Take measures to increase/decrease the maximum amount of work that can flow into DB2
    - Take measures to prevent query users from overloading your system
    - Apply performance options in the CICS and IMS interfaces to DB2
  
  DB2 utilities
    - Identify potential benefits and dangers of allowing utilities and applications to run together (the modern world)
    - Tune (or advise on tuning) general issues in DB2 utilities
    - Provide utility execution details by means of DB2 trace data
  
  Lab exercise part III
    - Using the accounting detail report, determine the performance problems causing two CICS transactions to exhibit an extremely high CLASS 1 elapsed time
  
  Managing DB2 performance
     - Plan to apply the skills attained from this course, after returning to work, to meet the challenge of: monitoring and tuning DB2
     - Plan to apply the skills attained from this course, after returning to work, to meet the challenge of discussing DB2 performance topics with system individuals
     - Plan to apply the skills attained from this course, after returning to work, to meet the challenge of discussing DB2 performance topics with application individuals
  
  *Precio no incluye IVA

Cursos y master en Mexico - Cursos y master en Chile - Cursos e mestrados no Brasil - Cursos y master en Argentina

Formations et masters en France - Corsi e master in Italia - Cursos y master en Colombia

Cursos y maestrías en Peru - Cursos y maestrías en Ecuador