space

Extensive information about storage spaces and chunks.

section description
dbspace summary summary and total information for dbspaces
chunk file summary summary and total information for chunk files
dbspace_list detail records for dbspaces
chunk_list detail records for chunks
chunkfile_list detail records for chunk files
restore counters used to track restores

dbspace summary

Summary information about storage spaces.

column description
dbspace_spaces the total number of permanent storage spaces
dbspace_size_kb the total size of all permanent storage spaces, in kb
dbspace_used_kb the total amount of storage space used in kb
dbspace_free_kb the total amount of storage space free
dbspace_temp_size_kb the size of all temp spaces
dbspace_temp_used_kb the amount of temporary storage used
dbspace_temp_free_kb the amount of temporary storage fre
dbspace_down_spaces the total number of storage spaces down
dbspace_down_kb the total amount of space in down storage spaces
dbspace_plog_kb the total amount of physical log storage
dbspace_llog_kb the total amount of logical log storage

chunk file summary

Summary information about individual chunk files

column description
chunklist_num the total number of permanent storage spaces
chunklist_size_kb the total size of all permanent storage spaces, in kb
chunklist_used_kb the total amount of storage space used in kb
chunklist_free_kb the total amount of storage space free

dbspace list

List of storage spaces in the instance
column onstatoption 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 dbspacee.g.OK, DOWN
status_class infx font class to describe statuse.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

List of chunks for a specific storage space

column onstatoption 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 statuse.g.good, bad, warn

chunkfile list

A summary of each chunk file in the instance.

column onstatoption description
chunkno -d unique number for this chunk
chunk -d name of the chunk file
path -d full path name of the chunk
size_kb -d size of this chunk
used_kb -d amount of space used in this chunk
free_kb -d amount of space available in this chunk
reads_kb infx amount in kb read from this chunk
writes_kb infx amount in kb written to this chunk
totio_kb infx total reads and writes to this chunk
chunks infx the chunk of storage space chunks on this file
flagmean infx descriptive text describing chunk flags
chunklist_chunks infx an array of storage space chunks that reference this chunk file, see above

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.

column description
dbspace_restored_kb amount of permanent storage spaces restored
dbspace_torestore_kb amount of permanent storage remaining to restore
dbspace_torestore_spaces the number of storage spaces that require a restore
dbspace_pr_perc percentage of restored kb to used kb
dbspace_db_perc percentage of spaces restore to the number of spaces
dbspace_pl_total_kb combined amount of physical and logical log to restore
dbspace_pl_rest_kb amount of physical and logical log restored so far
dbspace_pl_remain_kb amount of physical and logical log remaining to restore
dbspace_pl_perc percentage of physical and logical log that is restored
can_restore yes if a restore can be started
can_restore_full yes if a full restore can be started
can_restore_physical yes if a physical restore can be started
can_restore_external yes if an external restore can be started
can_restore_logical yes if a logical restore can be started
can_restore_warm yes if a warm restore can be started
can_restore_hot yes if a hot restore can be started