Curso de DB2 for Z/OS System Performance and Tuning CF881MX
Modalidad de imparticiónLa modalidad de impartición es presencial.
Número de horasConsultar.
Titulación oficialCerticicación Técnica Profesional de IBM de DB2 for Z/OS System Performance and Tuning.
Valoración del programaLos objetivos del programa son: Entender los procesos de DB2 que se relacionan con el rendimiento de DB2, interpretar la salida de rastreo de DB2 en DB2 Monitor de rendimiento (PM) forma, analizar la concurrencia y cuestiones de serialización, sintonizar un subsistema DB2, proporcionar información de calidad para ayudar a los programadores de sistemas que trabajan así DB2, entre otros.
Precio del cursoPreguntar.
Dirigido aEste es un curso avanzado de Tecnologías de la Información (TI) personas, que sintonizan los sistemas DB2 en entornos z / OS.
EmpleabilidadAl terminarás podrás laborar en el campo de la tecnología.
Curso de DB2 for Z/OS System Performance and Tuning CF881MX
Objetivos del curso- 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
PrácticasThis a Hands-On Capacitation
Curso dirigido aThis is an advanced course for Information Technology (IT) individuals, who tune DB2 systems in the z/OS environments.
TitulaciónCerticicación Técnica Profesional de IBM de DB2 for Z/OS System Performance and Tuning
ContenidoKEY 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