Solved

dprop target server USERID and password setup

Posted on 2012-12-27
1
1,119 Views
Last Modified: 2012-12-28
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

0
Comment
Question by:jmartin_v
1 Comment
 
LVL 8

Accepted Solution

by:
mustaccio earned 500 total points
ID: 38724081
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now