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" : "WorkerThre ad" : 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" : "WorkerThre ad" : 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" : "WorkerThre ad" 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" : "WorkerThre ad" The program received an unexpected return code "907" fro
m routine "dbSwapCtx" .
2008-10-22-00.17.57.927964 <dbConnection:: dbConnectCtx> ASN0552E "Apply" : "BKL" : "WorkerThre ad" : 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
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" : "WorkerThre ad" : 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" : "WorkerThre ad" : 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" : "WorkerThre ad" 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" : "WorkerThre ad" The program received an unexpected return code "907" fro
m routine "dbSwapCtx" .
2008-10-22-00.17.57.927964 <dbConnection:: dbConnectCtx> ASN0552E "Apply" : "BKL" : "WorkerThre ad" : 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