Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012
    Posts
    1

    Question Unanswered: Space of specific tables in the Informix database

    Dear all,

    Hope all is well.

    I have a question with regards to how to uncover the space available and used in each table of an Informix database.
    Is it possible to output the same results as the command sp_spaceused for SQL server, and hence output the below results:

    name rowtotal reserved data index_size unused
    ---------- --------- --------- ------- ---------- ----------
    titles 18 46 KB 6 KB 4 KB 36 KB

    Can this be done via a command or an sql program?

    Thanks in advance and I appreciate your help.

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    data are not organized exactly the same way in Informix than sql server. nevertheless you have several way to achieve your goal
    1) command line: oncheck -pt databasename:tablename, but since the table fits in one or several dbspaces, there os no notion of unused space.
    2) command : oncheck -pe dbspacename: you will see what space the tables occupy, and also the space available in the dbspace
    3) if you like sql statements make a join between systabinfo and systabnames in the sysmaster database, and you will also have what you want
    Cheap and easy :-)
    Hope this helps

Tags for this Thread

Posting Permissions

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