
RDB_ENTRY_INFO view
The RDB_ENTRY_INFO view returns information about relational database (RDB) directory entries.
The values returned for the columns in the view are similar to the values returned by the Display RDB Directory Entries (DSPRDBDIRE) CL command.
Authorization: None required.
The following table describes the columns in the view. The system name is RDB_INFO. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
RDB_NAME | RDB_NAME | VARCHAR(18) | The name of the relational database. |
RDB_ALIAS | RDB_ALIAS | VARCHAR(18) Nullable
|
The RDB alias name. Contains the null value if no RDB alias is defined. |
REMOTE_LOCATION_TYPE | RMT_TYPE | VARCHAR(4) Nullable
|
The remote location type.
Contains the null value if the value does not apply. |
REMOTE_LOCATION | RMT_LOC | VARCHAR(254) | The remote location name of the system on which the RDB is located.
|
TEXT_DESCRIPTION | TEXT | VARGRAPHIC(50) CCSID 1200 Nullable
|
The text description for this relational database entry.
Contains the null value is there is no descriptive text. |
REMOTE_PORT_OR_SERVICE | RMT_PORT | VARCHAR(14) Nullable
|
The relational database entry port number or service name that is
used at the remote location to communicate with the system on which the RDB is located. If *DRDA was
specified, the Distributed Relational Database Architecture (DRDA) port is 446. Contains the null value if REMOTE_LOCATION_TYPE is not *IP. |
PREFERRED_AUTHENTICATION | PREF_AUTH | VARCHAR(10) Nullable
|
The preferred authentication method on a connection request.
Contains the null value if REMOTE_LOCATION_TYPE is not *IP. |
LOWER_AUTHENTICATION | LOWER_AUTH | VARCHAR(11) Nullable
|
Whether an authentication method lower than what was specified
for the preferred method will be accepted during negotiation with the server.
Contains the null value if REMOTE_LOCATION_TYPE is not *IP. |
ENCRYPTION_ALGORITHM | ENCRYPTION | VARCHAR(4) Nullable
|
The encryption algorithm to be used initially on the connection request.
Contains the null value if the encryption algorithm does not apply. |
SECURE_CONNECTION | SECURE | VARCHAR(5) Nullable
|
Whether Transport Layer Security (TLS) is to be used on a
DDM/DRDA TCP/IP connection request.
Contains the null value if REMOTE_LOCATION_TYPE is not *IP. |
APPC_DEVICE_DESCRIPTION | APPC_DEVD | VARCHAR(10) Nullable
|
The Advanced Program-to-Program Communications (APPC) device
description on this system that is used with this RDB entry. Can contain the special value:
Contains the null value if REMOTE_LOCATION_TYPE is not *SNA. |
LOCAL_LOCATION | LOCAL_LOC | VARCHAR(8) Nullable
|
The local location name by which this system is identified to the
system on which the RDB is located. Can contain one of the following special values:
Contains the null value if REMOTE_LOCATION_TYPE is not *SNA. |
REMOTE_NETWORK_ID | RMT_NETID | VARCHAR(8) Nullable
|
The remote network identifier of the system on which the RDB is
located. Can contain one of the following special values:
Contains the null value if REMOTE_LOCATION_TYPE is not *SNA. |
REMOTE_MODE | RMT_MODE | VARCHAR(8) Nullable
|
The mode name to use with the remote location name to communicate
with the system on which the RDB is located. Can contain one of the following special values:
Contains the null value if REMOTE_LOCATION_TYPE is not *SNA. |
TRANSACTION_PROGRAM | TRANS_PGM | VARCHAR(8) FOR BIT DATA Nullable
|
The name of the transaction program to use with the RDB entry.
Contains the null value if REMOTE_LOCATION_TYPE is not *SNA. |
ARD_LIBRARY | ARD_LIB | VARCHAR(10) Nullable
|
The library containing the Application Requester Driver (ARD)
program. Can contain the special values *LIBL or *CURLIB. Contains the null value if REMOTE_LOCATION is not *ARDPGM. |
ARD_PROGRAM | ARD_PGM | VARCHAR(10) Nullable
|
The ARD program to be called to process SQL requests directed to
the RDB. Contains the null value if REMOTE_LOCATION is not *ARDPGM. |
Example
- Find any RDBs that might be sending authentication data in the clear
SELECT * FROM QSYS2.RDB_ENTRY_INFO WHERE PREFERRED_AUTHENTICATION IN ('*USRID', '*USRIDPWD', '*USRENCPWD');
