PH19886: ABEND04E RC00C90050 IN DSNILGRT+01458 WITH IBM DB2 ANALYTICS ACCELERATOR INTEGRATED SYNCHRONIZATION WHEN RELOADING TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C90050 in DSNIDM.DSNILGRT+01458 with IBM Db2
  Analytics Accelerator Integrated Synchronization (InSynch) when
  reloading a large number of replicated tables.
  
  Also replication failure in replication events with message
  "Detected LSN moving backwards!" when reloading a large number
  of replicated tables may cause replicated tables to go into
  error status.
  
  Additional Keywords:
  OFFSET01458 OFFSET1458
  IDAAV7R1/K
  

Local fix

•  n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users who use IBM Db2                    *
  * Analytics Accelerator with Integrated                        *
  * Synchronization as replication method.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ABEND04E RC00C90050 in DSNILGRT+01458                        *
  * when loading tables or disabling                             *
  * replication for one or more tables.                          *
  * Replication with Integrated                                  *
  * Synchronization fails on accelerator                         *
  * with message "Detected LSN moving                            *
  * backwards!" and table may be set into                        *
  * error state.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  This PTF fixes two problems with log reading tasks:
  1. When Db2z log reading tasks are terminated during load
  processing for IBM Db2 Analytics Accelerator or when disabling
  replication for tables, an ABEND04E RC00C90050 in
  DSNIDM.DSNILGRT+01458 may be issued when processing log records
  that were just read in a very small timing window.
  Replication will continue to work correctly besides this AB04E
  in Db2z.
  2. Replication may fail with message "Detected LSN moving
  backwards!" in replication events or in DSNX881I messages
  especially during or after load processing when an incorrect
  restart position is sent during termination of a log reader
  task.  If the table was set to error, it needs to be enabled
  for replication and loaded again.
  Additional keywords:
  OFFSET01458 OFFSET1458 MSGDSNX881I
  IDAAV7R1/Kally
  

Problem conclusion

• Db2 is fixed to suppress the abend in termination processing
  and to provide correct restart LRSNs to IBM Db2 Analytics
  Accelerator.
  

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:

  UI67234

Modules/Macros

• DSNILGRT
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI67234

     UP20/01/14 P F001

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.