Connect.IT DB2 connector on AIX

[mks50]

Has anyone used the ConnectIt DB2 connector on AIX ? I have a scenario developed under CIT 3.6.0 which utilises a DB2 connector (DB2 8.2). When I try to open the connectors i get the following message form the DB2 connector :

ODBC error: [IBM][CLI Driver] SQL1013N The database alias name or database name "SCDEV03" could not be found.
SQLSTATE =42705 SQLSTate: 08001 ODBC: Unable to connect to database 'SCDEV03' (UserId='cituser')
Unable to connect to this database engine.
Unable to open the 'DB2 Database ( on SCDEV03)' connector.
Connecting to ServiceCenter server '12670'...

The DB2cli.ini file is set up correctly as far as I can see, i.e. there is an entry for the SCDEV03 database in the ini file. Do I need to configure ODBC on the AIX box as well ??

thanks in advance

[johnsonri]

Have you tested the odbc data source with the DB2 Administration client? It sounds like a configuration problem with the data source.

[mks50]

The connector actually uses a native DB2 connection, so the ODBC error is a little bit misleading.

I have actually found the problem - basically the db2 environment for the connectit AIX user was not configured correctly. The database I was trying to connect to was on Instance2 of 3 possible instances on the server. I found the connectit user was able to access any db in instance 1 but not the others. The db on the instance i needed to connect to had to be cataloged for the connectit user. The DB2 command is below, where <NODE_NAME> is a name of your choice (the other params should be self-explanatory!!) :



db2 catalog tcpip node <NODE_NAME> remote <SOURCE_DB_Server_IP> server <SOURCE_DB_port>



db2 catalog db <SOURCE_DB_Alias> at node <NODE_NAME>