IBM SQL Replication Apply on target not working

shekardb2dba · #1 (**permalink**) 09-10-11, 23:24

Hi All,

We use IBM SQL Replication. Both source and target are on Mainframes.Capture is working fine for us but Apply is failing with the below error and nothing is happening on Apply side.

2011-09-08-06.05.10.194348 ASN1053E APPLY "QUAL01" : "WorkerThread". The execution of the ASNLOAD exit routine failed. The returncode is "98"

Can somebody help me in this regard.

Marcus_A · #2 (**permalink**) 09-10-11, 23:39

Did you check the manual to see what ASN1053E with returncode 98 is?

shekardb2dba · #3 (**permalink**) 09-11-11, 22:33

I did check the messages ,I am quite new to the SQL Replication and I am not able to understand what needs to be done to fix the problem.

ASN1053E APPLY apply_qualifier. The execution of the ASNLOAD exit routine failed. The return code is return_code.

Explanation: The ASNLOAD exit routine detected an error and passed the error information back to the Apply program. The following values are valid return codes:

98 An unexpected error has occurred (The ASNLOAD exit routine has failed with an unexpected error. No processing will be performed.)

Marcus_A · #4 (**permalink**) 09-12-11, 00:52

Did you check any of the ANSLOAD message files? If that doesn't help, I would contact IBM support.

przytula_guy · #5 (**permalink**) 09-12-11, 02:04

although there are message guides
ASN1053E
I don't understand that companies let there db maintain by people that do no know db2 at all. or don't want to pay a consultant to resolve their problems. As for that reason I don't supply any answers anymore, just a link where people should read and try to understand what is going on.