|
View previous topic :: View next topic
|
| Author |
Message |
Elixir
Active User
Joined: 08 Feb 2009
Posts: 116
Location: CHENNAI/NEW JERSEY - INDIA/USA
|
|
|
|
Hi All,
How to obtaing the Lock size defined for a DB2 table? |
|
| Back to top |
|
 |
saiprasadh
Active User
Joined: 20 Sep 2006
Posts: 154
Location: US
|
|
|
|
Below query will provide LOCK Size defined for a table.
| Code: |
SELECT B.NAME,A.LOCKRULE
FROM SYSIBM.SYSTABLESPACE A,SYSIBM.SYSTABLES B
WHERE B.NAME = <TABLE_NAME>
AND B.TYPE = 'T'
AND A.NAME = B.TSNAME
WITH UR; |
| Quote: |
Lock size of the table space:
A Any
L Large object (LOB)
P Page
R Row
S Table space
T Table
X implicitly created XML table space
|
|
|
| Back to top |
|
|
Elixir
Active User
Joined: 08 Feb 2009
Posts: 116
Location: CHENNAI/NEW JERSEY - INDIA/USA
|
|
|
|
Sai,
Thanks!
Please let me know how to get numeric Value of Lock Size associated to the Lockrule. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| why not look Yourself at the manual for the names, description and format of the columns in the system tables ??? |
|
| Back to top |
|
|
|
|
