PM57708: IBM CHANGE DATA CAPTURE, CHC9219E DB2 IFI00C20305, PM54469 CONFIGURE THE PERIODIC COMMITS ON OR OFF.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• CHC9219E DB2 IFI has returned non-zero status in a Log Record at
  LRSN
  X'C8C72F8ACE000001',
  QW0306RC = X'00000008', QW0306RS = X'00C90063', QW0306DG =
  X'00C90000',
  for table tablename
  followed by DB2 abend:
  The DC22MSTR jesmsglg has been FTP'd.
  A SVC generated has been FTP'd.
  Partial Title: DC22,ABND=04E-00C20305,U=DHADM00 ,M=(N),C=910
  The error is caused by DDL not being serialized internally with
  SQL.
  
  We will provide the ability for the customer to configure
  the frequency of the commits from as frequently as once per
  second to as seldom as never.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of CDC for z/OS.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: After applying PTF UK75009 (for CDC     *
  *                      version 6.2) or UK75010 (for CDC        *
  *                      version 6.5), CPU consumption by the    *
  *                      CDC address space may increase          *
  *                      markedly.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The additional DB2 COMMITs added in PTF UK75009 and UK75010 seem
  to use an inordinate amount of CPU in some environments.
  

Problem conclusion

• Only the Log Cache thread now performs the DB2 COMMITs
  unconditionally.  Subscription threads that read the DB2 log
  only perform the DB2 COMMITs if they have actively read the DB2
  log since the last COMMIT was performed.  In addition, the
  LOGREADCOMMITINTERVAL keyword was added to CHCDBMxx to give the
  customer control over the interval at which the DB2 COMMITs are
  performed by the log reader threads.
  

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:

  UK76532 UK76533

Modules/Macros

• CHCDLRGP CHCDLRIQ CHCDLRPF CHCDSCPF CHCDSLGP
  CHCDSLIQ CHCDSLPF
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• R620 PSY UK76532

     UP12/03/03 P F203 Ø

• R650 PSY UK76533

     UP12/03/03 P F203 Ø

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.