LUNAMES catalog table

The LUNAMES table must contain a row for each remote SNA client or server that communicates with Db2. The schema is SYSIBM.

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

Table 1. SYSIBM.LUNAMES table column descriptions
Column name Data type Description Use
LUNAME
VARCHAR(24)
NOT NULL
 Name of the LU for one or more accessible systems. A blank string indicates the row applies to clients whose LU name is not specifically defined in this table.

All other column values for a given row in this table are for clients and servers associated with the row's LU name.

 G
SYSMODENAME
VARCHAR(24)
NOT NULL
WITH DEFAULT
 Mode used to establish inter-system conversations. A blank indicates the default mode IBMDB2LM (Db2 private protocol access and for collecting sysplex balancing information from remote data sharing groups).

If private protocols are used to access a remote Db2 LU or if the remote LU is a member of a Db2 data sharing group, use a separate mode other than the default mode.

 G
SECURITY_IN
CHAR(1)
NOT NULL WITH
DEFAULT 'A'
 This column defines the security options that are accepted by this Db2 when an SNA client connects to Db2:
V
The option is verify. An incoming connection request must include one of the following: a userid and password, a userid and RACF® PassTicket, or a Kerberos security ticket.
A
The option is already verified. A request does not need a password, although a password is checked if it is sent.

With this option, an incoming connection request is accepted if it includes any of the following: a userid, a userid and password, a userid and RACF PassTicket, or a Kerberos security ticket.

If the USERNAMES column contains 'I' or 'B', RACF is not invoked to validate incoming connection requests that contain only a userid unless one of the following situations is true:
  • The RACF access control authorization exit (DSNX@XAC) is enabled
  • The IBM® supplied RACF SECLABEL resource class is active.
 G
SECURITY_OUT
CHAR(1)
NOT NULL WITH
DEFAULT 'A'
 This column defines the security option that is used when local Db2 SQL applications connect to any remote server associated with this LUNAME:
A
The option is already verified. Outbound connection requests contain an authorization ID and no password.

The authorization ID used for an outbound request is either the Db2 user's authorization ID or a translated ID, depending upon the value of the USERNAMES column.

R
The option is RACF PassTicket. Outbound connection requests contain a userid and a RACF PassTicket. The server's LU name is used as the RACF PassTicket application name.

The authorization ID used for an outbound request is either the Db2 user's authorization ID or a translated ID, depending upon the value of the USERNAMES column.

P
The option is password. Outbound connection requests contain an authorization ID and a password. The password is obtained from the SYSIBM.USERNAMES table or RACF, depending upon the value specified in the ENCRYPTPSWDS column.

The USERNAMES column must specify 'B' or 'O'.

 G
ENCRYPTPSWDS
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
 This column only applies to Db2 for z/OS® partners. It is provided to support connectivity to prior releases of Db2 that are unable to support RACF PassTickets.
For connections between Version 5 and later, use the SECURITY_OUT='R' option instead of the ENCRYPTPSWDS='Y' option.
N
No, passwords are not in internal RACF encrypted format. This is the default.
Y
Yes for outbound requests, the encrypted password is extracted from RACF and sent to the server. For inbound requests, the password is treated as encrypted.
 G
MODESELECT
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
 Whether to use the SYBIBM.MODESELECT table:
N
Use default modes: IBMDB2LM (for Db2 private protocol) and IBMRDB (for DRDA).
Y
Searches SYSIBM.MODESELECT for appropriate mode name.
 G
USERNAMES
CHAR(1)
NOT NULL WITH
DEFAULT
 This column controls inbound and outbound authorization ID translation, and come from checking.

Inbound translation and come from checking are performed when an authorization ID is received from a remote client.

Outbound translation is performed when an authorization ID is sent by Db2 to a remote server.

When 'I', 'O', or 'B' is specified in this column, rows in the SYSIBM.USERNAMES table are used to perform ID translation.
I
An inbound ID is subject to translation and come from checking.

No translation is performed on outbound IDs.

O
No translation or come from checking is performed on inbound IDs.

An outbound ID is subject to translation.

B
An inbound ID is subject to translation and come from checking.

An outbound ID is subject to translation.

blank
No translation occurs.
 G
GENERIC
CHAR(1)
NOT NULL WITH
DEFAULT 'N'
 Indicates whether Db2 should use its real LU name or generic LU name to identify itself to the partner LU, which is identified by this row.
N
The real VTAM® LU name of this Db2 subsystem
Y
The VTAM generic LU name of this Db2 subsystem
 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