We are trying to migrate from an old server hosting the UDB database to a new one.
Jobs are using DB2 connectors. The same jobs were working perfectly when the old server was the norm.
-Every time there is more than one connection/stage referring to the new server in the same job(even both reads/selects), the job aborts issuing a error message that the username/password is incorrect.
-If a job has only one connection to this new server, it succeeds.
Code: Select all
Error :
db2TbProd,0: [IIS-CONN-DB2-000004] DB2 function SQLConnect failed: SQLSTATE = 08001: Native Error Code = -30082: Msg = [IBM][CLI Driver] SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001 (CC_DB2Connection::connect, file CC_DB2Connection.cpp, line 643)
Any pointers/suggestions as to to what may be wrong will really be appreciated.
If any other detail is needed, please let me know.