DB2 Connect User's Guide

Initial Connection is Not Successful

Review the following questions and ensure that the installation steps were followed.

1. Did the installation processing complete successfully?

   • Were all the prerequisite software products available?

   • Were the memory and disk space adequate?

   • Was remote client support installed?

   • Was the installation of the communications software completed without any error conditions?

2. For UNIX-based systems was an instance of the product created?

   • As root did you create a user and a group to become the instance owner and sysadm group?

3. If applicable, was the license information processed successfully?

   • For UNIX-based systems, did you edit the nodelock file and enter the password that IBM supplied?

4. Were the host or AS/400 database server and workstation communications configured properly?

   • There are three configurations that must be considered:

     1. The host or AS/400 database server configuration identifies the application requester to the server. The host or AS/400 server database management system will have system catalog entries that will define the requestor in terms of location, network protocol and security.

     2. The DB2 Connect workstation configuration defines the client population to the server and the host or AS/400 server to the client.

     3. The client workstation configuration must have the name of the workstation and the communications protocol defined.

   • Problem analysis for not making an initial connection includes verifying for SNA connections that all the LU (logical unit) and PU (physical unit) names are complete and correct, or verifying for TCP/IP connections that the correct port number and hostname have been specified.

   • Both the host or AS/400 server database administrator and the Network administrators have utilities available to diagnose problems.

5. Do you have the level of authority required by the host or AS/400 server database management system to use the host or AS/400 server database?

   • Consider the access authority of the user, rules for table qualifiers, the anticipated results.

6. If you attempt to use the command line processor to issue SQL statements against a host or AS/400 database server, are you unsuccessful?

   • Did you follow the procedure to bind the command line processor to the host or AS/400 database server?

[ DB2 List of Books | Search the DB2 Books ]