SMI tables
Query the syschunks table to obtain the status of a chunk. The following columns are relevant.
- chknum
- Number of the chunk within the dbspace
- dbsnum
- Number of the dbspace
- chksize
- Total size of the chunk in pages
- nfree
- Number of pages that are free
- is_offline
- Whether the chunk is down
- is_recovering
- Whether the chunk is recovering
- mis_offline
- Whether the mirror chunk is down
- mis_recovering
- Whether the mirror chunk is being recovered
The syschkio table contains the following columns.
- pagesread
- Number of pages read from the chunk
- pageswritten
- Number of pages written to the chunk