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.
Column name | Data type | Description | Use |
---|---|---|---|
TYPE | CHAR(1)
NOT NULL |
How the row is to be used:
|
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:
|
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 |