PH60681: Q Capture wrong URID for END REDO log record

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Capture currently processes the END
  REDO log record incorrectly and does
  not extract the URID from the log
  record.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All Q Capture upgrade users               *
  *                 2- Q Capture users                           *
  *                 3- All Capture users                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- TRANS_COMMIT_MODE, IFI_FILTER and    *
  *                      IFI_CONVERT_LOG_DATA are missing when   *
  *                      using ASNCATM to upgrade control tables *
  *                      2- Capture currently processes the END  *
  *                      REDO log record incorrectly and does    *
  *                      not extract the URID from the log       *
  *                      record.                                 *
  *                      3- Negative value in the CAPMON table   *
  ****************************************************************
  1- Incorrect ASNCAT_COL_TOL_MISSING tag is set for
  TRANS_COMMIT_MODE, IFI_FILTER and IFI_CONVERT_LOG_DATA columns
  which leads to missing sql statement generated for this column
  2- Capture extracts the URID from the wrong location in the log
  record.
  3- Capture may run into problem when using a mix of 4 byte and
  8 byte variables to calculate max_trans_sizes
  

Problem conclusion

• 1- Remove ASNCAT_COL_TOL_MISSING for TRANS_COMMIT_MODE,
  IFI_FILTER and IFI_CONVERT_LOG_DATA columns
  2- Capture will find the URID from the data part of the log
  record by adding 6 to lgdfl.
  3- Capture has changed all the variables for calculating
  max_trans_sizes to support 8 byte value.
  ASNCLP was not updated.
  Function Level: 1140.103
  

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:

  UI96661 UI96662 UI96663 UI96664

Modules/Macros

• ASN2BASE ASN2DBCN ASN2SQLZ ASNACMD  ASNADMSP ASNAPPLY ASNCAP
  ASNCATM  ASNCCMD  ASNCCPWK ASNCDINS ASNMCMD  ASNMON   ASNPRUNE
  ASNQACMD ASNQAHKT ASNQAPAG ASNQAPP  ASNQAROW ASNQASUB ASNQBRWZ
  ASNQCAP  ASNQCCMD ASNQDEP  ASNQEXRP ASNQLODZ ASNQMFMT ASNQP2PA
  ASNQP2PI ASNQSPIL ASNQSQLZ ASNQXFMT ASNRBASE ASNSQLCZ ASNTDIFF
  ASNTDSP  ASNTRC   ASNUOW
  

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RB33 PSY UI96661

     UP24/04/27 P F404

• RB34 PSY UI96662

     UP24/04/30 P F404

• RB35 PSY UI96663

     UP24/04/27 P F404

• RB36 PSY UI96664

     UP24/04/27 P F404

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.