Detect static and dynamic SQL and match to the relevant collection, packages,…
BIF HealthCheck overview (Built-in Function Checker for DB2 z/OS)
BIF HealthCheck reports the following BIF incompatibilities in DB2 11
- 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 the DB2 10 for z/OS default SQL path instead of the V11 path, which has more implicit Schemas
- 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 an insert statement that inserts into an XML column without the XMLDOCUMENT function, which generates SQLCODE -20345 on a DB2 release prior to V11, but does not generate an error starting in V11
- V10 XPATH evaluation behavior was in effect, which resulted in an error (e.g. a data type conversion error occurred for a predicate that would otherwise be evaluated to false.). Starting in V11, such errors might be suppressed
- Execution of a SQL statement by a client non-Java, or Java application that included an unsupported conversion from a string type to a numeric type, or from a numeric type to a string type while the DB2 z/OS Data Server environment was one of the following (the Data Server issues SQLCODE -301)
• The Data Server was in version 11 New-Function Mode (NFM)
• APPLICATION COMPATIBILITY was set to V10R1
• Implicit casting was disabled because subsystem parameter DDF_COMPATIBILITY was set to SP_PARMS_NJV, or DISABLE_IMPCAST_NJV
BIF incompatibilities in DB2 10
More about BIF
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 |
“Give and Take” Program” page | 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 (Freeware) – This last one is still available We TAKE the anonymized results for research and will communicate with the local User Groups for discussions |
User StatementsBIF Usage: “Give and Take | Customer Comments | Read the Customer Comments across the Industry
|