Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SPANNED loads for XML/LOB columns

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

New User


Joined: 20 Nov 2014
Posts: 1
Location: India

PostPosted: Thu Jan 01, 2015 9:26 pm    Post subject: SPANNED loads for XML/LOB columns
Reply with quote

Hello, has anyone used the SPANNED load feature in DB2 V10 for loading LOB or XML columns?
I am able to use a spanned unload as input if the record count is less, but for large record counts (>500000), the job abends with an SA78. Has anyone else faced this problem? I have coded a REGION=0M on the job, but still does not work.
Back to top
View user's profile Send private message

gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Jan 02, 2015 9:41 pm    Post subject: Reply to: SPANNED loads for XML/LOB columns
Reply with quote

Can you post the complete error log?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8400
Location: Dubuque, Iowa, USA

PostPosted: Sat Jan 03, 2015 4:27 am    Post subject:
Reply with quote

Quote:
I have coded a REGION=0M on the job, but still does not work.
Depending upon your site and how it has been set up, coding REGION=0M on a JOB or EXEC statement may -- or may not -- have any impact at all. From the JCL Reference manual:
Quote:
Two installation exits, IEFUSI and IEALIMIT, can also affect the size of the user address space assigned to the job step.
These exits, which are customized by site, can limit REGION=0M.
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 Query for fetching matching data in t... Poha Eater DB2 10 Mon Jul 09, 2018 6:06 pm
No new posts help to replace columns by rows Vikas Maharnawar DFSORT/ICETOOL 8 Tue Mar 06, 2018 3:27 pm
No new posts Can EDCICONV convert EBCDIC to ASCII... natt.sut IBM Tools 3 Fri Nov 17, 2017 8:46 pm
No new posts Copy selected columns from 2 input fi... Poha Eater DFSORT/ICETOOL 3 Thu Nov 02, 2017 3:43 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us