Recording vom 18. Februar 2016
Dauer: 20 Minuten in 4 Teilen
Webinar präsentiert von SOFTWARE ENGINEERING (engl)
DB2 z/OS SQL Performance Tuning
The classic answer to any DB2 question is, “it depends!” This is especially the case with SQL.
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.
1 |
Bufferpool Usage |
(3 min) Who is been using my pool?
|
2 |
PKLIST Chains |
(2 min) Are your Packages bound correctly?
|
3 |
Application Workload |
(8 min) New functionnality added
|
4 |
SQL Time Travel |
(3 min) Follow your SQLs through time
|
How to use a DB2 Performance warehouse for real world Use Cases.
3 Questions & Answers – Q & A
1 | Bufferpool usage
Is it exact, down to the getpage per object? |
Not really as we are WLX workload based so it is per/sql no per/object but as an overview and starting point it is pretty good |
2 | PKLIST Chains
What type of performance boost can I expect? |
It Depends. According to the Bank of China performance presentation quite a lot! |
3 | SQL Time Travel
Can I export the data and send to colleagues or use cognos to access the data? |
Yes indeed and as the SQL is externalized you should be able to plug it into cognos etc. |
Introduction More about SQL Workload Analysis
Bufferpool Usage
PKLIST Chains
Application Workload
SQL Time Travel