The SYSIBM.SYSLUNAMES table defines the network attributes of remote systems on DB2/MVS v4.1. To enable communication between StarSQL and the DB2/MVS host, there must be an entry in this SYSIBM.SYSLUNAMES table. On DV2/MVS 5.1 (DB2 for OS/390), the name of this table is SYSIBM.LUNAMES.
The SYSIBM.SYSLUNAMES /SYSIBM.LUNAMES columns are:
|
LUNAMES |
This is the LUNAME of the remote system. An empty string means that any LU is valid for this row. |
|
SYSMODENAME |
This is the VTAM logon mode name used for DB2 for MVS/ESA intersystem conversations. A blank indicates that IBMDB2LM should be used. |
|
USERSECURITY |
This describes the network security acceptance options required of the remote system when the DB2 for MVS/ESA system acts as a server for the remote system (inbound security requirements). |
|
ENCRYPTPSWDS |
This indicates whether passwords exchanged with this partner are encrypted. |
|
MODESELECT |
If ‘Y’, the SYSMODESELECT table is used to obtain the mode name for each outbound distributed database request. If not ‘Y‘, the mode name IBMDB2LM is used for system-directed access requests, and the mode name IBMRDB is used for DRDA requests. |
|
USERNAMES |
This is the level of come-from checking and user ID translation required. It also specifies the security parameters this DB2 for MVS/ESA subsystem uses when requesting data from the remote partner (outbound security requirements).‘I‘ indicates an "inbound" ID is subject to translation. ‘O‘ indicates an "outbound" ID, sent to the corresponding LUNAME and subject to translation. ‘B’ indicates that both inbound and outbound IDs are subject to translation. A blank indicates no translation for inbound or outbound IDs. |
|
SECURITY_IN |
This column defines the security options that are accepted by this host when an SNA client connects. It is only in SYSIBM.LUNAMES, not SYSIBM.SYSLUNAMES. V for verify indicates that the incoming connection request must include a password. A for already verified indicates that the request does not require a password, although the password is checked if it is sent. This column is not used by StarSQL. |
|
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. It is only in SYSIBM.LUNAMES, not SYSIBM.SYSLUNAMES. A for already verified indicates that outbound connection requests contain an authorization id and no password. P for password indicates that outbound connection requests contain an authorization id and password. R for RACF PassTicket indicates that outbound connection requests contain a userid and RACF PassTicket. This column is not used by StarSQL. |
This command inserts a row that any LU can use. The value of the LUNAME column is an empty string:
INSERT INTO SYSIBM.SYSLUNAMES (LUNAME, SYSMODENAME, USERSECURITY, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES (' ',' ', 'C', 'N', 'N', '');
This command inserts a row for a specific LU named RLU4 :
INSERT INTO SYSIBM.SYSLUNAMES (LUNAME, SYSMODENAME, USERSECURITY, ENCRYPTPSWDS, MODESELECT, USERNAMES) VALUES ('RLU4', ' ', 'A', 'N', 'N', ' ');