Sivagurunathan Jagadeesan
New User
Joined: 06 Mar 2007 Posts: 32 Location: India
|
|
|
|
Hi,
I am trying to find out the “Allocated” space for tables in Test Database, by using PQTY, SQTY and Extents, which I get by executing the following query in Test DB,
SELECT B.TBNAME, A.PQTY, A.SQTY, MAX(A.EXTENTS)
FROM SYSIBM.SYSINDEXPART A,
SYSIBM.SYSINDEXES B
WHERE A.IXNAME = B.NAME
AND A.IXCREATOR LIKE 'ABC%'
GROUP BY B.TBNAME, A.PQTY, A.SQTY
Formula used to find the Allocated Space is,
((PQTY*4)/720 + EXTENTS+[(SQTY*4)/720)])
Can anyone let me know if the above formula will give the correct result? If not, is there a alternate way to find the Space using PQTY,SQTY and Extents.
Thanks for the help,
Siva |
|