IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to suppress retun code of partil DB2 unload utility


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 1788
Location: Bloomington, IL

PostPosted: Fri May 27, 2016 9:15 am
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

Global Moderator


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

PostPosted: Fri May 27, 2016 5:50 pm
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: 765
Location: Whitby, ON, Canada

PostPosted: Fri May 27, 2016 6:10 pm
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

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Fri May 27, 2016 9:27 pm
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: 2455
Location: Hampshire, UK

PostPosted: Sat May 28, 2016 4:03 am
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

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Tue May 31, 2016 10:41 pm
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: 88
Location: India

PostPosted: Thu Jun 02, 2016 3:52 pm
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

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Thu Jun 02, 2016 5:36 pm
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: 88
Location: India

PostPosted: Thu Jun 02, 2016 5:44 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts Remote Unload of CLOB Columns DB2 6
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top