PH06478: CAPTURE GETS SQLCODE -180 WHEN IT INSERTS TIMESTAMP VALUES INTO CAPMON CURRENT_LOG_TIME, LAST_EOL_TIME IF LRSN DELTA IS NON-ZERO

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Capture gets SQLCODE -180 when it inserts timestamp values into
  the CAPMON CURRENT_LOG_TIME and LAST_EOL_TIME columns if the
  Db2 subsystem LRSN Delta is non-zero.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All Capture customers with Db2 tables in  *
  *                 multi-table tablespaces.                     *
  *                 2- All Capture Db2 data sharing customers    *
  *                 3- All SQL Capture customers                 *
  *                 4- All SQL Capture customers                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Capture cannot find the version of   *
  *                      a table in the IBMQREP_TABVERSION       *
  *                      table.                                  *
  *                      2- Capture gets SQLCODE -180 when it    *
  *                      inserts timestamp values into the       *
  *                      CAPMON CURRENT_LOG_TIME and             *
  *                      LAST_EOL_TIME columns if the Db2        *
  *                      subsystem LRSN Delta is non-zero.       *
  *                      3- SQL Capture hangs reading 974 Meg    *
  *                      transaction.                            *
  *                      4- SQL Capture inserts commit           *
  *                      information into the IBMSNAP_UOW table  *
  *                      even if SQL Apply does not need to      *
  *                      join the CD tables with the             *
  *                      IBMSNAP_UOW table.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Capture is decoding a log record and cannot locate the
  version of a table specified in the log record. The table is in
  a multi-table tablespace and a REORG of the tablespace was done
  that increased the version of the table even though the table
  was not altered.
  2- The capture log reader converts the end-of-log LRSN value
  into an invalid timestamp value if the LRSN Delta value is
  non-zero.
  3- The SQL Capture log reader sleeps when it detects that SQL
  Capture memory is full even if its worker has no transactions
  to process.
  4- SQL Capture should not insert commit information into the
  IBMSNAP_UOW table if it is not needed.
  

Problem conclusion

Temporary fix

Comments

• 1- Capture has been changed to use the schema from the
  IBMQREP_TABVERSION table that describes the version of the
  table specified in the log record.
  2- The capture log reader will adjust the end-of-log LRSN value
  using the LRSN Delta value before it converts the end-of-log
  LRSN value into a timestamp value.
  3- The SQL Capture log reader will spill transactions to disk
  when it detects that SQL Capture memory is full.
  4- SQL Capture will not insert commit information into the
  IBMSNAP_UOW table if the INSERT_UOW start-up parameter is 'N'
  and all IBMSNAP_PRUNCNTL TARGET_STRUCTURE column values are 8
  or 9.
  ASNCLP was not updated.
  

APAR Information

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

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

  UI60756 UI60757 UI60758 UI60759

Modules/Macros

•    ASNACMD  ASNADMSP ASNAPPLY ASNCAP   ASNCATM
  ASNCCMD  ASNCCPWK ASNMCMD  ASNMON   ASNQACMD ASNQAPP  ASNQCAP
  ASNQCCMD ASNQDEP  ASNQEXRP ASNQMFMT ASNQXFMT ASNRBASE ASNTDIFF
  ASNTDSP  ASNTRC   ASN2BASE
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UI60756

     UP19/01/26 P F901

• RB34 PSY UI60757

     UP19/01/26 P F901

• RB35 PSY UI60758

     UP19/01/26 P F901

• RB36 PSY UI60759

     UP19/01/26 P F901

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.