JR62934: DMTS64 NOT RELEASING IX LOCK ON SYSTABLES AFTER MAKING DATABASEMETADATA CALLS

APAR status

• Closed as program error.

Error description

• CDC replication session blocks other business session. This can
  result in blocking normal operation on the Db2 database
  environment.
  
  The situation can be found by using the DB2
  Application Snapshot which shows the lock which comes from the
  CDC dmts64-java process against table SYSTABLES. It can be seen
  that it is already idle for a long time, but still is holding
  the lock.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using CDC for Db2       *
  * 11.4.0.3-5570 or older.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CDC can hold a lock on SYSTABLES, preventing other           *
  * applications from locking it.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5572 or newer.                       *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5572 or newer resolves the issue.
  

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:

Fix information

• Fixed component name

  IS CDC DB2 LUW

• Fixed component ID

  5725E30DL

Applicable component levels