DB2 graphic  QMF Version 8

Connect using DRDA over SNA

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:

Symbolic destination name

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.

Note:
If you are selecting SNA connectivity for a database server, you must also specify the CPI-C DLL. You specify the CPI-C DLL using the Options window. Select Edit --> Options.

RDB name

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.

Table 12. RDB Names per Platform
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

ANSI client CCSID

Specify the codepage to use with the ANSI version of QMF for Windows. The default codepage is the Windows CCSID.

Unicode client CCSID

Specify the codepage to use with the Unicode version of QMF for Windows. The default codepage is UTF-8 (1208).

Enable load balancing

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.

Note:
Disregard this setting if installing QMF for Windows on AIX or Windows UDB DB2. It applies only to z/OS and VM/VSE data sharing.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004