You can use SAPDBA for Informix to analyze all the information held by the database server on a single table. SAPDBA calls the Informix command oncheck -pT for this report. You can use this report to:

• Calculate an exact size for an index (SAPDBA normally displays an approximate value for this), especially with fragmented indexes and tables (Informix version 7.1 or later).

• Display very detailed information about tables, blobpages, indexes and so on. For example, you can see the details of physical storage, creation date and time, how full the blobpages are, how the index is structured, and so on.

• Display detailed information about table fragments (Informix version 7.1 or later).

• SAPDBA is installed correctly. Refer to SAPDBA Setup.
• You know how to use SAPDBA and have logged on. Refer to Starting SAPDBA.

1. Choose Reorganization → TBLspace Disk Util. Report in SAPDBA for Informix.
2. In table name, enter data as required. If you do not know the name of the table you want, you can use a partial entry (for example, a0*) and SAPDBA lists the matching tables.
3. Execute the report.



When you execute this report, the table it reads is locked and this might last some time, particularly for large tables. This can affect the operation of the R/3 System if it requires access to the same table. Therefore, it is best to execute this report when the R/3 System is down or not being heavily used. SAPDBA warns you of this.

SAPDBA displays the report.



For this report, SAPDBA uses the normal oncheck -pT display, in pages. For other reports, SAPDBA displays output in kilobytes (KB).

To convert, multiply the number of pages given in oncheck by the page size of your system.

For more information about the entries in the report, see the Informix documentation.

4. To print the report, choose Print. Refer to Printing a SAPDBA Report.

You now have a very detailed picture of the storage situation for the table in question. For more information if you want to perform a reorganization, see Reorganizing a Single Table with SAPDBA.