How to retrieve IBM Informix Server Configuration File settings from sysmaster

Problem(Abstract)

This article describes a method to find the IBM Informix Dynamic Server configuration file settings.

Resolving the problem

INTRODUCTION

The values in the onCONFIG configuration file may not be the settings current in effect by the database server. This is true when:

• One of the parameters in the file is changed after the database server is started

• A parameter has been changed dynamically with the onparams utility

• A parameter that has been change dynamically with the onmode utility

You can find out what configuration parameters the database server is currently using by running an SQL query against the sysmaster database. 


BEFORE YOU BEGIN 

The database server must be running. 


STEPS 

1. Start an application that allows you to make queries on the database server (dbaccess, for example). 

2. Connect to the sysmaster database on the database server. 

3. Execute this SQL: 

SELECT cf_name, cf_default, cf_effective, cf_original FROM   syscfgtab;

Each row returned in the output represents one configuration parameter. Here is a definition of each of the columns: 

Column name	Meaning
cf_name	This is the parameter name.
cf_default	This is the default value if no valid value is present in the onCONFIG file.
cf_effective	This is the current value of the parameter.
cf_original	This is the value the parameter had when the database server was started.