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

D37 when running unload


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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

Moderator Emeritus


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

PostPosted: Mon Aug 06, 2012 1:26 am
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
Reply with quote

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

Superior Member


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

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

These are couple of links on similar topic:

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2.doc.ugref%2Funldxmp.htm
ibmmainframes.com/about53123.html
www.ibmmainframes.com/about53240.html
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
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

Moderator Emeritus


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

PostPosted: Wed Aug 08, 2012 11:27 pm
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
Reply with quote

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

Superior Member


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

PostPosted: Fri Aug 10, 2012 8:24 am
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

Moderator Emeritus


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

PostPosted: Fri Aug 10, 2012 8:34 am
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

Superior Member


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

PostPosted: Fri Aug 10, 2012 10:37 am
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: 1787
Location: Bloomington, IL

PostPosted: Fri Aug 10, 2012 3:07 pm
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

Superior Member


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

PostPosted: Fri Aug 10, 2012 4:04 pm
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

Global Moderator


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

PostPosted: Fri Aug 10, 2012 9:19 pm
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

Superior Member


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

PostPosted: Fri Aug 10, 2012 9:24 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts how to eliminate null indicator value... DB2 7
No new posts Unload and Load ISPF Table TSO/ISPF 4
No new posts Running REXX through JOB CLIST & REXX 13
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Remote Unload of CLOB Columns DB2 6
Search our Forums:

Back to Top