PI88521: ENHANCE HALOAD DETECT_DATA_CHANGES TO UPDATE THE REFRESH_TIME OFTABLES THAT ARE NOT REFRESHED.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The ACCEL_LOAD_TABLES stored procedure updates the REFRESH_TIME
  (in SYSACCEL.SYSACCELERATEDTABLES) of all tables specified on
  the stored procedure call.  This is true even when a table is
  not loaded because of the detectChanges="DATA" option.
  .
  The purpose of this enhancement is to make HALOAD
  DETECT_DATA_CHANGES behave the same way.  Currently HALOAD only
  updates the REFRESH_TIME of the tables that are actually loaded.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Analytics Accelerator       *
  *                 Loader for z/OS.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The ACCEL_LOAD_TABLES stored procedure  *
  *                      updates the REFRESH_TIME                *
  *                      (in SYSACCEL.SYSACCELERATEDTABLES) of   *
  *                      all tables specified on the stored      *
  *                      procedure call.  This is true even      *
  *                      when a table is not loaded because of   *
  *                      the detectChanges="DATA" option.        *
  *                      The purpose of this enhancement is to   *
  *                      make HALOAD DETECT_DATA_CHANGES behave  *
  *                      the same way.  Currently HALOAD only    *
  *                      updates the REFRESH_TIME of the tables  *
  *                      that are actually loaded.               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI52504

Modules/Macros

•    HLOPUTLX HLORUSQA HLOSINIT HLOSUSQA HLOUCE15
  

Fix information

• Fixed component name

  IDAA LOADER ZOS

• Fixed component ID

  5639OLA00

Applicable component levels

• R210 PSY UI52504

     UP17/12/14 P F712

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.