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:
-1/not initialized,
0/initialized,
1/active,
2/shutting down,
3/shut down,
4/error

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