Detect static and dynamic SQL and match to the relevant collection, packages,…
BIF/ICI HealthCheck overview (Built-in Function Checker for DB2 z/OS)
BIF/ICI HealthCheck reports the following BIF incompatibilities in DB2 10
- Execution of the DB2 9 for z/OS version of SYSIBM.CHAR(DECIMAL-EXPR)
- Execution of the DB2 9 for z/OS version of SYSIBM.VARCHAR(DECIMAL-EXPR), CAST (DECIMAL AS VARCHAR), OR CAST (DECIMAL AS CHAR)
- Use of an unsupported character string representation of a TIMESTAMP
- Use of a USER-DEFINED FUNCTION (UDF) that has the unqualified name ARRAY_EXISTS
- Use of a USER-DEFINED FUNCTION (UDF) that has the unqualified name CUBE
- Use of a USER-DEFINED FUNCTION (UDF) that has the unqualified name ROLLUP
- Execution of a non-Java client that called a Stored Procedure (SP) that is on the DB2 for z/OS Data Server, while subsystem parameter DDF_COMPATIBILITY was set to SP_PARMS_NJV (the Data Server returned output argument values whose data types matched the data types of the call statement arguments).
- Execution of a SQL statement by a client non-Java application that included an unsupported conversion from a string type to a numeric type, while the DB2 z/OS Data Server environment was one of the following (the Data Server issues SQLCODE -301)
- In version 10 Conversion Mode (CM)
- In version 10 New-Function Mode (NFM) and implicit casting was disabled because subsystem parameter DDF_COMPATIBILITY was set to SP_PARMS_NJV, or DISABLE_IMPCAST_NJ
BIF/ICI incompatibilities in DB2 11
Mehr über BIF
| 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 |
| „Give and Take Program“ Seite | Give and Take Program | 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 BIF HealthCheck – This last one is still available We TAKE the anonymized results for research and will communicate with the local User Groups for discussions |
| BIF Usage „Give and Take Kundenmeinungen | Customer Comments | Lesen Sie die Kundenmeinungen aus unterschiedlichen Industrie Sektoren
|