|
View previous topic :: View next topic
|
| Author |
Message |
Suja K
New User
Joined: 03 Mar 2008
Posts: 16
Location: Hyderabad
|
|
|
|
| Can we use a query to check whether a table is locked? Or is there any way to check thru system catalog tables or any other system tables? |
|
| Back to top |
|
 |
the_gautam
Active User
Joined: 05 Jun 2005
Posts: 165
Location: Bangalore
|
|
|
|
I came across a DB2 run command to view the current locks on a table. however, i have never used it.
DIS DB(ARLACRSP) SPACENAM(SCRSCASE) USE LOCKS |
|
| Back to top |
|
|
am_ne
New User
Joined: 24 Mar 2007
Posts: 25
Location: Bangalore
|
|
|
|
You can issue display locks commands in tablespace or index level.
the command should be -DIS DATABASE(dbname) SPACE(spacenm) LOCKS LIMIT(100) |
|
| Back to top |
|
|
|
|
