The oncheck -pe command

To obtain the physical layout of information in the chunk, run oncheck -pe. The dbspaces, blobspaces, and sbspaces are listed. The following example shows sample output for oncheck -pe.

The following information is displayed:
  • The name, owner, and creation date of the dbspace
  • The size in pages of the chunk, the number of pages used, and the number of pages free
  • A listing of all the tables in the chunk, with the initial page number and the length of the table in pages
The tables within a chunk are listed sequentially. This output is useful for determining chunk fragmentation. If the database server is unable to allocate an extent in a chunk despite an adequate number of free pages, the chunk might be badly fragmented.
DBSpace Usage Report:  rootdbs          Owner:  informix  Created: 08/08/2006

Chunk  Pathname                                   Size     Used     Free
    1  /home/server/root_chunk                   75000    19420    55580

Description                                               Offset    Size
-------------------------------------------         --------------------
RESERVED PAGES                                               0        12
CHUNK FREELIST PAGE                                         12         1
rootdbs:'informix'.TBLSpace                                 13       250
PHYSICAL LOG                                               263      1000
FREE                                                      1263      1500
LOGICAL LOG: Log file 2                                   2763      1500
LOGICAL LOG: Log file 3                                   4263      1500
...
sysmaster:'informix'.sysdatabases                        10263         4
sysmaster:'informix'.systables                           10267         8
...

Chunk  Pathname                                   Size     Used     Free
    2  /home/server/dbspace1                      5000       53     4947

Description                                               Offset    Size
-------------------------------------------         --------------------
RESERVED PAGES                                               0         2
CHUNK FREELIST PAGE                                          2         1
dbspace1:'informix'.TBLSpace                                 3        50
FREE                                                        53      4947