Sql code -911 deadlock

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Hi,

I have a written a DB2 program to load record into the DB2 table. Actually its a new db and it is not possible for other process or users to use this DB.

when i ran the job for the first time it got abended after processing few records with the sql code -911.

when i restarted the job , it ran fine.....

Is it possible to identify the reason for that particular deadloack...

Is that DB2 is internally storing such details any where within the system?

Thanks,
Nagendran.R

vasanthkumarhb · Posted: Mon Jun 16, 2008 9:55 am Post subject:

Hi,

It may due to taking long time to process DB2 table which is not permissible.

dick scherrer · Posted: Mon Jun 16, 2008 10:50 am Post subject:

Hello,

Please post the "reason-code" from the -911.

plkanth_526 · New User Joined: 01 Jun 2008 Posts: 7 Location: Bangalore

Hi,

F0r -911 sql codes db2 will log the messages in master logs.Best way to find with which it was in deadlock would be to check master logs.

-911 will be associated with reason code seeing it we can get the overview.

Thanks,
Laxmikanth