View previous topic :: View next topic
|
Author |
Message |
Manoj Bhaskaran
New User
Joined: 20 Nov 2014 Posts: 1 Location: India
|
|
|
|
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 |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Can you post the complete error log? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
|