hi, i had created a simple job that loads the records from DB2/UDB Enterprise to sequential file. however when i try to view the record in the DB2 stage, i'm getting the following error:
i had hardcoded all the parameter including the password but i still getting this error, really run out of idea.. anyone can help me resolve this issue?
make sure you have given these 5 parameters correctly
Client Instance name <DB2 iinstance name>
Database Name <DB2 server name>
Password <password>
server <datastage server name>
user <Datastage user name>
please note if there is any difference in user name and password for connecting to data base (we give only these 5 as the user name and password for both the data Stage and db2 are one and the same.)
make sure you have given these 5 parameters correctly
Client Instance name <DB2 iinstance name>
Database Name <DB2 server name>
Password <password>
server <datastage server name>
user <Datastage user name>
thanks for the prompt reply
May i know where can i find the Client Instance Name? what i did is i refer to the dsenv and inside has the value of DB2INSTANCE (which in my case is db2inst1). Is it correct?
And for server, i insert the same value as Client Instance Name which i'm not sure whether it's correct or not
here's the parameter that i enter:
Client Instance Name: db2inst1
Database: <DB2 Name>
Password: <DB2 password>
Server: db2inst1
Use Default Database : False
Use Default Server : False
User: <DB2 user id>
please note if there is any difference in user name and password for connecting to data base (we give only these 5 as the user name and password for both the data Stage and db2 are one and the same.)
erm... the user name and password for the db2 and DataStage is different for my case here. is two of them must be same for it to work?
i had search through the forum before i post up my problem here and i had tried the solution give by the link above as well.. however it's still not working
Have you checked the DB2 environment variables, such as DB2INSTANCE, to make sure these are correctly set for the user executing the DataStage job? They need to be set in the $DSHOME/dsenv script.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:Have you checked the DB2 environment variables, such as DB2INSTANCE, to make sure these are correctly set for the user executing the DataStage job? They need to be set in the $DSHOME/dsenv script. ...
i did check the dsenv file and the DB2INSTANCE already set there..
csrazdan wrote:Is this DB2 database clustered on multiple servers? If yes, have to set up SSH for your id?
nope, the DB2 database is not cluster on multiple servers.. mind explain more in SSH?
csrazdan wrote:Open a db2 session from your ETL server and see if you are able to connect with user name password from prompt.
i tried to open db2 session from ETL server, here's the error i get
XXXX003:dsadm:/home/dsadm> db2 connect to SAMPLE
SQL30082N Attempt to establish connection failed with security reason "3"
("PASSWORD MISSING"). SQLSTATE=08001