KNTA_APP_SERVER_PROPERTIES

This table stores all of the server properties found in the PPM Center configuration file (server.conf) as well as internal server parameters initialized when the PPM Center server starts. The SERVER_NAME column indicates what server the properties are associated with. The SERVER_NAME maps directly to the KINTANA_SERVER_NAME property in server.conf. In a single server install, there will be one unique SERVER_NAME for all properties. In a multi-server install, there will be additional SERVER_NAMEs for each secondary server. For a given PPM Center server, this table contains one row for each property, along with the current setting of that property. The contents of the server.conf file are copied into this table each time the PPM Center server is started.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

KEY

NOT NULL

VARCHAR2(80)

Name of the property, such as "BASE_URL"

VALUE

NULLABLE

VARCHAR2(4000)

Value of the property, such as "http://server.kintana.com/kintana/"

SERVER_NAME

NULLABLE

VARCHAR2(80)

Name of the server (as specified by KINTANA_SERVER_NAME in server.conf) that the key and value are associated with

AT_NODE

NULLABLE

VARCHAR2(1)

Indicates whether the value came from a node section in server.conf or not

Indexes

Index Name

Index Type

Sequence

Column Name

KNTA_APP_SERVER_PROPERTIES_N1

NONUNIQUE

1

KEY

KNTA_APP_SERVER_PROPERTIES_U1

UNIQUE

1

SERVER_NAME

KNTA_APP_SERVER_PROPERTIES_U1

UNIQUE

2

KEY

Sequences

This table uses no sequences.