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.

Table 1. RDB_ENTRY_INFO view
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. IP The RDB is found using a host name or an internet address over a TCP/IP connection. SNA The RDB is accessed using a Systems Network Architecture (SNA) address and protocol. 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. remote-location-name The remote location name is in one of the following formats: SNA remote location name (LU name). SNA remote network identifier and remote location name separated by a period. IPv4 address in dotted decimal form. IPv6 address in colon hexadecimal form. IP host domain name. ARDPGM The RDB is accessed by using the Application Requester Driver (ARD) program. LOCAL The system database on this system. LOOPBACK This value is an alias for the IP address of the host system. *MIRROR The RDB is accessed on the other system for a Db2® Mirror relationship.
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. ENCUSRPWD Encrypted user ID and encrypted password. KERBEROS Authentication occurs using Kerberos. USRENCPWD User ID and encrypted password. USRID User ID only. USRIDPWD User ID and password. 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. ALWLOWER Allow negotiation of a lower authentication method. NOALWLOWER Do not allow negotiation of a lower authentication method. 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. AES Advanced Encryption Standard (AES) is to be used initially. DES Data Encryption Standard (DES) is to be used initially. 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. NONE TLS is not used. TLS TLS is used. 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: LOC If APPC is being used, the system determines which device description is used. 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: LOC If APPC is being used, the system determines which local location name is used. NETATR The LCLLOCNAME value specified in the system network attributes is used. 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: LOC If APPC is being used, the system determines which remote network identifier is used. NETATR The remote network identifier specified in the network attributes is used. NONE No remote network identifier is used. 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: NETATR The mode in the network attributes is used. BLANK A mode name of all blanks is used. 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. transaction-program-name The transaction program name is in one of the following formats: A 4-byte hexadecimal name. For example, X'07F6C4C2'. An 8-byte character name. The value DRDA, which means the Distributed Relational Database Architecture™ (DRDA) transaction program name is used, X'07F6C4C2'. 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');