We are running data propagator on AIX 4.3.3 with UDB V7.2 fxpck8.

We are having a strange problem when running the apply program (pull configuration). We are pulling data from MVS.

Basically, the apply program starts successfully the first time in full refresh mode. All subscription sets complete successfully the first time in full refresh mode, then it starts a second time.
After a while, I can see that the apply hangs.
I have no error in the applytrail table, no error in the APPLYQUAL.TRC log file nor in APPLYQUAL.APP file.
The spill file xxxxxx.000 is not removed........

Here is the applytrail table :
--> db2 "select set_name, status, lastrun from asn.ibmsnap_applytrail order by lastrun"

SET_NAME STATUS LASTRUN
------------------ ------ --------------------------
SYM_CONTR_A954 0 2004-02-11-11.38.27.565714
SYM_CONTR_E1CVBAK 0 2004-02-11-11.38.36.017673
SYM_CONTR_E1CVBAP 0 2004-02-11-11.39.56.561033
SYM_KNVP 0 2004-02-11-12.01.03.319983
SYM_KONP 0 2004-02-11-12.01.19.195446
SYM_KOTG995 0 2004-02-11-12.56.32.347488
SYM_WSOP 0 2004-02-11-12.56.45.466136
SYM_A090 0 2004-02-11-13.01.19.414313
SYM_A962 0 2004-02-11-13.04.57.292801
SYM_A963 0 2004-02-11-13.05.07.560502
SYM_CONTR_A940 0 2004-02-11-13.05.17.232542
SYM_CONTR_A946 0 2004-02-11-13.05.35.750196
SYM_CONTR_A953 0 2004-02-11-13.08.46.605338
SYM_CONTR_A954 0 2004-02-11-13.34.55.348108
SYM_CONTR_E1CVBAK 0 2004-02-11-13.35.08.133724


Any idea of what is wrong ?

By the way, we are running exactly the same dprop on our test system without any problem, we have this problem only in production. The only difference between the 2 systems is the amount of data.

1) Check the directory where your apply program is running ... Are there any temp files .... I think they have extensions .001,.002 etc .. These are the files apply uses to build the insert statements for the target
2) Set the MAX_SYNCH_MINUTES in asn.ibmsnap_subs_set to a small value ...

3) Will it be possible to put a trace on in your apply program ?


HTH

Sathyaram

Thanks a lot for your answer.
There is only one spill file in the directory I launch the apply in. File name is APPLYQUAL.000 .
I changed the value of field MAX_SYNCH_MINUTES in table ASN.IBMSNAP_SUBS_SET to 5 (it previously was null), but it doesn't change anything.

I have plenty of space left on my disk, so it is not a space problem.

I just started the apply process again, and this time it did hang before completion of first subscription set. And again no error message in the log/trail table, the spill file remains blocked and nothing happens.

How can I put a trace ? The syntax I use is the following :
asnapply <APPLYQUAL> <db name> trcflow trcfile&

Any suggestion would be greatly appreciated.

How can I put a trace ? The syntax I use is the following :
asnapply <APPLYQUAL> <db name> trcflow trcfile&
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

asnapply <APPLYQUAL> <db name> trcflow trcfile > trace_file_name.trc &

I suggest you look at the Replication Guide and Reference or 'google' to find the syntax

Sathyaram