469,299 Members | 2,073 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

Replication Connect Error

After laboring forever on ASNCLP connection scripts, build all the pieces of a replication process, I find that I am stuck on what seems to be a simple error.

I am to replicate from one Redhat linux box to a similarly configured linux box using DB2 v9.5. I am replicating from a database LXCARDS to the database LXDBCARD. The capture server is running fine against LXCARDS. The apply server starts and runs against LXDBCARD, but complains about not being able to connect to the capture database. I can canect to the capture database (LXCARDS) from the command line as the user under which ASNAPPLY is running. I have created a password file using ASNPWD with the proper dbalias/username/password, and start ASNAPPLY with the proper argument to point to password file.

The log from the ASNCAPTURE program is the startup banner of all of the configuration information, followed by the following lines repeating every few minutes:

2008-10-22-00.12.57.890793 <dbConnection::dbConnectCtx> ASN0530E "Apply" : "BKL" : "WorkerThread" : The program could not connect to databa
se "LXCARDS" with USERID "N/A" . The SQLCODE is "-30082".
2008-10-22-00.12.57.890897 <dbConnection::dbConnectCtx> ASN8013D "Apply" : "BKL" : "WorkerThread" : Error "2" from asnGetPwd for User "N/A"
on DB2 "LXCARDS" using password file "/opt/rccs/logs/BKL.aut".
2008-10-22-00.12.57.890926 <dbConnection::dbSwapCtx> ASN0589I "Apply" : "BKL" : "WorkerThread" The program received an unexpected return co
de "907" from routine "dbConnection::dbConnectCtx".
2008-10-22-00.12.57.890965 <process_set> ASN0589I "Apply" : "BKL" : "WorkerThread" The program received an unexpected return code "907" fro
m routine "dbSwapCtx".
2008-10-22-00.17.57.927964 <dbConnection::dbConnectCtx> ASN0552E "Apply" : "BKL" : "WorkerThread" : The program encountered an SQL error. T
he server name is "LXCARDS". The SQL request is "CONNECT". The table name is "N/A". The SQLCODE is "-30082". The SQLSTATE is "08001". The SQ
LERRMC is "". The SQLERRP is "SQLEXSMC".

HELP!!! The message guide for the above errors simply says, "fix the problem", with no assistance as what to fix.

Richard
Oct 28 '08 #1
0 2133

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by muldoon | last post: by
1 post views Thread by randi_clausen | last post: by
4 posts views Thread by Andi Plotsky | last post: by
15 posts views Thread by sat | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.