Problem viewing data in DB2/UDB Enterprise

yinyin61 · Post by **yinyin61** » Tue Mar 20, 2007 3:36 am

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:

>DB2 Driver Embedded SQL message: SQL30082N Attempt to establish connection failed with security reason "3"
>("PASSWORD MISSING"). SQLSTATE=08001
>;
>sqlcode = -30082;
>sqlstate = 08001

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?

aileen

yinyin61 · Post by **yinyin61** » Wed Mar 21, 2007 12:09 am

anyone?

Sreedhar · Post by **Sreedhar** » Wed Mar 21, 2007 12:39 am

It is evident with the error messages that the password is wrong.

following could be some of the scenarios for the same

You have given the correct password but for a different server name.

or

correct server name but the wrong password.

Please make sure that you are using both appropriate once.

yinyin61 · Post by **yinyin61** » Wed Mar 21, 2007 2:14 am

Sreedhar wrote:It is evident with the error messages that the password is wrong.

following could be some of the scenarios for the same

You have given the correct password but for a different server name.

or

correct server name but the wrong password.

Please make sure that you are using both appropriate once.

finally someone reply my post, thanks sreedhar

i'm very sure that i provide the correct server name and password.. i able to use it connect to database through IBM DB2 Control Center

Sreedhar · Post by **Sreedhar** » Wed Mar 21, 2007 2:25 am

if that is the case,

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.)

yinyin61 · Post by **yinyin61** » Wed Mar 21, 2007 8:53 pm

Sreedhar wrote:if that is the case,

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?

thanks ~~

us1aslam1us · Post by **us1aslam1us** » Wed Mar 21, 2007 10:54 pm

Hi chong, A search gave me this result :
viewtopic.php?t=105703&highlight=SQLSTATE%3D08001

IHTH
sam

yinyin61 · Post by **yinyin61** » Thu Mar 22, 2007 8:36 pm

us1aslam1us wrote:Hi chong, A search gave me this result :
viewtopic.php?t=105703&highlight=SQLSTATE%3D08001

IHTH
sam

Thanks for the link

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

ray.wurlod · Post by **ray.wurlod** » Fri Mar 23, 2007 4:27 am

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.

yinyin61 · Post by **yinyin61** » Fri Mar 23, 2007 9:05 am

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 · Post by **csrazdan** » Fri Mar 23, 2007 5:53 pm

Is this DB2 database clustered on multiple servers? If yes, have to set up SSH for your id?

Open a db2 session from your ETL server and see if you are able to connect with user name password from prompt.

my_stm · Post by **my_stm** » Mon Mar 26, 2007 4:21 am

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

any idea? did i missed out some configuration?

thanks