DB2 enterprise stage connectivity

[dsusersaj]

I am trying to access a database named sitdb which is installed at instance
/db2home/db2inst8.

I am able to login to this database from unix using db2 connect command.

In my job I tried a couple of things to achive the connection.

DB2INSTANCE was set to /db2home/db2inst8
client instance was set to db2inst8.

when I try to view the data, it gives the following error

"SQL30082N Security processing failed with reason "3" ("PASSWORD MISSING").
>SQLSTATE=08001"


I am giving the same user name and password that is used to login through unix which sucessfully logs me into the database.

I have a basic question here. What is the difference between DB2INSTANCE and the client instance ?.

In this case what should these both be set to?.

Thanks,

[bcarlson]

How is your database setup? Is it on the same server as DataStage or is it remote? In our environemnt, the DB2 database is on a separate server and we connect remotely. The ETL server has a client instance.

Brad.

[bcarlson]

I'll assume you are connecting remotely, as that will work whether your data is local or remote.

DB2INSTANCE is not a directory location, it is the name of the local databsae instance. It should already be set to db2inst8. The client_instance parameter shoudl point to the instance that is local to our ETL server. The server instance is the name of the instance on the remote server.

When doing a remote connection, set Use Default Database to False, and set Use Default Server to False.

Brad.

[dsusersaj]

Thanks Brad.