DB2 New server connection issues

[piyu]

All,

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)

I have gone through one another post and tried the option of un-cataloging and cataloging the connection again, and it still fails.

Any pointers/suggestions as to to what may be wrong will really be appreciated.

If any other detail is needed, please let me know.

[piyu]

This issue has been identified as a VAS issue where few connections are failing. The user id on old server was a local id where as on new server it is an Active Directory id.

Thank you.

[chulett]

VAS issue? For those of us who are not DB2 fluent, can you expand on that a little?

[chulett]

Thanks.