DBPedias

All your database knowledge are belong to you

DB2 zOS

SYSIBM.USERNAMES (V8)

Description: Each row in the table is used to carry out one of the following operations:

  • Outbound ID translation
  • Inbound ID translation and "come from" checking

Tablespace: SYSDDF

Indexes(Fields):
DSNFEX01(TYPE.AUTHID.LINKNAME)

Column name Description Data type
TYPE How the row is to be used: ; O
For outbound translation.
I
For inbound translation and "come from" checking.

NOT NULL
AUTHID Authorization ID to be translated. Applies to any authorization ID if blank.
NOT NULL WITH
DEFAULT
LINKNAME 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 nonblank 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.

NOT NULL
NEWAUTHID 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.
NOT NULL WITH
DEFAULT
PASSWORD 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.
NOT NULL WITH
DEFAULT
IBMREQD A value of Y indicates that the row came from the basic machine-readable material (MRM) tape.
NOT NULL WITH
DEFAULT 'N'

Adapted from material found in the IBM DB2 Universal Database for z/OS V8 SQL Reference (SC18-7426-02).