IBM DB2 Help

Supported versions

DB2 UDB 7.0 - 7.5 Limited support
DB2 UDB 8.x - 9.x
DB2 z/OS 7.x - 9.x
DB2 iSeries 5.x - 7.x
DB2 How To

Connecting to uncataloged DB2 databases

By default SqlDbx treats value in Server combo box as cataloged database alias.

To connect to uncataloged DB2 databases please follow steps below.

1. Specify Server as HOSTNAME:PORT or HOSTNAME

2. In Options add the name of the database: DATABASE=dbname

3. Specify port if it was not specified in Server combo box.

Example:

Server: db2server

Options: PORT=5023;DATABASE=dbname

* Make sure that option values separated by semicolon ";"