Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    11

    Unanswered: How to check size of objects from data dict.

    Hello all,

    would anyone know how to query the data dictionary to find out the sizes of objects (tables and indexes)? I'm using SMS.

    Thanks,
    Noel.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How to check size of objects from data dict.

    On the Control Centre, right click on the table name and the menu will show 'Estimate Size' which you can use.

    If you want to know the tablespace usage, the tabelspace list in the Control centre has a Size used column which shows the number of pages used.

    HTH

    Cheers

    Sathyaram

    Originally posted by nekelly
    Hello all,

    would anyone know how to query the data dictionary to find out the sizes of objects (tables and indexes)? I'm using SMS.

    Thanks,
    Noel.

Posting Permissions

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