PH49696: DRL0337W ERROR MESSAGE IN DB2_IDAA_STAT_A_H DUE TO INCORRECT AVERAGING OF SEGMENTS WITH A 00:00:0000 DATE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IDAA table DB2_IDAA_STAT_A_H is not calculating the correct AVG
  for several fields due to certain segments having a 00:00:0000
  date. Due to this happening, the following error messages occur
  
  DRL0337W For 6 records or rows in an update of table
  DRL.DB2_IDAA_STAT_A_H one or more values were set to null
  because of error.
  
  1Record 10123 in the log, of type SMF_100_1,
  
  
  
  
  results in null in data column(s)
  
  
  
  
  Value for target column SERVER_START_TIME was set to null due
  to error
  
  
  
  Value for target column STATUS_CHANGE_TIME was set to null due
  to error
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All customers using:                         *
  *                 IBM Decision Support for Z Version 1.9.0     *
  *                 and IBM Z Performance and Capacity           *
  *                 Analytics Version 3.1.0                      *
  *                 collecting to table DB2_IDAA_STAT_A_H.       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Collect fails with message:             *
  *                      DSNT408I SQLCODE = -803, ERROR:         *
  *                      AN INSERTED OR UPDATED VALUE IS INVALID *
  *                      BECAUSE INDEX IN INDEX SPACE AVAILTRI   *
  *                      CONSTRAINS COLUMNS OF THE TABLE SO      *
  *                      NO TWO ROWS CAN CONTAIN DUPLICATE       *
  *                      VALUES IN THOSE COLUMNS.                *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The collector is attempting to process empty (zero)
  SMF100-1 IDAA_DATA segments, generating duplicate keys each
  time an empty segment is processed.
  

Problem conclusion

• A WHERE clause is added to the  DB2_IDAA_STAT_A_H update
  definition to eliminate the empty segments.
  

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:

  UI82820 UI82821

Modules/Macros

• DRLTD2AA
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R9A0 PSY UI82821

     UP22/10/15 P F210

• RCA0 PSY UI82820

     UP22/10/15 P F210

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.