How can find out which RACF-ID is using the tables?

bandi · New User Joined: 21 Jul 2005 Posts: 12

How can find out which RACF-ID is using the tables for the thier particular purpose?

When we got the error like this:

SQL0913N Unsuccessful execution caused by deadlock or timeout. Reason code "00C9008E ".

dbzTHEdinosauer · Posted: Mon Nov 06, 2006 4:34 pm

go to the db2 log. see your dba's. don't forget, you may be causing the problem: too few COMMITs, inefficient sql, logic problem. The other task locked you out at the point of your timeout, but you may have set up the situation so that the other task was locked by you.

Besides, you are more interested in the task that was competing against yours, not the person.