PRIVATE GROUP FEE:
$ Based upon a class size of six students.
Scheduling can be adjusted to employee work hours and incorporate client assignments.
SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.
CONTENT AND OBJECTIVES:
Use the monitoring tools to perform a variety of tasks.
Utilize the available tools and perform a scenario analysis.
Processing of Db2 Transaction / Queries
Recognize the issues and concerns associated with the processing of Db2 transactions and queries.
Given a group of queries, analyze and determine the issues relating to performance.
Thread Allocation and Workload Control
WLM: Workload Manager is the priority and resource manager for z/OS and implicitly for Db2.
How WLM manages CPU, I/O, and memory resources as required by the workload.
How WLM is used to manage Db2 workflow and review the Db2 distributed and Db2 stored procedure workload.
Buffer Pools and I/O
Determine the memory and I/O processing usage.
Given the system report of memory usage, identify the issues which relate to processing performance.
Locking and Concurrency
Monitor the locks on applications.
Monitor and determine what locks are used at the beginning, middle, and end of an application.
Other Design Considerations
How the design process addresses the origins and data available for analyzing, tuning, and tracking the performance of the Db2 system and applications.
Recognize the inter-dependencies and relationships between the various data elements.
Appreciate the effect of design decisions on the CPU component of the three major Db2 system address spaces.
Determine an appropriate monitoring strategy.
The instructor will present two strategies; determine the preferred approach.
What are the reasons for it being the preferred strategy.
Perform an investigation of Db2 performance issues; begin by examining the database design.
Given a physical design of a system, identify expected issues and fixes.
Single Table Access Paths
Determine optimal performance for single table processing.
Review SQL statements and determine whether there are underlying performance issues which need to be addressed.
If there are issues to be addressed, determine the appropriate fixes.
EXPLAIN for Analyzing Access Paths
Use the EXPLAIN statement.
Given multiple tables and queries, process queries using the EXPLAIN statement.
How to identify and fix issues.
Multiple Table Access
Acquire expertise in using the EXPLAIN statement with complex SQL.
Given several table and queries, process queries through the EXPLAIN statement.
Learn to identify and fix issues.
Determine the current locks.
List the locks, the locks extent, and who has issued the locks.
Use the Accounting Trace to monitor applications.
Use the Db2 Instrumentation Facility for analyzing elapsed-time components and monitoring SQL and locking.
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.
Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.