View previous topic :: View next topic
|
Author |
Message |
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 |
|
Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007 Posts: 275 Location: Bang,iflex
|
|
|
|
Hi,
It may due to taking long time to process DB2 table which is not permissible. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Please post the "reason-code" from the -911. |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
|