PM48433: DAYS SINCE ALTERED EXCEPTION IS DIFFERENT FOR HISTORY TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Job builds whose source for exception processing is the IBM
  history tables are diffeent than those whose source for
  exception  processing is the DB2 catalog or the Automation
  Tool repository.
  
  When the source for runstats statistics is history tables and
  only the exception criteria is coded:
  O *DAYS_SINCE_ALTERED EQ -1
  
  then during job build the following error message occurs:
  
  HAAB016E No Runstats Statistics were found for any Objects
  
  When the source for runstats statistics is the DB2 catalog or
  the Automation Tool repository, this error message does not
  occur.
  
  When the source for runstats statistics is history tables and
  two exception criteria are coded:
  
  O *DAYS_SINCE_ALTERED EQ -1
  O SYSTABLES CARDF GT 0
  then no error occurs during job build.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Automation Tool.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Job builds whose source for exception   *
  *                      processing is the IBM history tables    *
  *                      are diffeent than those whose source    *
  *                      for exception  processing is the DB2    *
  *                      catalog or the Automation Tool          *
  *                      repository. When the source for         *
  *                      runstats statistics is history tables   *
  *                      and only the exception criteria is      *
  *                      coded:                                  *
  *                      O *DAYS_SINCE_ALTERED EQ -1             *
  *                      then during job build the following     *
  *                      error message occurs:                   *
  *                      HAAB016E No Runstats Statistics were    *
  *                      found for any Objects                   *
  *                      When the source for runstats statistics *
  *                      is the DB2 catalog or the Automation    *
  *                      Tool repository, this error message     *
  *                      does not occur. When the source for     *
  *                      runstats statistics is history tables   *
  *                      and two exception criteria are coded:   *
  *                      O *DAYS_SINCE_ALTERED EQ -1             *
  *                      O SYSTABLES CARDF GT 0                  *
  *                      then no error occurs during job build.  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• HAA53
  

Fix information

• Fixed component name

  DB2 AUTOMATION

• Fixed component ID

  5697G6300

Applicable component levels

• R310 PSY UK73166

     UP11/10/29 P F110

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.