GIVE and TAKE Program
Index Maintenance Costs, EXPLAIN Suppression, BIF
Limited free-of-Charge Db2 Application
This Program started in Europe, during our 30th anniversary was such a success, that it is now being Extended for the benefit of North American Db2 z/OS sites.
SQL WorkloadExpert™ for Db2 z/OS (WLX) contains several “Use Cases”. We provided three of them, free of charge, for one month to different sites. In return, we received their results. We’d like to share this with you now.
|We have “GIVEn” various free-of-charge Use Cases from SQL Workload Expert for Db2 z/OS like
1 Index Maintenance Costs
2 EXPLAIN Suppression
3 BIF Usage
4 BIX HealthCheck – This last one is still available
|We TAKE the anonymized results for research
and will communicate with the local User Groups for discussions
||Read the Customer Comments across the Industry
First results from Db2 z/OS sites
|1||Index Mantenance Costs||Nearly all the data we got back showed a positive result for created Indexes…|
|2||EXPLAIN Suppression||About 10% of SQLs are actually “left over”…|
|3||BIF Usage||When migrating to a new Db2 version, the BIFs are not always compatible and an extreme amount of data is produced.
The difficulty of near-time analysis to track down BIFs within dynamic SQL have been solved with the BIF Usage Use Case…
|[Results from Db2 z/OS sites]|
Program 3 – BIF Usage – has now started
|BIF Compatibility||Db2 10 compatibility mode
Changes to the STRING formating of decimal data within the CHAR and VARCHAR built-in function and to the CAST specification with CHAR and VARCHAR result types as well as UNSUPPORTED TIMESTAMP STRINGs.
|White Paper||Finding BIFs||And How to Lead a Problem-Free Life With Them in the Future
Navigating the Challenges of moving to a new Db2 Release
|Newsletter||2015-01 – BIFCIDS – Where’s the BIF?||How will you deal with loop-hole usage in production code?|
|Video||BIF Usage||(11min.) Trap and correct the BIFs that will cause belly-ache one day soon|
BIF Usage video