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™.
Logging and log administration
Manage the physical log
Monitor checkpoint informationMonitor checkpoint activity to view information that includes the number of times that threads were required to wait for the checkpoint to complete. This information is useful for determining if the checkpoint interval is appropriate.
SMI tables

SMI tables

Query the sysprofile table to obtain statistics on the physical-log and logical-log buffers. The sysprofile table also provides the same checkpoint statistics that are available from the onstat -p option. These rows contain the following statistics.

plgpagewrites: Number of pages written to the physical-log buffer
plgwrites: Number of writes from the physical-log buffer to the physical log file
llgrecs: Number of records written to the logical-log buffer
llgpagewrites: Number of pages written to the logical-log buffer
llgwrites: Number of writes from the logical-log buffer to the logical-log files
numckpts: Number of checkpoints that have occurred since the database server was brought online)
ckptwaits: Number of times that threads waited for a checkpoint to finish entering a critical section during a checkpoint
value: Values for numckpts and ckptwaits