Problem DB2 Enterprise stage

[meet_deb85]

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

[nayanpatra]

Are the server name and user name same?

[meet_deb85]

Hi,

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

[MT]

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

[meet_deb85]

Hi,

I changed it...but still the problem persists

[ray.wurlod]

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

[meet_deb85]

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?

[sjfearnside]

Any solution to this problem?