Below is the latest patch information for our insure/INDEX and insure/ANALYSIS customers.

Do not apply these patches unless you are at HomeRun version 6.1. ‹Click here to verify your release›

Symptoms: The indexes that surface in insure/INDEX and in the AutoDBA component may not have the optimal key order and thus may not provide the best performance for a long-running SQL statement. This was caused by a reporting issue with the raw data from DB2. The incorrect information is now accounted for and the correct index keys are now returned in those situations. Instructions for applying the patch for "Index advisor not returning all perfect indexes" (12KB) Download the save file for the "Index advisor not returning all perfect indexes" patch (260KB)

Symptoms: End user right-clicks on one of the Create Index advices in the AutoDBA tool and executes the Create Index action.Now that index is built, the advice is supposed to be moved to the Implemented section and marked as Done. Instead, it remains as an advised index. Joblog of the XCCLIENT job servicing the PC client connection shows MCH3601, CPF503E, SQL0443, CEE9901, CPF502B, SQL0443 error messages. Instructions for applying the patch for "AutoDBA 'Create Index' right-click menu option executes, but index is not moved to the Implemented section" (13KB) Download the save file for the "AutoDBA 'Create Index' right-click menu option executes, but index is not moved to the Implemented section" patch (22KB)

Symptoms: Centerfield exit points programs registered for QIBM_QZDA_INIT (ODBC/JDBC init) and QIBM_QSQ_CLI_CONNECT (CLI init) do not call exit point programs that were registered at those exit points prior to Centerfield exit point registration. This in effect breaks the 'daisy chain' design inherent to all of our exit point programs. This ommission is corrected with this patch. End user may notice that previously registered exit point program is not performing the task it was designed to perform. Instructions for applying the patch for "Centerfield exit point programs for ODBC and CLI initialization don't daisy chain to pre-existing exit point programs" (13KB) Download the save file for the "Centerfield exit point programs for ODBC and CLI initialization don't daisy chain to pre-existing exit point programs" patch (29KB)