Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002

    Unanswered: Space information by database

    For a given database, I want to know space information by table. The tables are not all in the default dbspace for the database.

    What is the easiest non-instrusive way to do this? oncheck -pe?

  2. #2
    Join Date
    Mar 2002


    You can select it from system table (I'm no sure what table is) for all information If you afraid that it's old data you can update statistics low for table it will update information in system table

  3. #3
    Join Date
    Mar 2002
    If you know how to construct such a query for non-fragmented tables, I would appreciate knowing as well. I have looked at all of the catalog tables and can't find the information I need.

    The only way that I can see for determining this information is by using "oncheck -pe".

  4. #4
    Join Date
    Mar 2002
    use sysmaster database :

    select tabname , <systabinfo.fileds_you_want> from systabnames n,
    systabinfo i
    where n.partnum = i.ti_partnum

    from systabinfo you should choose
    ti_nextns ( number of extents )
    ti_nptotal ( space allocated )
    ti_npused ( space used )
    ti_npdata ( space used by data , indexes excluded )
    some tables that you know that have not too much indexes
    low ti_npdata and high and almost npused = nptotal
    will be probably wasting space and you should unload
    all data , recreate the table e load data again
    and then build the indexes

    iīd like to know the meaning of ti_flags ....

Posting Permissions

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