MVSFORUMS.com

Tanuj · Beginner Joined: 27 Feb 2004 Posts: 5 Topics: 3

Hello every body,

Could you please help me out, how is it possible to see whether a particular table is under some lock/deadlock in UDB Ver.8 ? I am trying to select records from a table but the query just keep on executing and never gives a result. I think that this particular table is under some lock.

Please advise how to see whether a table in UDB database is under lock and if it is, then how to remove the lock?

Please reply urgently.

Tanuj · Beginner Joined: 27 Feb 2004 Posts: 5 Topics: 3

Hi Ravi, thanks for the advice.

But I wanted to know how to find whether a table in UDB database is under a Lock or not. And how to remove locks from tables and command used to do that?

bauer · Posted: Wed Apr 07, 2004 2:32 pm Post subject:

Using the command

-DIS DB(database) SPACE(tsname) USE

from DSN it is possible to view the usage of an specif tablespace in an specific database.

Manas Biswal · Posted: Fri Apr 09, 2004 8:22 am Post subject:

bauer,

Will -DIS DB("Database Name") SPACENAM("Tablespacename') LOCKS

not be a better option than "USE".

Regards,
Manas

bauer · Posted: Sat Apr 10, 2004 12:10 pm Post subject:

Yes, of course.