DEAD LOCKS

Hi, Is it possible to monitor a table where dead lock is occurring? thanks in advance

Hi Other than onstat -p output, these are some of the sysmaster table that provides the additional information regarding the locks/deadlocks: - *sysprofile*: Contains the total number of deadlocks detected which corresponds to the deadlks column in the *onstat -p* command output - *syssesprof*: Contains the number of deadlocks detected per individual database session - *sysptprof: Contains the number of deadlocks detected per individual table* This article could be of help to you regarding monitoring deadlock situations: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0701herber/index.ht ml Thanks Ravi On 6/20/08, PAULO RAFAEL PADILLA VELAZQUEZ <rafaelpadilla@grupomayan.com> wrote: > > Hi, > > Is it possible to monitor a table where dead lock is occurring? > > thanks in advance > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

You can run onstat -g ppf <partnum> to determine the deadlocks for the specific table. Locate the partum in a # of ways but an easy one is just run oncheck -pt <database>:<table> and look for: Partition partnum 49283138 Partition lockid 49283138 If they both match it is a non-fragged table - run onstat -g ppf 49283138 and look at the dlk column. If the partnums do not match the table is fragged, but you will see all of the frags partnumbers in the oncheck output. If the tabls is fragged there will be an easier solution than this one, but if not, this one works. MM

Thank you for your posts. Nice tips