USERNAMES table

Each row in the USERNAMES table is used to carry out one outbound ID translation or inbound ID translation and come from checking. The schema is SYSIBM.

Rows in this table can be inserted, updated, and deleted.

Table 1. SYSIBM.USERNAMES table column descriptions
Column name Data type Description Use
TYPE
CHAR(1)
NOT NULL
 How the row is to be used:
I
For inbound translation and come from checking.
O
For outbound translation.
S
For outbound system AUTHID to establish a trusted connection.
 G
AUTHID
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Authorization ID to be translated. Applies to any authorization ID if blank. G
LINKNAME
VARCHAR(24)
NOT NULL
 Identifies the VTAM® or TCP/IP network locations associated with this row. A blank value in this column indicates this name translation rule applies to any TCP/IP or SNA partner.

If a non-blank LINKNAME is specified, one or both of the following statements must be true:

  • A row exists in SYSIBM.LUNAMES whose LUNAME matches the value specified in the SYSIBM.USERNAMES LINKNAME column. This row specifies the VTAM site associated with this name translation rule.
  • A row exists in SYSIBM.IPNAMES whose LINKNAME matches the value specified in the SYSIBM.USERNAMES LINKNAME column. This row specifies the TCP/IP host associated with this name translation rule.

    Inbound name translation and come from checking are not performed for TCP/IP clients.

 G
NEWAUTHID
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Translated value of AUTHID. Blank specifies no translation. NEWAUTHID can be stored as encrypted data by calling the DSNLEUSR stored procedure. To send the encrypted value of AUTHID across a network, one of the encryption security options in the SYSIBM.IPNAMES table should be specified. G
PASSWORD
VARCHAR(255)
NOT NULL WITH
DEFAULT
 Password to accompany an outbound request, if passwords are not encrypted by RACF®. If passwords are encrypted, or the row is for inbound requests, the column is not used. PASSWORD can be stored as encrypted data by calling the DSNLEUSR stored procedure. To send the encrypted value of PASSWORD across a network, one of the encryption security options in the SYSIBM.IPNAMES table should be specified. G
IBMREQD
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies.

 G