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,
DB2 enterprise stage connectivity
Moderators: chulett, rschirm, roy
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.
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.
It is not that I am addicted to coffee, it's just that I need it to survive.