Results 1 to 2 of 2

Thread: index space

  1. #1
    Join Date
    Apr 2004

    Unanswered: index space

    How can I tell how much space an index is using in a specfic tablespace ?

  2. #2
    Join Date
    May 2003
    If you run runstats on the table with "and indexes all" option, you can then query the view syscat.indexes to see various statistics. The NLEAF will tell you how many pages there are (multiply by tablspaces pagesize to get total size). There are also some non-leaf pages, but NLEAF will usually get you with a few percent of the number.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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