Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    21

    Unanswered: finding the table volumes.

    I've 20 tables in the database. How can I find the top table in volume?

  2. #2
    Join Date
    Dec 2005
    Posts
    273
    Run the RUNSTATS utility and then check the column NPAGES of the
    SYSIBM.SYSTABLES catalog table.
    This columns stores the number of pages used by the table

  3. #3
    Join Date
    Nov 2007
    Posts
    21
    Thanks, it's giving the pages information.

    I've seen the rows in the SYSIBM.SYSTABLES and found that some values of NPAGES are -1.

    Can any one please explain NPAGES=-1?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Did you RUNSTATS on the table?

    -1 can also mean that the 'table' is a view or alias.

    BTW, to know the size of the table, you'll have to multiply the npages with the pagesize of the tablespace.

    Oh, don't forget the size of indexes either.

    If you are using DB2 LUW, I would recommend using the catalog view SYSCAT.TABLES instead of the SYSIBM.SYSTABLES.

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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