DSXchange

Hi,

I have my DB2 and Datastage installed on the same system. My DB2 server instance is db2inst8 and client instance db2inst5.

Now I am trying to connect to DB2 server through db2inst5 client instance(that is what my requirement is keeping in mind high availability stuff for DB2).

I have cataloged the required Database in db2inst5 instance and given db2inst5 the required privileges and
I am able to connect to the database using the following command through command line: -
db2 connect to <dbnamd> user db2inst8 using ******

I am mentioning the following parameters in the job where DB2/EE stage is my source : -

1) Client Instance name = db2inst5
2) Database = <db2name>
3) Password = *****
4) Server = db2inst8
5) Use default Database = No
6) Use default Server = No
7) User = db2inst8

I am getting the following error in view data as well as during runtime

DB2Driver Embedded SQL message: SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING").
SQLSTATE=08001

Are the server name and user name same?

Hi,

Probably... How do I check the DB2 server name?

Hi meet_deb85,

I think your problem is that you use the DB2 server instance in your stage - change it to the client instance!
You have successfully cataloged the database and this is enough for DB2 to know where the database is (including the instance).

Best regards
Michael

Hi,

I changed it...but still the problem persists

Have you executed the correct bind command on the DataStage server machine?

Yes I have, I have done each and everything written in the product documentation.

Anyway can you tell me the way to check if I have binded correctly or not?

Any solution to this problem?