CES_PARAMETERS

The CES_PARAMETERS table stores various configuration options used by NMS and some of its adapters.

CES_PARAMETERS Schema

Column Name	Column Type	Description
APP	VARCHAR2(32)	Application name
ATTRIB	VARCHAR2(64)	Name of parameter
VALUE	VARCHAR2(255)	Value of parameter
MODIFIER	INTEGER	Additional modifier (optional)
SITE	VARCHAR2(255)	The name of the site this parameter applies to or "all" if it applies to all sites. Default: "all"

The APP column is "NMS" for NMS configuration parameters. Other values are used for specific adapters.

Site-specific Parameters

Some parameters are site-specific (see the documentation for each individual parameter). For these parameters, the SITE column must be the NMS_SITE_NAME environment variable at the site to which the parameter applies. For each such parameter, one entry must exist for each site.

Parameters which are not site-specific should have a SITE value of all.

Environment-Specific Parameters

In Dual-Environment Configuration, some parameters are environment-specific (see the documentation for each individual parameter). Different values are used in environment 1 and environment 2. These parameters are configured in two different files as described below

Configuration

CES_PARAMETERS entries are configured in the following three files.

[project]_parameters.sql

Parameters which are neither site-specific nor environment-specific are configured in this file.

[project]_site_parameters_1.sql

Parameters which are site-specific or environment-specific are configured in this file. This file is used for environment number 1 based in the NMS_ENVIRONMENT variable.

[project]_site_parameters_2.sql

Parameters which are site-specific or environment-specific are configured in this file. This file is used for environment number 2 based in the NMS_ENVIRONMENT variable.

NMS_PARAMETERS_VIEW

The NMS_PARAMETERS_VIEW view in the database is a view of the CES_PARAMETERS table that only includes the parameters that apply to the current site. This view includes all columns in CES_PARAMETERS except for SITE.