View previous topic :: View next topic
|
Author |
Message |
kishore1012
New User
Joined: 26 Jan 2010 Posts: 3 Location: bangalore
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
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 |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Increase primary and secondary space... |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
Back to top |
|
|
kishore1012
New User
Joined: 26 Jan 2010 Posts: 3 Location: bangalore
|
|
|
|
Hi,
Thanks for the reply.We used IBM Cross loader utility to unload/Load table. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
Does this mean the problem is solved? |
|
Back to top |
|
|
kishore1012
New User
Joined: 26 Jan 2010 Posts: 3 Location: bangalore
|
|
|
|
yes |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
See Dick, you asked for a "Yes/No" kinda question and the result is apparent! (pun intended) |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hi Anuj,
Your avatar has left the building . . .
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
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... |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1787 Location: Bloomington, IL
|
|
|
|
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 ) 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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
I've not used Cross Loader, so I'd believe that your budget for the next month will still be under control!
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! |
|
Back to top |
|
|
Pedro
Global Moderator
Joined: 01 Sep 2006 Posts: 2593 Location: Silicon Valley
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
That make sense, Pedro. Thanks for your in sight in to this, appreciate it. |
|
Back to top |
|
|
|