Solved

dprop target server USERID and password setup

Posted on 2012-12-27
1
1,130 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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 tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

895 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

14 Experts available now in Live!

Get 1:1 Help Now