Give and Take 2020
Information on the Give and Take Programs 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.
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 inspiring experiences with you now.
Inspiring experiences
We TAKE the anonymized results for research
and will communicate with the local User Groups for discussions
Kundenmeinungen
| 3 | BIF USAGE | Lesen Sie die Kundenmeinungen aus unterschiedlichen Industrie Sektoren [Customer Comments]
|
Erste Ergebnisse von Db2 z/OS Kunden
| 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… |
| [Ergebnisse von Db2 z/OS Kunden (engl)] | ||
Program 3 – BIF Usage
| BIF-Usage
Präsentation | BIF Kompatibilität | Db2 10 Kompatibilität Mode
Änderungen bei der STRING Formatierung von Decimal Data bei der CHAR und VARCHAR built-in Funktion und bei der CAST Spezifikation mit CHAR und VARCHAR Ergebnis Typen sowie UNSUPPORTED TIMESTAMP STRINGs. |
| White Paper | Wo sind die BIFs? Finding BIFs (engl) | Wo sind die BIFs? Und wie können wir in Zukunft problemlos mit BIFs leben? Wege aus der mangelnden Aufwärtskompatibilität bei der Migration von Db2 Versionen |
| Newsletter | 2015-01 – BIFCIDS – Where’s the BIF? (engl.) | How will you deal with loop-hole usage in production code? |
| Video | BIF Usage (engl) | (11min.) Trap and correct the BIFs that will cause belly-ache one day soon |
BIF Usage Video