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

Copyright© 2019 HCL Technologies Limited