Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    France
    Posts
    2

    Arrow Unanswered: DB2 DProp - Apply program hangs

    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.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: DB2 DProp - Apply program hangs

    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2004
    Location
    France
    Posts
    2

    Red face

    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.

  4. #4
    Join Date
    Nov 2003
    Location
    New York
    Posts
    14
    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 &

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I suggest you look at the Replication Guide and Reference or 'google' to find the syntax

    Sathyaram

    Originally posted by Sophie Hsiao
    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 &
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •