PPM_SERVER_INSTANCE
This table stores the history of server restarts and registration of all nodes in the server cluster.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KCRT_STATUSES_NLS |
STATUS_ID |
STATUS_ID |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KNTA_USERS |
USER_ID |
CREATED_BY |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
ID |
NOT NULL |
NUMBER |
System-generated identifier |
VERSION |
NOT NULL |
NUMBER |
Version of the PPM Center |
SERVER_NAME |
NULLABLE |
VARCHAR2(2000) |
PPM Server name |
STATUS_ID |
NOT NULL |
NUMBER |
Status of PPM Server. Possible values: |
START_TIME |
NOT NULL |
DATE |
PPM Server start time |
END_TIME |
NULLABLE |
DATE |
PPM Server shutdown time |
URL_BASE |
NULLABLE |
VARCHAR2(2000) |
Base URL of RMI |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
AVAILABLE_LIGHT_LISTENERS |
NULLABLE |
NUMBER |
|
AVAILABLE_HEAVY_LISTENERS |
NULLABLE |
NUMBER |
|
SERVER_IP | NULLABLE | VARCHAR2 (20) | PPM Server private IP |
HTTP_PORT | NULLABLE | NUMBER | PPM Server HTTP port |
PUBLIC_IP | NULLABLE | VARCHAR2 (20) | PPM Server public IP |
PUBLIC_DNS | NULLABLE | VARCHAR2 (70) | PPM Server public DNS |
RMI_PORT | NULLABLE | NUMBER | PPM Server RMI port |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
PPM_SERVER_INSTANCE_N1 |
NONUNIQUE |
1 |
SERVER_NAME |
PPM_SERVER_INSTANCE_PK |
UNIQUE |
1 |
ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
PPM_SERVER_INSTANCE_S |
ID |