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 ReferenceThe HCL OneDB™ Administrator's Reference includes comprehensive descriptions of HCL OneDB™ configuration parameters, the system-monitoring interface (SMI) tables in the sysmaster database, the syntax of database server utilities such as onmode and onstat, logical-log records, disk structures, event alarms, and unnumbered error messages.
Configuring and monitoring HCL OneDB™
The sysmaster databaseThese topics describe the sysmaster database and provide reference information for the system-monitoring interface (SMI).
The System-Monitoring Interface TablesThe sysmaster database contains many tables that you can use to monitor your system.
Information from onstat in the SMI Tables

Information from onstat in the SMI Tables

To obtain information provided by the onstat utility, you can use SQL to query appropriate SMI tables. The following table indicates which SMI tables to query to obtain the information provided by a given onstat option. For descriptions of the onstat options, see Monitor the database server status.


onstat Option	SMI Tables to Query	onstat Fields Not in SMI Tables
-d	sysdbspaces syschunks	address bpages
-D	sysdbspaces syschkio
-F	sysprofile	address flusher snoozer state data
-g ath	systhreads
-g dri	sysdri	Last DR CKPT (id/pg)
-g glo	sysvpprof	Listing of virtual processors by
-g ipl	sysipl
-g rss	sysrsslog systrgrss syssrcrss
-g his	syssqltracing
-g sds	syssrcsds systrgsds
-g smx	syssmx
-g smx ses	syssmxses
-k	syslocks	address lklist tblsnum
-l	syslogs sysprofile	All physical-log fields (except numpages and numwrits) All logical-log buffer fields (except numrecs, numpages, and numwrits) address begin % used
-p	sysprofile
-u	syssessions syssesprof	address wait nreads nwrites

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.