DSXchange

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,

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.

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.

Thanks Brad.