column	onstat  option	description
number	-d	the storage space number
name	-d	name of the storage space
class	infx	status monitor setting based on free space
flags	-d	flags describing the state of the space
pgsize	-d	size in bytes of a page in this space
pgsizek	infx	the page size in kb
nchunks	-d	number of chunks in storage space
size_kb	-d	size of storage space in kb
free_kb	-d	amount of space free
used_kb	-d	amount of space used
bpages_kb	-d	size of space in blob pages, for spaces that contain blobs
meta_size_kb	-d	smart blob spaces: the size in kb of the meta data area
meta_free_kb	-d	smart blob spaces: the amount of free space for meta data
meta_used_kb	-d	smart blob spaces: the amount of meta data used
meta_bpages	-d	smart blob spaces: size of the meta data area in blob pages
ismirrored	infx	yes if space is mirrored
istemp	infx	yes if space is a temp space
issbspace	infx	yes, if space is a smart blob space
isblobspace	infx	yes, if space is a blob space
status	infx	the state of the dbspace e.g. OK, DOWN
status_class	infx	font class to describe status e.g. warn, error, ok, good
flagmean	infx	text description of storage space flags
used_perc	infx	percentage of storage space used
used_perc_class	infx	class to describe percentage used, e.g. ok, warn, bad
totio_kb	infx	the total i/o, in kb to this storage space (buffer and page)
reads_kb	-D	the total reads from this storage space
writes_kb	-D	the total writes to this storage space
l0_date	infx	date of last level 0 for this space, also available for L!, L2
l0_datet	infx	date and time of last level 0 for this space, also available for L!, L2
l0_ago	infx	how long ago in days and hours since L0
l0_ts	infx	unix timestamp of last archive
l0_log	infx	logical log number at archive
l0_logpos	infx	logical log position at archive
chunk_list	infx	an array of chunks in the storage space, see below

chunk list

column	onstat  option	description
rownum	infx	id for the record
chunkno	-d	unique number for this chunk
chunk	-d	name of the chunk file
space	-d	storage space number
path	-d	full path name of the chunk
finalpath	-d	if chunk is a link, what it points to
size_kb	-d	size of this chunk
offset_kb	-d	offset into file to start this chunk
used_kb	-d	amount of space used in this chunk
free_kb	-d	amount of space available in this chunk
bpages	-d	size of chunk in blob pages
msize	-d	smart blob spaces: size of meta data area
mfree	-d	smart blob spaces: meta data space available
mbpages	-d	smart blob spaces: size of meta data area in blob pages
reads_kb	infx	amount in kb read from this chunk
writes_kb	infx	amount in kb written to this chunk
chunkdown	infx	yes if chunk is flagged as down
ismirrored	infx	yes if chunk has a mirror
flagmean	infx	descriptive text describing chunk flags
status	infx	the status of the chunk, e.g. OK, DOWN
status_class	infx	class to define the status e.g. good, bad, warn

chunkfile list

restore

infx checks storage space flags, the instance status and what other services are running, then determines which restore modes are valid at

this point.