hi

Want to calc the size of index ,i found lots of queries but not able to get the prefect one even REORG_IX_STATE procedure has ISIZE but not sure its in bytes or MB etc.

nleaf * pagesize , Please provide a query for the same if you have.

regds
Paul

I used to execute this SQL to get size of Index in z/OS. Take a look and see it it helps you.

SELECT CREATOR,NAME,
DEC(SPACEF,11,2) AS "SPACEF IN KB",
DEC(SPACEF,11,2)/2097152 AS "SPACEF IN GB"
FROM SYSIBM.SYSINDEXES
WHERE (CREATOR IN ('XXXXXXX','XXXXXXX') OR TBCREATOR LIKE 'ABC%')
AND DEC(SPACEF,11,2) / 2097152 > 0.1
ORDER BY SPACEF DESC
WITH UR
;

pls suggest

select (sum(cast(i****eaf as bigint) * ts.pagesize/1024)/1024) as indexsiz
eMB from syscat.indexes i , syscat.tablespaces ts where i.tbspaceid = ts.tbspace
id and i.tabname = 'tabname' group by ts.pagesize.

regds
Paul