Results 1 to 3 of 3

Thread: index size calc

  1. #1
    Join Date
    Oct 2007
    Posts
    246

    Unanswered: index size calc

    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

  2. #2
    Join Date
    Apr 2005
    Location
    USA
    Posts
    130
    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
    ;

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •