Contenido
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
