Start of Content Area

Procedure documentation Checking Parameter Changes (Informix)  Locate the document in its SAP Library structure

Use

You can use the detailed database analysis in the SAP/Informix database monitor to check parameter changes. You can use this procedure to display current and historical values of the ONCONFIG parameters. The information displayed in this procedure is read from the SYSMASTER table SYSCFGTAB . For more information about SYSMASTER tables, see your Informix documentation.

Prerequisites

You need Informix version 7.x or later to use the full functionality described in this procedure.

Procedure

  1. Choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Database ® Activity ® Detail Analysis Menu ® Parameter Changes.

    2. The system displays the date of the most recent change to a database parameter.

  2. To view the changes within a specific time period, choose Select Period, entering a valid date in the format DD.MM.YYYY (for example, 24.11.1999) when the system prompts you.

    3. The system displays a list of changes with the most recent change at the top of the list. For each change the system displays the Mod.Date (that is, the date the parameter was changed), the Parameter name, and the parameter’s New Value.

  3. To view the current value of parameters, choose Active Parameters.

    4. The system displays the current parameter values.

  4. To view the full history of parameter changes, choose History of file.

The system displays the Parameter names in alphabetical order. For each parameter, the system displays a list of changes, showing the Mod.Date (that is, the date the parameter was changed) and the parameter’s New Value after the change.

Caution

You can also display ONCONFIG parameters using onstat -c . However, this reads directly from the current ONCONFIG file. This file might contain new parameter changes, which take effect only after the next database restart.