Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Disk, memory, and process management
Manage disk spaceYou can use several utilities and tools to manage disk spaces and the data that the database server controls.
Monitor disk usage
Monitor chunks
SMI tables

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

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.