Connecting to DB2

Follow this procedure for connecting to a DB2 database when you do not have an ODBC Datasource defined for it.

To connect to a DB2 database you need to specify:

• the machine where the DB2 server resides
• the TCP/IP Port the DB2 server is listening on. DB2 for LUW uses a default of 50000 but your server may be configured to use a different port. If in doubt, contact your DB2 specialist for this.
• a DB2 server can host a number of databases. Specify the name of database you wish to connect to.

The connection to the database may be defined to your DB2 Client as an Alias. If so, you can just specify the alias name. AQT cannot give you a dropdown list of these.

There info on how to define an Alias to your DB2 Client at Configuring the DB2 Client.