Events

20 minutes webinar on DB2 z/OS SQL Performance Tuning

February 18th, 2016

at 1 pm EST (New York)

at 19.00 CET (Paris, Berlin, Madrid)

Register

In this webinar we will show you several different ways to look at the data already available on your machine and outline some proactive methods to improve DB2 z/OS SQL Performance.

We are presenting 4 new Use Cases

1 – Bufferpool Usage
2 – PKLIST Chains
3 – Application Workload
4 – SQL Time Travel

https://www.seg.de/en/events/webinars/tuning-your-db2-zos-sql-performance?pk_campaign=2016-02webi-ning

1 – Bufferpool Usage

• Who is using which bufferpool with which workload?
• Are there any “hot spots”?
• Are there any “bad guys” using Catalog/Directly/Work bufferpools?

2 – PKLIST Chains

• Shorten the time needed to match packages.
• Find out where the problems are and quickly solve them.

3 – Application Workload

• Analysis.
• Problem detection and trending.
• Access Path Display
• SQL Timeline

4 – SQL Time Travel

      View how SQL has performed in the past.