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
 

 

D37 when running unload

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

New User


Joined: 26 Jan 2010
Posts: 3
Location: bangalore

PostPosted: Sun Aug 05, 2012 11:01 pm    Post subject:
Reply with quote

i am trying to unload the LOB Table.I got sd37.The data from pega is more than 32k.Can you help me how to unload the table with more than 32k using unload jcl.The db2 version is 9.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 06, 2012 1:26 am    Post subject:
Reply with quote

Hello and welcome to the forum,

Please do not post a reply to some topic that has nothng to do with your question.

Yes, the original topic mentioned LOB but your issue is that you ran out of space in the unload file. The diagnostic output of the job tells you which dataset needs more space.
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Mon Aug 06, 2012 1:31 pm    Post subject:
Reply with quote

Increase primary and secondary space...
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Aug 06, 2012 3:05 pm    Post subject:
Reply with quote

These are couple of links on similar topic:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2.doc.ugref%2Funldxmp.htm
http://ibmmainframes.com/about53123.html
http://www.ibmmainframes.com/about53240.html
http://ibmmainframes.com/about46305.html

On the other hand -- with the info you've provided, if you got SD37, the best bet would be to increase the SPACE in the output-file-in-question, as Dick also indicates.
Back to top
View user's profile Send private message
kishore1012

New User


Joined: 26 Jan 2010
Posts: 3
Location: bangalore

PostPosted: Wed Aug 08, 2012 10:30 pm    Post subject:
Reply with quote

Hi,
Thanks for the reply.We used IBM Cross loader utility to unload/Load table.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Aug 08, 2012 11:27 pm    Post subject:
Reply with quote

Hello,

Does this mean the problem is solved?
Back to top
View user's profile Send private message
kishore1012

New User


Joined: 26 Jan 2010
Posts: 3
Location: bangalore

PostPosted: Thu Aug 09, 2012 11:01 pm    Post subject:
Reply with quote

yes
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Aug 10, 2012 8:24 am    Post subject:
Reply with quote

See Dick, you asked for a "Yes/No" kinda question and the result is apparent! icon_biggrin.gif (pun intended)
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 10, 2012 8:34 am    Post subject: Reply to: D37 when running unload
Reply with quote

Hi Anuj,

Your avatar has left the building . . . icon_smile.gif

Quote:
you asked for a "Yes/No" kinda question and the result is apparent!
Yup, if the reply had been no, i'd have had more to post . . .

d
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Aug 10, 2012 10:37 am    Post subject:
Reply with quote

Yeah, I had been playing with my Avatar these days and at times it just don't follow the Forum Rules, one way or other.

Actually, I was expecting a little more explanatory answer from TS. SD37 is irrespective of utility in use, such as the previous answer from TS was "We used IBM Cross loader utility to unload/Load table" - but this does not directly address SD37. However, if the latest answer is "yes", I'm happy too... icon_wink.gif
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


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

PostPosted: Fri Aug 10, 2012 3:07 pm    Post subject:
Reply with quote

Anuj Dhawan wrote:
SD37 is irrespective of utility in use, such as the previous answer from TS was "We used IBM Cross loader utility to unload/Load table" - but this does not directly address SD37.

True. However I will be willing to wager a non-trivial sum next month (at the moment I'm paying off a mortgage, so my cash flow is already dedicated icon_biggrin.gif ) that the JCL running Cross Loader, at least, is a "canned" one with a different allocation for output (note that the querent never bothered to tell us what the IEC031I message from the failing job was).
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Aug 10, 2012 4:04 pm    Post subject:
Reply with quote

I've not used Cross Loader, so I'd believe that your budget for the next month will still be under control! icon_smile.gif

OTOH, too optimistic you're getting, I think, Akatsukami. Had the querent knew that IEC031I lies somewhere in the log, the thread would not have existed, to start with, no! icon_wink.gif
Back to top
View user's profile Send private message
Pedro

Senior Member


Joined: 01 Sep 2006
Posts: 2019
Location: Silicon Valley

PostPosted: Fri Aug 10, 2012 9:19 pm    Post subject: Reply to: D37 when running unload
Reply with quote

Quote:
SD37 is irrespective of utility in use, such as the previous answer from TS was "We used IBM Cross loader utility to unload/Load table" - but this does not directly address SD37


The initial post asked about D37 during unload. The initial post did not mention that the unload file would be used for loading a table somewhere else.

You can use the cross loader to accomplish the same thing, without the need for an unload file. From the utilities manual:
Quote:
The LOAD utility can directly load the output of a dynamic SQL SELECT statement into a table. The dynamic SQL statement can be executed on data at a local server or at any remote server that complies with DRDA.

Since an unload file is not used, D37 is no longer an issue.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Aug 10, 2012 9:24 pm    Post subject:
Reply with quote

That make sense, Pedro. Thanks for your in sight in to this, appreciate it.
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 Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm
No new posts DXT unload utility - DVRE0000 mistah kurtz DB2 1 Thu Jul 07, 2016 4:56 pm
No new posts Syntax for running batch history repo... polymathtarun CA Products 1 Tue Jun 21, 2016 1:51 pm


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