I need help please!!! i'm working on a DS CLIENT with PARALLEL, on UNIXserver with DB2 7.2.I create a job as follow :
seqfile ---> transformer --> db2 stage.
the first time i run a job i retrive an error message like this : Requirements failure. the file db2nodes.cfg must exist and be readable by all users.
Then, the db2 admin have put this file in the sqllib directory MANUALLY... (0 SERVERNAME 0). Idon't know db2 partitionanament, but i think that is not the right way to do this...
now i have this problem:
DB2_2.DSLink4,0: DB2 Error: 'ERROR during execution of DB2-CLI requests'.
SQL_ERROR; SQLSTATE = 08004; NativeErrorCode = -1403
[IBM][CLI Driver] SQL1403N The username and/or password supplied is incorrect. SQLSTATE=08004
the user\pwd are exact(db2svil\db2svil) and i put them in the connection property of the db2 stage. i put in the database property the db name(ASCDB2SE) but i don't exactly know what have i put in the CLIENT INSTANCE NAME property... i try with db2svil(the username) but i obtain the same error.
if you know something please help me.
im sorry for my bad english...
P.S.
someone knows if parallel extender could works with db2 if db2 is not partitioned????
Connection problems with parallel and db2 7.2
Moderators: chulett, rschirm, roy
thanks for the answer.
whit par server is all ok. how can i try without partitioning?
under MAnager/Tools/Configuration i can choose between parallelextendconfig and default, i have to choose default to work without partitions???
in that file there is the node config of ds right???
p.s.
is it possible that my client connect ds server whit db2svil\db2svil and the ds server try to connect with db2 whit dsadm\dsadm?? in fact i obtain a new fatal error ,i ve changed user and pwd in db2 stage property connection whit dsadm\dsadm, i try to write some records in a table that i created under db2svil\db2svil and the response is :
DB2_2.DSLink4: DB2 Error: 'ERROR during execution of DB2-CLI requests'.
SQL_ERROR; SQLSTATE = 42S02; NativeErrorCode = -204
[IBM][CLI Driver][DB2/6000] SQL0204N "DSADM.CONTRATTIMARCO" is an undefined name. SQLSTATE=42704
whit par server is all ok. how can i try without partitioning?
under MAnager/Tools/Configuration i can choose between parallelextendconfig and default, i have to choose default to work without partitions???
in that file there is the node config of ds right???
p.s.
is it possible that my client connect ds server whit db2svil\db2svil and the ds server try to connect with db2 whit dsadm\dsadm?? in fact i obtain a new fatal error ,i ve changed user and pwd in db2 stage property connection whit dsadm\dsadm, i try to write some records in a table that i created under db2svil\db2svil and the response is :
DB2_2.DSLink4: DB2 Error: 'ERROR during execution of DB2-CLI requests'.
SQL_ERROR; SQLSTATE = 42S02; NativeErrorCode = -204
[IBM][CLI Driver][DB2/6000] SQL0204N "DSADM.CONTRATTIMARCO" is an undefined name. SQLSTATE=42704