DBPedias

All your database knowledge are belong to you

DB2 zOS

SYSIBM.LUNAMES (V8)

Description: The table must contain a row for each remote SNA client or server that communicates with DB2. Rows in this table can be inserted, updated, and deleted.

Tablespace: SYSDDF

Indexes(Fields):
DSNFNX01(LUNAME)

Column name Description Data type
LUNAME 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.
NOT NULL
SYSMODENAME 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.
NOT NULL
WITH DEFAULT
SECURITY_IN 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.

NOT NULL WITH
DEFAULT 'A'
SECURITY_OUT 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 ENCRYPTPWDS column.
The USERNAMES column must specify 'B' or 'O'.

NOT NULL WITH
DEFAULT 'A'
ENCRYPTPSWDS This column only applies to DB2 UDB 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 DB2 Version 5 and later, we recommend using 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.

NOT NULL WITH
DEFAULT 'N'
MODESELECT 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.

NOT NULL WITH
DEFAULT 'N'
USERNAMES 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.

NOT NULL WITH
DEFAULT
GENERIC 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

NOT NULL WITH
DEFAULT 'N'
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).

Retrieved from "http://dbpedias.com/w/index.php?title=DB2_zOS:SYSIBM.LUNAMES_(V8)&oldid=21922"