PH02523: AFTER ADDING ROWS TO A DB2Z TABLE THE SYNCHRONIZATION BETWEEN DB2Z AND IDAA MAY FAIL WITH MESSAGE AQT10050E

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After adding rows to a Db2z table the synchronization between
  Db2z and IBM DB2 Analytics Accelerator (IDAA) may fail with
  message 'AQT10050E An assertion 'secondsSinceEpoch>=0' failed'.
  .
  The error occurs in the context of the Stored Procedure
  ACCEL_SYNCHRONIZE_SCHEMA.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of stored procedure                    *
  *                 SYSPROC.ACCEL_SYNCHRONIZE_SCHEMA             *
  ****************************************************************
  * PROBLEM DESCRIPTION: Calculations with timestamps fail if    *
  *                      at least one part is invalid. One       *
  *                      symptom is error message 'AQT10050E     *
  *                      An assertion 'secondsSinceEpoch>=0'     *
  *                      failed'.                                *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  After adding rows to a Db2z table the
  synchronization between Db2z and the
  accelerator using stored procedure
  SYSPROC.ACCEL_SYNCHRONIZE_SCHEMA
  may fail with message AQT10050E:
  
  secondsSinceEpoch > 0 failed
  Failed to convert parsed timestamp
  0001-01-01-00.00.00.000000
  to second-since-epoch
  
  The issue occurs with tables that were created
  before Db2 V8 as they contain timestamps like
  0001-01-01-00.00.00.000000
  in sysibm.syscolumns.createdts.
  

Problem conclusion

• The problem has been fixed.
  

Temporary fix

Comments

• ×**** PE20/06/19 PTF IN ERROR. SEE APAR PH26622  FOR DESCRIPTION
  

APAR Information

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

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

Modules/Macros

•    AQTENV
  

Fix information

• Fixed component name

  IDAA FOR ZOS

• Fixed component ID

  5697AQT00

Applicable component levels

• R510 PSY UI67757

     UP20/02/08 P F002

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.