db2 9.4 fix 4, delay between call of procedure inside of a procedure?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kozy
    New Member
    • Jun 2009
    • 10

    db2 9.4 fix 4, delay between call of procedure inside of a procedure?

    Hello everyone,

    I have a problem with a procedure that is calling another procedure.

    Pasting some code:
    Code:
    INSERT INTO LOGGING.POTRDITEV_FAKTURE(A,B,C) VALUES(4, 'POTRDITEV_FAKTURE_DODATEK ZA FAKT_ID = '||TRIM(CHAR(NFAKT_ID)), CURRENT TIMESTAMP);
            CALL POTRDITEV_FAKTURE_DODATEK(NFAKT_ID, XPODR_ID, XVRDO_ID, XFAKT_FAKTURA, XTBLA_ID, XDELA_ID, XPART_ID, XPART_ID_KUPEC, XPATI_ID, XFAKT_FINSTFAKTURE);
    INSERT INTO LOGGING.POTRDITEV_FAKTURE(A,B,C) VALUES(5, 'VEZAPOSGFAKTVPRIPRAVI ZA FAKT_ID = '||TRIM(CHAR(NFAKT_ID)), CURRENT TIMESTAMP);
    The logs of both procedures show an interesting thing:
    Log of procedure 1 shows start time of call to procedure:
    20.4.2010 13:30:02.343000
    end time:
    20.4.2010 13:30:03.062000
    Procedure 2 shows it's start time:20.4.2010 13:30:02.468000
    end time:
    20.4.2010 13:30:02.484000

    I am wandering if there is a db parameter like (package size ) or anything that could help me minimize the time between call of procedure b inside of procedure a.

    Hope i made my question clear.

    I tryed with rebinding packages, did reorgs, runstats....

    thanks for any information you might share.

    LP
    Marko
Working...