General Question: Why abend in between DB2 utilities ?

Bala

General Question: Why abend in between DB2 utilities ?
Dear List,

I have looked at DB2 weekly/daily/monthly jobs that 'calls' the abort
routine when the RC of the DB2 utility is unacceptable. Is there a special
reason why this is being done ? On the scheduler acceptable code would have
been set as 0 or <=4 and along with JCL COND parameter, the job could be
forced to stop right after Utility error.

Thanks in advance.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Michael Ebert

Re: General Question: Why abend in between DB2 utilities ?
(in response to Bala)
I'm not sure what "the abort routine" is. I had a step like this at the
end of my SAS-generated maintenance JCL:

// IF RC>0 THEN
// EXEC PGM=MYABEND
// ENDIF

Previous job steps were e.g. a series of ICOPY steps. If any of these
failed, I didn't want the whole job to fail, so I followed each image copy
step with a cleanup step (TERM UTIL) that got executed only if the
preceding RC was higher than 4/8, OR if it abended (which does NOT result
in an RC). The cleanup step (a REXX) always had a high RC. At the end of
the job, I had the above step, where MYABEND is a NON-existing program.
This step would thus result in an abend IF any of the preceding steps had
a non-zero (in some cases, >4) RC, which due to the TERMUT step also was
the case if there was an abend. The whole job had a SYSOUT class that got
saved ONLY if there was an abend. The main point of this was that I didn't
have to wade through dozens or hundreds of working jobs to find the one
that had a failing step in it...

Dr. Michael Ebert
DB2 & Oracle Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




DB2DBAzOS <[login to unmask email]>
To
[login to unmask email]
cc

bcc

Subject
[DB2-L] General Question: Why abend in between DB2 utilities ?





DB2DBAzOS <[login to unmask email]>
Please respond to : IDUG DB2-L <[login to unmask email]>
Sent by: IDUG DB2-L <[login to unmask email]>
23-11-09 08:19


Dear List,

I have looked at DB2 weekly/daily/monthly jobs that 'calls' the abort
routine when the RC of the DB2 utility is unacceptable. Is there a special
reason why this is being done ? On the scheduler acceptable code would
have been set as 0 or <=4 and along with JCL COND parameter, the job could
be forced to stop right after Utility error.

Thanks in advance.




IMPORTANT - CONFIDENTIALITY NOTICE - This e-mail is intended only for
the use of the individual or entity shown above as addressees. It may
contain information which is privileged, confidential or otherwise
protected from disclosure under applicable laws. If the reader of this
transmission is not the intended recipient, you are hereby notified that
any dissemination, printing, distribution, copying, disclosure or the
taking of any action in reliance on the contents of this information is
strictly prohibited. If you have received this transmission in error,
please immediately notify us by reply e-mail or using the address below
and delete the message and any attachments from your system.

Amadeus Data Processing GmbH
Geschäftsführer: Eberhard Haag
Sitz der Gesellschaft: Erding
HR München 48 199
Berghamer Strasse 6
85435 Erding
Germany

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User Groups,
there is probably one near you!
Regional User Groups are your local connection to the Worldwide DB2 User Community
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L

Bala

Re: General Question: Why abend in between DB2 utilities ?
(in response to Michael Ebert)
Hi Michael,

Thanks for the response with ideas. But, the 'abort' (just abend) I am
talking about does nothing other than sending an abend code. So, I was
thinking if there could be a reason, the return code or the abend code
from DSNUTILB be unacceptable to stop the job.

On 11/23/09, Michael Ebert <[login to unmask email]> wrote:
> I'm not sure what "the abort routine" is. I had a step like this at the
> end of my SAS-generated maintenance JCL:
>
> // IF RC>0 THEN
> // EXEC PGM=MYABEND
> // ENDIF
>
> Previous job steps were e.g. a series of ICOPY steps. If any of these
> failed, I didn't want the whole job to fail, so I followed each image copy
> step with a cleanup step (TERM UTIL) that got executed only if the
> preceding RC was higher than 4/8, OR if it abended (which does NOT result
> in an RC). The cleanup step (a REXX) always had a high RC. At the end of
> the job, I had the above step, where MYABEND is a NON-existing program.
> This step would thus result in an abend IF any of the preceding steps had
> a non-zero (in some cases, >4) RC, which due to the TERMUT step also was
> the case if there was an abend. The whole job had a SYSOUT class that got
> saved ONLY if there was an abend. The main point of this was that I didn't
> have to wade through dozens or hundreds of working jobs to find the one
> that had a failing step in it...
>
> Dr. Michael Ebert
> DB2 & Oracle Database Administrator
> aMaDEUS Data Processing
> Erding / Munich, Germany
>
>
>
>
> DB2DBAzOS <[login to unmask email]>
> To
> [login to unmask email]
> cc
>
> bcc
>
> Subject
> [DB2-L] General Question: Why abend in between DB2 utilities ?
>
>
>
>
>
> DB2DBAzOS <[login to unmask email]>
> Please respond to : IDUG DB2-L <[login to unmask email]>
> Sent by: IDUG DB2-L <[login to unmask email]>
> 23-11-09 08:19
>
>
> Dear List,
>
> I have looked at DB2 weekly/daily/monthly jobs that 'calls' the abort
> routine when the RC of the DB2 utility is unacceptable. Is there a special
> reason why this is being done ? On the scheduler acceptable code would
> have been set as 0 or <=4 and along with JCL COND parameter, the job could
> be forced to stop right after Utility error.
>
> Thanks in advance.
>
>
>
>
> IMPORTANT - CONFIDENTIALITY NOTICE - This e-mail is intended only for
> the use of the individual or entity shown above as addressees. It may
> contain information which is privileged, confidential or otherwise
> protected from disclosure under applicable laws. If the reader of this
> transmission is not the intended recipient, you are hereby notified that
> any dissemination, printing, distribution, copying, disclosure or the
> taking of any action in reliance on the contents of this information is
> strictly prohibited. If you have received this transmission in error,
> please immediately notify us by reply e-mail or using the address below
> and delete the message and any attachments from your system.
>
> Amadeus Data Processing GmbH
> Geschäftsführer: Eberhard Haag
> Sitz der Gesellschaft: Erding
> HR München 48 199
> Berghamer Strasse 6
> 85435 Erding
> Germany
>
> _____________________________________________________________________
>
> * IDUG North America * Tampa, Florida, * May 10-14 2010 *
> http://IDUG.ORG/NA *
> _____________________________________________________________________
>
> http://www.idug.org/rug/index.html - with almost 150 IDUG Regional User
> Groups,
> there is probably one near you!
> Regional User Groups are your local connection to the Worldwide DB2 User
> Community
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
> the home of IDUG's DB2-L

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.IDUG.org membership is now free.
Do you have people in your office who are not an IDUG member?
Show them how to access the information and help train the next generation of DB2 Users!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L