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