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 
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

Inspiring experiences

Customer Statements

Read the Customer Comments across the Industry 

  • Health Care
  • Insurance
  • Banking
  • Car Manufacturing

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

Tagged with: , , , , , , , , , , , , , ,