JDE connect to db2 data source in AIX platform


I have JDE 9.1 enterprise server running on AIX 7.1 need access to db2 database on linux, and i have installed the db2 runtime client on AIX server, but donot know how to configure the odbc conection on AIX server, does someone could give me a hint on this, thanks.


does JDE use db2 cli driver to access db2 database?

i configured db2cli.ini, i tested below command, i got a return shows that fetch record successfuly. but when i run UBE JDE says connection still failed.

echo "select * from LAND.CMF where isn=1" | db2cli execsql -dsn TCVLAND


Yes, i have catalog the node and database in db2 client. but still not able to connect db2 data source.

do i need install ODBC driver manager and configure ODBC on AIX in order to JDE connect db2 data source?


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:
[email protected]:/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

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