Troubleshooting database connection problems

This topic lists known database connection problems and solutions.
Related concepts
Overview of database connections
Related tasks
Connecting to a database by using a wizard
Related reference
Connection Parameters page
Filter page
New or Existing Connection page

A connection that was created in a previous version of the workbench is not working in this version

When you migrate to the current version of the workbench, you might have to edit database connections that you created by using previous versions of the workbench. This might happen because support for specific JDBC drivers and database vendors has changed. To fix this problem, edit the database connection to use one of the supported JDBC drivers.

To edit a database connection:
  • Right-click a database connection in the Database Explorer, and click Edit Connection.
  • Edit connection properties by using the New Database Connection wizard.

A connection appears to be active but is not

If a database connection is canceled from outside of the workbench (for example, in DB2® by using the FORCE APPLICATIONS ALL command), the workbench cannot detect that the connection is dropped.

Some tasks you perform in this product require a live connection to the database. Any task that requires an active connection to the database (such as running an SQL statement in the SQL query builder) will not work properly if the connection is dropped. If a connection appears to be active in the workbench but is not active, first try to disconnect from the database and then reconnect.

If the connection is still not active, then follow these steps:
  1. Disconnect from the database.
  2. Restart the database server.
  3. Reconnect to the database.

If the database connection is still not active, then shut down the workbench and restart it.

Connection to the database server fails

If the connection to the database server fails, you might receive an error message similar to this one: IWAS0126E Problems encountered while trying to establish connection &1. Reason: '&2'. For more information about the reason code (&2), refer to the documentation that comes with your database server.

Problems connecting to Cloudscape 5.1

If you connect and disconnect from a Cloudscape™ 5.1 database multiple times, tables might display without columns in the Database Explorer. If this problem occurs, restart the workbench.

Problems connecting to DB2 for iSeries V5R1

On Linux®, the workbench might shut down abnormally when you connect to DB2 for iSeries™ V5R1 by using the AS/400® Toolbox for Java™ JDBC Driver. The problem occurs when you enter an incorrect password or leave the password field blank. If this problem occurs, restart the workbench and connect again using the correct password.

Note: On iSeries systems, logical files are not shown in the Project Explorer. Use the Operations Navigator view to work with logical files.

The application requester cannot establish the connection

For DB2 for iSeries, the Toolbox JDBC driver uses the system name, user ID, and password provided in the call to DriverManager.getConnection() to establish a connection to the iSeries database. If any of these values are not provided, the Toolbox JDBC driver displays a sign-on prompt. If the Toolbox JDBC driver cannot sign on to the system for any reason, you will see this message: The application requester cannot establish the connection. Here is a list of potential causes for this error:
  • The system name is incorrect. Ping the specified system name to verify the name. If the ping fails, then there is a TCP/IP configuration problem between your client and the server.
  • The user ID or password is incorrect.
  • The iSeries database host server is not started. To start the host server, run the following command on a CL command line: STRHOSTSVR *DATABASE

    You can verify that the iSeries database host server is running by running the NETSTAT *CNN command. When the Work with TCP/IP Connection Status screen is displayed, look for the as-database entry under the Local Port heading and ensure that the entry is in Listen status.


Feedback