Have you configured the db2 client? You might also want to catalog the databases.
we have catalog the database, the db can connect from OS command line. but when we run the UBE, we get an error indicator credential not correct.
command line:
jde910@FSR3VAJSB1:/home/jde910>db2 connect to dwland user jdedbid using cf401fsr3
Database Connection Information
Database server = DB2/LINUXX8664 9.7.9
SQL authorization ID = JDEDBID
Local database alias = DWLAND
error:
11403496/1 MAIN_THREAD Thu Mar 17 10:06:34.281814 jdbodbc.c365
ODB0000163 - wSQLSetEnvAttr failure. rc=-2
11403496/1 MAIN_THREAD Thu Mar 17 10:06:34.281854 jdbodbc.c368
ODB0000002 - Warning: SQLSetEnvAttr(SQL_ATTR_CONNECTION_POOLING, SQL_CP_OFF) failed.
11403496/1 MAIN_THREAD Thu Mar 17 10:06:34.284747 jdbodbc.c1344
ODB0000163 - SQLDriverConnect failure. rc=-1
11403496/1 MAIN_THREAD Thu Mar 17 10:06:34.284797 jdbodbc.c1344
ODB0000164 - DBC:00 [ ][-1390][1] [IBM][CLI Driver] SQL10007N Message "0" could not be retrieved. Reason code: "3".
11403496/1 MAIN_THREAD Thu Mar 17 10:06:34.284843 jdbodbc.c1354
ODB0000010 - SQLDriverConnect failed. ODBC DSN: DWLAND.
11403496/1 MAIN_THREAD Thu Mar 17 10:06:34.284906 jdb_drvm.c798
JDB9900164 - Failed to connect to DWLAND