Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to suppress retun code of partil DB2 unload utility

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Fri May 27, 2016 6:59 am    Post subject: How to suppress retun code of partil DB2 unload utility
Reply with quote

Hi All,
I'm getting return code 4 while using a partial DB2 unload. But return code while full unload.

Utility - IKJEFT01
Full unload
Code:

SELECT * from TABLE-NAME;


Partial Unload
Code:
SELECT Column1, CHAR('|'), Column3, CHAR('|'),Column7
     from TABLE-NAME.

I see an information message in the SYSPRINT,
Code:
DSNT506I INPUT STATEMENT WAS NOT A FULL SELECT ON A SINGLE TABLE. LOAD STATEMENT NEED MODIFICATION. 
But Its Quick Reference has the severity 4 (Warning).


Is there anyway I can suppress the return code to 0 in case of partial unload.
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri May 27, 2016 9:15 am    Post subject:
Reply with quote

No, and why should there be? DSNUTILB is warning you that your SELECT statement is sketchy, if not actually wrong, and that you may want to correct it?

What horrors do you expect to happen if the job ends with CC=4?
Back to top
View user's profile Send private message
Pandora-Box

Moderator


Joined: 07 Sep 2006
Posts: 1529
Location: Andromeda Galaxy

PostPosted: Fri May 27, 2016 5:50 pm    Post subject:
Reply with quote

IIRC DSNTIAUL returns you CC=4 always
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Fri May 27, 2016 6:10 pm    Post subject:
Reply with quote

It's doing you a favour by warning you that the LOAD control cards (see SYSPUNCH dd) that it generated will require modification before you can use them. It is normal, and if you don't intend to use the LOAD control cards, then just ignore the RC.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Fri May 27, 2016 9:27 pm    Post subject:
Reply with quote

May be you did not set up your Max RC to 4 and hence it's not acceptable to the scheduling and your whole stream is on hold. And now you want this job to give you 0 so that the rest application works fine. So if this is true ( of course because there is no harm having RC4) then you better change your scheduling and say 4 is also acceptable.
Look for IDCAMS and may add another step to set to 0 for the whole job but that not at all advised to do.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Sat May 28, 2016 4:03 am    Post subject:
Reply with quote

Quote:
Look for IDCAMS and may add another step to set to 0 for the whole job but that not at all advised to do


I am not sure what you are saying here, Rohit, but if you are saying execute IDCAMS to set the max cc for the job to 0 then I am surprised that you say this. IDCAMS can only affect the return code of its own execution - not other steps. If you need the last step of a job to be 0 then a simple IEFBR14 will do that.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Tue May 31, 2016 10:41 pm    Post subject:
Reply with quote

You are right Nic. I am unsure what I was trying to say then but yeah there is no way we could manipulate the RC of a step (except IDCAMS).
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 65
Location: India

PostPosted: Thu Jun 02, 2016 3:52 pm    Post subject:
Reply with quote

To Rohit and Mr. Clouston's post -
I guess, either way the RC of the 'job' (guessing this is via JCL, DB2 is something that I haven't had a chance to touch icon_sad.gif so am unsure if this process is running via JCL or not; though will definitely Google it - next thing) won't change to '0', even if last step or any other step for that matter, returns a value <= 4; please correct me if I'm wrong.

If the TS has z/OS 2.x then they can use JOBRC parameters coupled with IDCAMS/IEFBR14/or any program that sets the required RC.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Thu Jun 02, 2016 5:36 pm    Post subject:
Reply with quote

that's a Good reminder , it seems the only way is to use JOBRC but then TS may Need to adde a dummy step which gets RC 0 and then JOBRC cab be applied on it ; RC cannot be manipulated otherwise.
This is a part of zOS 1.13 enhancement though.
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 65
Location: India

PostPosted: Thu Jun 02, 2016 5:44 pm    Post subject:
Reply with quote

Aah right, it's 1.13; I'm getting old tad bit too soon icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm
This topic is locked: you cannot edit posts or make replies. Need to code a Rexx PGM sundaram.naveen CLIST & REXX 18 Thu Oct 06, 2016 6:45 pm
No new posts Need Help in understanding what is th... mainakdalal PL/I & Assembler 9 Mon Oct 03, 2016 8:03 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us