Select this option to specify that QMF for Windows will connect to the database server using a DRDA over SNA connection.
SNA connectivity is not provided with QMF for Windows; instead, a third-party product that implements SNA connectivity is required. Whatever product you use to provide connectivity must be installed, configured and working before you install or use QMF for Windows Administrator.
In an SNA network, QMF for Windows must establish an LU 6.2 session between itself and DB2 using a CPI-C or WinCPIC interface. The ease in which LU 6.2 implements connectivity between Microsoft Windows and DB2 depends on your SNA network environment and its stability. Use your networking staff and the vendor's technical support team to implement and support your network configuration.
Because QMF for Windows implements the DRDA requestor specification, it is capable of connecting to any database that adheres to and implements the DRDA server component.
The following IBM database products that contain a DRDA server component can communicate directly with QMF for Windows via SNA:
Use this field to specify the CPI-C or WINCPIC symbolic destination name that is defined in your SNA networking software.
The symbolic destination name refers to a set of parameters (the CPI-C side information record), which are used when establishing a connection to a partner application (such as DB2) over the network.
Type the name of the relational database (RDB) server that you are configuring in the SDF. The RDB name is not visible to end-users.
Platform | RDB name |
---|---|
DB2 z/OS, OS390, and MVS | Location name |
DB2 Universal Database or DB2 Common Server | Database name |
iSeries | Database name in the iSeries Relational Database Directory |
If you do not know what value to enter, run the following query at the server (you can use any table if SYSIBM.SYSTABLES does not exist):
SELECT DISTINCT CURRENT SERVER FROM SYSIBM.SYSTABLES
The returned value is the RDB name for the database server.
The RDB name is the name of the database that is taken from the iSeries Relational Database Directory Entry. Type the following command to locate the RDB name:
DSPRDBDIRE
Specify the codepage to use with the ANSI version of QMF for Windows. The default codepage is the Windows CCSID.
Specify the codepage to use with the Unicode version of QMF for Windows. The default codepage is UTF-8 (1208).
Check this check box to use load balancing to maintain a balanced connection to the database server.
In DB2, load balancing distributes processing and communications activity evenly across a network so that no single device is overwhelmed. Load balancing is frequently used for networks where it is difficult to predict the number of requests that will be issued to a server.
QMF for Windows supports DB2 database servers that use load balancing. By checking Enable load balancing for DB2 database servers that supports load balancing, QMF for Windows will receive a list of network addresses that can be used as alternatives after the initial connection to the DB2 database server is made. Subsequent connections can use one of the addresses returned by DB2. These addresses are not necessarily the same address that is configured in the SDF, but they will connect to the same set of database tables.
If you enable load balancing, and the DB2 supports this feature, QMF for Windows receives a list of IP addresses with rankings as to how often it wants to be connected to each address. QMF for Windows takes this list and goes to a specific IP address for its first connection. Next, it will go to the next address, then to the third address, and so on. If an IP address is busy or not working, load balancing will go to another address. This balances the load on each address and provides multiple addresses if the first address cannot be used.