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.
Administrative Utilities
The onstat utilityThe onstat utility reads shared-memory structures and provides statistics about the database server at the time that the command runs.
onstat -g monitoring optionsThe options that you can use with onstat -g command are used for support and debugging only. You can include only one of these options in the onstat -g command.
onstat -g dll command: Print dynamic link library file listUse the onstat -g dll command to display a list of and the status of dynamic link library (DLL) files that were loaded.

onstat -g dll command: Print dynamic link library file list

Use the onstat -g dll command to display a list of and the status of dynamic link library (DLL) files that were loaded.

Figure 1: Syntax:

Example output

The output displays the names of the library files only one time each process group. The flags indicate if the library was loaded when the server was started.

Figure 2: onstat -g dll command output

addr           slot  vp baseaddr        flags   filename
0x4af55310     15    1  0x2a985e3000    PM      /finance/jeffzhang/mylib.udr
0x4b6f2310           2  0x2a985e3000      
0x4b71b310           3  0x2a985e3000    
0x4c09f310     16    1  0x2a985e3000    M       /deptxyz/udrs/geodetic.bld
0x4c0c0310           2  0x2a985e3000    
0x4c0f1310           3  0x2a985e3000     
0x4c112310     17    1  0x7a138e9000            /home/informix/extend/blade.so
0x4c133310           2  0x3a421e1000          
0x4c133310           3  0x3a421e1000

Output description

addr

Address of the DLL file

slot

Slot number entry in the library table

vp

ID of the virtual processor

baseaddr

Base address of the shared library

flags

M indicates that the thread calling the UDR can migrate from one CPU virtual processor to another CPU virtual processor.
P indicates that the shared library was loaded when the database server was started.

filename

Name of the DLL file

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.