Configuring DRMS FEP Database Tables
This section describes the FEP database tables. It is recommended that the tables (DRMS_FEPS, DRMS_FEP_CONNECTIONS, and DRMS_COS_FEPS) INSERT statements be added to the <customer>_retain_drms.sql configuration file.
DRMS_FEPS Table
The customer's FEPs are stored in the DRMS_FEPS table. The format of the DRMS_FEPS table is as follows:
• fep_id: Unique identifier for the FEP, generated using the drms_feps_sequence Oracle sequence.
• name: Descriptive name for the FEP.
• enabled: Indicates if the FEP is enabled ('Y'), disabled ('N'), or archived ('A' for no longer valid).
• debug: Indicates if debug mode is enabled for this FEP ('Y' or 'N').
• keep_alive: Interval in milliseconds between keep-alive messages sent to the FEP. A value of zero disables keep-alive functionality.
• connect_retry_interval: Connection retry interval in milliseconds.
• ca_certs_alias: Alias under which the FEP's Certificate Authority (CA) certificate is stored in the trust keystore. The CA certificate used to sign the FEP’s public keys must be stored in a truststore under this alias.
• is_secure: Specifies whether secure communication to the FEP is enabled ('Y') or disabled ('N'; default).
Sample Insert Statement:
INSERT INTO drms_feps (
fep_id,
name,
enabled,
debug
)
VALUES (
drms_feps_sequence.nextval,
'FEP_A',
'Y',
'Y'
);
DRMS_COS_FEPS Table
The DRMS_COS_FEPS table contains real-time information associated with each FEP, specifically the ID of the active connection.
• fep_id: Unique ID of the FEP.
• active_connection: Unique ID of the current (or last) active FEP connection. This value can be NULL if there has never been an active connection.
Sample Insert Statement
INSERT INTO drms_cos_feps (fep_id)
SELECT fep_id
FROM drms_feps
WHERE name = 'FEP_A';
DRMS_FEP_CONNECTIONS Table
The DRMS_FEP_CONNECTIONS table holds information for each available redundant connection to every FEP. The format of the table includes:
• fep_id: Unique ID of the FEP.
• connect_id: Unique identifier for the connection, generated using the drms_fep_connections_sequence Oracle sequence.
• name: Descriptive name for the FEP connection.
• enabled: Indicates whether the connection is enabled ('Y') or disabled ('N').
• connect_order: Preferred connection order; the lowest value is most preferred when multiple connections exist.
• ip_address: The TCP/IP address for the FEP.
• port: The TCP/IP port for the connection.
Sample Insert Statement
INSERT INTO drms_fep_connections (
fep_id,
connect_id,
name,
enabled,
connect_order,
ip_address,
port
)
SELECT fep_id,
drms_fep_connections_sequence.nextval,
'Main',
'Y',
10,
'127.0.0.1',
55001
FROM drms_feps
WHERE name = 'FEP_A';