SHOW-ITEM-LOCKS

Hello
i need the name of the table that keeps item locks. when i do a SHOW-ITEM-LOCKS it takes forever, but i am thinking if i can get the table then i'll do a select query to select a particular record, hopefully that'll be faster.

thanks in advance

pp

There is no table for that. SHOW-ITEM-LOCKS by design needs long time to finish and it cannot be made to run faster. However if you use jRLA instead of Unix locking, it will provide you the details fast (jRLA -dvL).


Chris

Hi,
I would suggest a solution i read somewhere in another forum recently.
A discussion there suggested to use LIST-ITEM-LOCKS which will take lesser time than SHOW-ITEM-LOCKS but lesser information than that.But if the information provided by LIST-ITEM-LOCKS is sufficient enough then you can opt for LIST-ITEM-LOCKS itself.

regards,
dj

Hi,

If u need what r the ports are waiting for a lock u can use following from unix shell
$mw42 | grep BLOCK

or if u want to ceck for a particular port if you know then use jprocdisp from jsh
jsh ~-->jprocdisp -d <portid>

Hope it can be useful


Best Regards,
Sastry