Results 1 to 2 of 2

Thread: disk disk disk!

  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Wink Unanswered: disk disk disk!

    Hi. My boss wants me to make him a little graph showing (1) how much space we have allocated for our informix database (2) how much is actually in use and (3) how much is free. We run informix on AIX/RS6000s with a raw disk configuration.

    Knowing just a little about how tables are allocated chunks and extents, I think you dont really allocate space to the database, but instead dole it out to tables...right?Ddoes this request make sense? I mean can you really know something meaningful at the database level or do we really need to be looking at least down to the table level?

    I am perfectly willing to be wrong here and seek enlightenment.

    Also, if anyone has any good queries that will help me measure our space utilization that would be wonderful.
    *thanks!*

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: disk disk disk!

    Originally posted by noober
    Hi. My boss wants me to make him a little graph showing (1) how much space we have allocated for our informix database (2) how much is actually in use and (3) how much is free. We run informix on AIX/RS6000s with a raw disk configuration.

    Knowing just a little about how tables are allocated chunks and extents, I think you dont really allocate space to the database, but instead dole it out to tables...right?Ddoes this request make sense? I mean can you really know something meaningful at the database level or do we really need to be looking at least down to the table level?

    I am perfectly willing to be wrong here and seek enlightenment.

    Also, if anyone has any good queries that will help me measure our space utilization that would be wonderful.
    *thanks!*
    Hi there,

    you can try out the below query -

    -- What is the total size of the database

    database sysmaster;
    select sum(ti_nptotal) Total, sum(ti_npused) Used
    from systabnames, systabinfo
    where partnum = ti_partnum
    order by 1

    Alternatively you can visit the foll. link -

    http://www.oninit.com/database/index.html

    Regards,

    lloyd

Posting Permissions

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