Question regarding DB2

mohitknit84 · New User Joined: 06 Sep 2008 Posts: 6 Location: Mumbai

When I'm running one query in DB2 it is giving the return sql code as -904. I know its a deadlock but I want to know who has taken the access of that particular table in the database.

Thanks Guys!!!
have a nice weekend and thanksgiving!!!

dbzTHEdinosauer · Posted: Fri Nov 28, 2008 9:41 pm

you can determine the 'particular table' by the extended sqlda display (DSNTIAR).

then determine who would access the table, either by process of elimination or give the dba's the date/time of the -904 and ask them to search their logs, they can provide you the user of the task that bounced you.