Skip to Content
0
Former Member
Nov 04, 2011 at 11:07 AM

SQL0911N - Deadlock on table DMC_INDXCL in sender sys during data selection

249 Views

Hi Guys,

We are running time slice scenario and currently there are 2 activities parallely running on sender system

1) Data selection for header tables

2) Data selection.

Multiple processes of these activities got canceled due to some deadlock error. Short dump is getting generated and below is the error.

SQL error "-911" when accessing table "DMC_INDXCL".

Database Error Text: "SQL0911N The current transaction has been rolled back

because of a deadlock or timeout. Reason code "2". SQLSTATE=40001 row=1".

We are running of TDMS 3.0 SP 18 and database is DB2 9.7.

Please help ..

- Bhupendra Patel