Monitoring Configuration Information

Home | Previous Page | Next Page The Database Server > Configuration Parameters >

Monitoring Configuration Information

One of the tasks of the database server administrator is to keep records of the configuration. Table 5 describes methods of obtaining configuration information.

Table 5. Monitoring Configuration Information
Command	Description
onstat -c	Displays a copy of the ONCONFIG file. For more information, see Configuring the Database Server. Changes to the ONCONFIG file take effect when you shut down and restart the database server, also called reinitializing shared memory. If you change a configuration parameter but do not shut down and restart the database server, the effective configuration differs from what the onstat -c option displays. The values of the configuration parameters are stored in the file indicated by the ONCONFIG environment variable or, if you have not set the ONCONFIG environment variable, in $INFORMIXDIR/etc/onconfig on UNIX or %INFORMIXDIR%\etc\onconfig.std on Windows.
oncheck -pr	Lists the reserved page. The database server also stores current configuration information in the PAGE_CONFIG reserved page. If you change the configuration parameters from the command line and run oncheck -pr without shutting down and restarting the database server, the configuration values that oncheck displays do not match the current values in the reserved pages. The oncheck utility returns a warning message.
ON–Monitor (UNIX)	Select Status > Configuration to create a copy of the current configuration and store it in the directory and file that you specify. If you specify only a filename, the database server stores the file in the current working directory. Changes to the configuration parameters take effect when you shut down and restart the database server.
ISA	Displays or updates the configuration parameters.

Figure 2 shows sample output from the oncheck -pr command.

Figure 2. PAGE_CONFIG Reserved Page

...

Validating Informix database server reserved pages - PAGE_CONFIG
    ROOTNAME                       rootdbs
    ROOTPATH                       /home/dyn_srv/root_chunk
    ROOTOFFSET                     0
    ROOTSIZE                       8000
    MIRROR                         0
    MIRRORPATH
    MIRROROFFSET                   0
    PHYSDBS                        rootdbs
    PHYSFILE                       1000
    LOGFILES                       5
    LOGSIZE                        500
    MSGPATH                        /home/dyn_srv/online.log
    CONSOLE                            /dev/ttyp5
...                                ...