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

[Former Member]

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

[Former Member]

This could be a temporary issue. Just re-execute the data selection activities and it should be resolved.

[Former Member]

Thanx Pankaj,

Deadlock situation occured again for some 4 activities of Data selection and all 4 got cancelled. First time , jobs were finished after restarting it. Is there any specific reason for dead lock situation ?

We are using DB2 database.

- Bhupendra Patel

[Former Member]

Hi,

I have seen this behaviour at a customer site where the issue was located on DB2 customization!

Can it be that you use STMM for DB2 and have not set some parameters properly?

Note 1329179 DB2 V9.7 Standard Parameter Settings

Recommended Database Configuration with STMM Enabled:

=====================================================

> SELF_TUNING_MEM = ON [STMM=YES]

> DATABASE_MEMORY = AUTOMATIC [STMM=YES]

> LOCKLIST = AUTOMATIC [STMM=YES]

> MAXLOCKS = AUTOMATIC [STMM=YES]

> PCKCACHESZ = AUTOMATIC [STMM=YES]

> SHEAPTHRES_SHR = AUTOMATIC [STMM=YES]

> SORTHEAP = AUTOMATIC [STMM=YES]

Please check these parameters with your DBA before doing anything!

Best Regards

Joerg