I have a problem with deadlock in DB2 database (z/OS). ETL job consists of 4 DB2 connectors and change capture stage. The table contains about 1,5 million records. Updated, inserted and deleted records are about 150 thousand. The job performs commit after 100 records. The table is not used by other applications. Deadlock occurs randomly, for example, in DB2 connector for updating:
SQLExecute reported: SQLSTATE = 57033: Native Error Code = -913: Msg = [IBM][CLI Driver][DB2] SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "00C90088". SQLSTATE=57033 (CC_DB2DBStatement::processRowStatusArray, file CC_DB2DBStatement.cpp, line 2,636)
Could you please help or give advice? Thanks.
The job and the table space for the table (1 table=1 table space):
![Image](http://s14.postimg.org/64cpcoo9t/image.png)
![Image](http://s11.postimg.org/vy84f5eib/image.png)
![Image](http://s10.postimg.org/eyl23yus9/image.png)
![Image](http://s22.postimg.org/u58ak7sbl/image.png)