Link to home
Start Free TrialLog in
Avatar of John
JohnFlag for United States of America

asked on

dprop target server USERID and password setup

i am setting up SQl replication on AIX server db2 v9.7.6.

I  am facing issue while i start the apply process. I have not used asnclp to setup any passwords. would like to know the procedure to configure the target server and set the password file.

error:

2012-12-27-09.57.27.650212 ASN1003E  APPLY "STG2PRD_QUAL" : "WorkerThread".  The Apply program could not connect to the server "ISASPROD".
2012-12-27-10.02.28.097412 ASN0552E  "Apply" : "STG2PRD_QUAL" : "WorkerThread" : The program encountered an SQL error. The server name is "ISASPROD". The SQL request is "CONNECT". The table name is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The SQLERRMC is "3ÿPASSWORD MISSINGÿ". The SQLERRP is "SQLEXSMC".
2012-12-27-10.02.28.098097 ASN0530E  "Apply" : "STG2PRD_QUAL" : "WorkerThread" : The program could not connect to database "ISASPROD" with USERID "N/A" .  The SQLCODE is "-30082".
2012-12-27-10.02.28.131438 ASN1003E  APPLY "STG2PRD_QUAL" : "WorkerThread".  The Apply program could not connect to the server "ISASPROD".

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of mustaccio
mustaccio
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial