Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


Testing the ODBC connectivity for db2 using dblist fails with error "db_connect_user: Cannot connect to service with uid"
Problem Description

When testing the ODBC connectivity for DB2 using dblist, the following error occurs:

>dblist -c -dodb:99:test1/pass1@IIRtest
Maximum connections per module: 1024
Linked databases: sdb: odb:
dblist> database 'odb:99:test1/@IIRtest' open failed -91009009
dblist> ErrorLog: [030114122   1] dblist  > It is now 20091030114122
dblist> ErrorLog: [030114122   1] dblist.c     1660 rc  12   91009009*100
dblist> ErrorLog: [030114122   1] dbldr.c      1088 rc   9    1091009*1000
dblist> ErrorLog: [030114122   1] dbops.c      1756 rc   9      10910*100
dblist> ErrorLog: [030114122   1] ssaodbc.c    4116 rc  10        109*100
dblist> ErrorLog: [030114122   1] ssadb8_db_opn failed
dblist> ErrorLog: [030114122   1] ssaodbc.c    3789 rc   9          1*100
dblist> ErrorLog: [030114122   1] db_connect_user: Cannot connect to service 'IIRtest' with uid 'test1'
dblist> ErrorLog: [030114122   1] ssaodbc.c    1181 rc   1
dblist> ErrorLog: [030114122   1] ssa_odbc_connect: Error allocating ODBC env handle

This issue can occur if the ODBC drivers for DB2 are not installed.
To resolve this issue, ensure that the ODBC drivers for DB2 are installed and the directory location of the DB2 ODBC drivers and its dependent libraries are provided within the PATH environment variable. The UNIX ODBC driver for DB2 is called 'db2', this is the ODBC driver provided by IBM.
More Information
Applies To
Product: Identity Resolution
Problem Type:
User Type:
Project Phase:
Product Version: Identity Resolution 2.8.05
Operating System:
Other Software:

Last Modified Date:2/1/2010 3:59 AMID:109697
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)