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^® operating 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 operating systems, did you edit the nodelock file and enter the password that IBM^® supplied?

4. Were the host or System i™ database server and workstation communications configured properly?

   • There are three configurations that must be considered:

     1. The host or System i database server configuration identifies the application requester to the server. The host or System i 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 System i 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 that 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 System i 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 System i server database management system to use the host or System i 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 (CLP) to issue SQL statements against a host or System i database server, are you unsuccessful?

   • Did you follow the procedure to bind the CLP to the host or System i database server?

Parent topic: Troubleshooting