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||(3 min) Who is been using my pool?
||(2 min) Are your Packages bound correctly?
|3||(8 min) New functionnality added
|4||(3 min) Follow your SQLs through time
How to use a DB2 Performance warehouse for real world Use Cases.
3 Questions & Answers – Q & A
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|
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
SQL Time Travel