Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    8

    Unanswered: LOAD_SCRIPT and deletion of log files

    Gents, I have a strange (to me anyway) issue.

    I have a job (JOB A) that calls a number of different jobs. One of these called jobs (JOB B) has the following step:

    #================================================= ================
    # STEP 05. Load into staging table
    #================================================= ================
    STEP
    . ${LOAD_SCRIPT}
    ENDSTEP

    ...the LOAD_SCRIPT is this: LOAD_SCRIPT=${WFM_BIN}/bulkload_${TABLENAME}_ld.ksh

    ...so, as you can see these simply load data via db2 load commands. In JOB B i use this: LOAD_ERR=${EDR_LOG}/${JOBNAME}_load_errors.log to capture DB2 messages. The issue is, i can delete the logs upon successful completion by putting in a rm -f command in JOB A...but, why cant i put this rm in JOB B instead?- I would like the JOB B which creates the logs to also be the job that removes them. If i do, it does not remove the logs...it only removes the logs when JOB A has the rm command. I thought maybe the LOAD_SCRIPT has a hold on the logs but i would think the ENDSTEP should be releasing it. Of course the rm command is at the very bottom of JOB B.

    Thanks
    B

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by yzinger View Post
    Gents
    There are a few ladies here as well...

  3. #3
    Join Date
    Mar 2013
    Posts
    8
    ahha, apologies.

Posting Permissions

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