Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: The support homepage carousel is not displaying. We are working toward a resolution.

DSNT376I timeout / deadlock error when tryning to create TS on DB2 ZOS enpoint used by Replicate

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
OritA
Support
Support

DSNT376I timeout / deadlock error when tryning to create TS on DB2 ZOS enpoint used by Replicate

Last Update:

May 21, 2021 8:04:25 AM

Updated By:

OritA

Created date:

May 21, 2021 8:04:25 AM

When running replication task on a DB2/ZOS source endpoint database  Replicate uses IFI api to extract CDC data. When the DB2 ZOS endpoint  database contains compressed tables and IFI is reading changes, there could be locking situations (this is a DB2/IFI behaviour). 

As a result of this behaviour,  when tryning to create TS  on this database, you may encounter DSNT376I timeout / deadlock error.

To solve this problem you should perform the following:   PAUSE CDC for the time of facility of Replicate on the Mainframe (XMPAUSE/XMRESUME) :

  • Pause the replicate CDC using the PAUSE CDC facility of Replicate  (XMPAUSE/XMRESUME) on the MF endpoint side.
  • Perform the CREATE TS (as you need)
  • Resume the CDC.

    Pause CDC from the Mainframe will cause the CDC to stop reading changes temporarily and the Tasks on the Replicate side will be waiting till the CDC REUSME.
Contributors
Version history
Last update:
‎2021-05-21 08:04 AM
Updated by: