Troubleshooting Guide

Troubleshooting Host Connections

When solving problems with host communications, you must first isolate the communications layer to see if it is working. Use the following list of questions as a starting point.

Can you establish a session with a host?

[  ]

Can you establish LU sessions with DB2 servers?

[  ]

Are the communication products installed and operational? (An SQL30081N message indicates that lower level communication is failing.)

[  ]

Have there been any changes made to your communication network that have invalidated the SNA profiles or the DB2 directory entries?

Were the host and workstation communications configured correctly?

[  ]

If SNA is used and an initial connection is not made, are all of the LU (logical unit) and PU (physical unit) names complete and correct?

[  ]

For APPC communication, is there a link and a session established? (See APPC Problems.)

[  ]

For TCP/IP communication, are the host name and server name correct? (See TCP/IP Problems.)

[  ]

For a DB2 Connect Enterprise Edition gateway, does the host configuration identify the application requester to the gateway? The host database management system has system catalog entries that will define the requestor in terms of location, network protocol, and security.

[  ]

For a DB2 Connect Enterprise Edition gateway, does the configuration define the client population to the server and the server host to the client.

[  ]

For DB2 Connect, does the client workstation configuration define the name of the workstation and the communication protocol? (The registry value DB2COMM should include APPC, TCPIP, or both, depending on which protocols you are using.)

Administration of host databases can be done using the Control Center interface. Check the help that is part of the Control Center for information on the requirements for this type of administration and for possible problems you may encounter.

If you determine that a link and session are established and you still experience problems, see the other chapters in this guide to troubleshoot your DB2 clients and servers.

[ DB2 List of Books | Search the DB2 Books ]