PH54786: AN SQLCODE = -423 ERROR DURING REPLICATING LOB/XML COLUMN WITH MESSAGE CHC9707E AND DUMP

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When replicating the LOB or XML column of which the size is
  greater than the configured MAXINSTGLOBSIZE value, the LOB
  locator would be used. But the locator may be freed mistakenly
  when LOBCOMMITINTERVAL timer expires even if the LOB data is
  still being sent. This causes SQL error: SQLCODE = -423, ERROR:
  INVALID VALUE FOR LOCATOR to be reported and message CHC9707E to
   be issued stating Lob DLL service has failed, a dump is
  generated as well and subscription terminates
  

Local fix

• Set LOBCOMMITINTERVAL to 0 or to a larger value
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IIDR CDC for z/OS                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: When replicating LOB or XML column of   *
  *                      which the size is greater than the      *
  *                      configured MAXINSTGLOBSIZE value, the   *
  *                      LOB locator would be used. However, the *
  *                      locator may be freed mistakenly when    *
  *                      LOBCOMMITINTERVAL timer expires even if *
  *                      the LOB data is still being sent. This  *
  *                      causes SQLCODE = -423, ERROR:INVALID    *
  *                      VALUE FOR LOCATOR to be reported and    *
  *                      message CHC9707E to be issued stating   *
  *                      Lob DLL service has failed, a dump is   *
  *                      generated as well and subscription      *
  *                      terminates.                             *
  ****************************************************************
  LOB locator being freed at LOBCOMMITINTERVAL timer expire causes
  SQLCODE = -423 and message CHC9707E to be reported if the LOB or
  XML column is till being sent.
  

Problem conclusion

• The logic has been changed to keep the LOB locator at
  LOBCOMMITINTERVAL timer expire if the current LOB or XML column
  is still being sent.
  

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:

  UI92013

Modules/Macros

• CHCLOBDL
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI92013

     UP23/06/02 P F306

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.