1,2,3
Give and Take 2020
Information on the Give and Take 4,5,6,7
Previous Give & TakeWe have “GIVEn” various free-of-charge Use Cases from our SQL WorkloadExpert for Db2 z/OS like: 1 Index Maintenance Costs2 EXPLAIN Suppression3 BIF Usage |
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.
<a href="http://www.seg.de/produkte/db2-zos-produkte/sql-workloadexpert-for-db2-zos/" target="
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 – This last one is still available | We TAKE the anonymized results for research and will communicate with the local User Groups for discussions |
Inspiring experiences
Customer Statements
| 3 | BiF USAGE | 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-Usage
Presentation | 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