I am finelly upgrading our old systems 7.1 for version 8.2 and later versions. We have the software, Sys Admin setup the AIX 5.3 box etc ...but I still have some old system running DB2 v7.1 and AIX 4.3.
On one of those systems, I have a heavy replication environment tha is giving me a hard time.
Couple subscrptions (6 out of 400) are giving an error:
db2owner@elmer2:/workspace/dprop:>cat DB2OWNER.APP
2007-11-05-14:26:50 ASN1045I: The Apply program was started using database FACACTIV.
2007-11-05-14:29:46 ASN1053E: The execution of the ASNLOAD program failed. The return code is 99.
2007-11-05-14:29:47 ASN1048E: The execution of an Apply cycle failed. See the Apply trail table for full details: APPLY_QUAL=DB2OWNER, SET_NAME=FAC_059, SOURCE_SERVER=FACILITY, TARGET_SERVER=FACACTIV, TARGET_OWNER=DB2OWNER, TARGET_TABLE=EDI_BELL_IN_LINE, .
2007-11-05-14:30:32 ASN1044I: The Apply program will become inactive for 2 minutes and 17 seconds.
-----------
Checking Data Replication guide for error, tells me NOTHING...there is no problem with PSWD file since all other subscriptions work fine.
Checking the apply_trail table also doesn't tell anything new:
ASN1053E: The execution of the ASNLOAD program failed. The return code is 99.
----
What could be wrong with those tables/subscriptions?
Thanks for ANY help...I'm really desperate