ds_loadlibrary: Win32 error in LoadLibrary of dsdb2.dll

[Jagan617]

Hi,

Can anyone help me on the below issue.

I am trying to view the data in designer with my individual userid through DB2 API stage, i am getting the below error
"ds_loadlibrary: Win32 error in LoadLibrary of dsdb2.dll - A dynamic link library (DLL) initialization routine failed" but when i tried to access with Admin id, i am able to. Could anyone help me. Even added my userid in DB2USERS group but not able to and it is throwing the above error.

[ArndW]

When you say user-id and admin-id you mean as the argument to the DB2 database stage or as the DataStage designer user?

[Jagan617]

Its designer user-id not the DB2 database stage. I am using Datastage 7.5.3 server edition on WIndows 2003.

[ArndW]

I would guess that your server and client are on the same machine and that the admin id has sufficient access rights to the DataStage directories while your user-id doesn't.