PH04272: NEW CAPTURE START-UP PARAMETER INSERT_UOW TO SPECIFY IF CAPTURE SHOULD INSERT COMMIT INFORMATION INTO THE IBMSNAP_UOW TABLE.

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• 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.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: 1- All Q Apply customers                     *
  *                 2- All SQL Capture customers                 *
  *                 3- All SQL Capture customers                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1- Q Apply gets SQLCODE -803 when it    *
  *                      replicates a DELETE operation from an   *
  *                      archive-enabled table if it also        *
  *                      replicates the associated archive       *
  *                      table and the default for the Db2       *
  *                      SYSIBMADM.MOVE_TO_ARCHIVE built-in      *
  *                      global variable is 'E' or 'Y'.          *
  *                      2- 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.                      *
  *                      3- SQL Capture hangs reading 974 Meg    *
  *                      transaction.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1- Q Apply should be able to set the Db2
  SYSIBMADM.MOVE_TO_ARCHIVE built-in global variable to 'N'.
  2- SQL Capture should not insert commit information into the
  IBMSNAP_UOW table if it is not needed.
  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.
  

Problem conclusion

Temporary fix

Comments

• 1- Q Apply has been changed to accept the DELETE_ARCHIVE
  start-up parameter.  Q Apply will set the
  SYSIBMADM.MOVE_TO_ARCHIVE Db2 global variable to 'N' if the
  DELETE_ARCHIVE parameter is 'Y'.
  2- 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.
  3- The SQL Capture log reader will spill transactions to disk
  when it detects that SQL Capture memory is full.
  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:

  UI60368 UI60369 UI60370 UI60371

Modules/Macros

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

Fix information

• Fixed component name

  WS REPLICATION

• Fixed component ID

  5655L8800

Applicable component levels

• RA21 PSY UI60368

     UP19/01/12 P F901

• RA24 PSY UI60369

     UP19/01/12 P F901

• RA25 PSY UI60370

     UP19/01/12 P F901

• RA26 PSY UI60371

     UP19/01/12 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.