Author Topic: Loads Failing through ARSLOADP but manual loads through job submission working  (Read 28 times)

htees

  • Jr. Member
  • **
  • Posts: 16
    • View Profile
Hi folks, we are periodically having load failures when an output file contains LARGE  AFP documents(hundreds of pages) and said file is processed automatically through ARSLOADP.

2020-05-15 00:07:17.914289: ARS1412E The document size of >2285875577< bytes exceeds the maximum size allowed of >2147483647< bytes.
 2020-05-15 00:07:17.914849: ARS1146I Loaded 2561 rows into the database
 2020-05-15 00:07:17.915274: ARS4311E Loading failed
 2020-05-15 00:08:23.509692: ARS4320I Unloading started
 2020-05-15 00:08:25.176608: ARS4321I Unloading of data was successful


I understand that the message states we are exceeding a 'maximum size', but yet we can load the file MANUALLY by creating a batch load through SAR (CA product) and resubmitting the output to the SAME sysout class ARSLOADP is using.

Thoughts on why the Initial load through ARSLOADP fails?  Are there PARMS that need to be looked at?
What are the maximum sizes of a load allowed?

ZOS - 4.26
CMOD  - 10.1.0.5
Large Object support is used

Thanks for any help offered.  HT



 
Harold Thomas
Developer Advisor, Anthem BC/BS

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 1859
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
A 2.2GB *document* is crazy.    That's over 432,000 letter-sized pages of text.

I see two solutions... 

1)  You'll need to improve the indexing to break this document down into smaller documents.

2)  You'll probably have to send the file in several pieces as well.

As for why it's successful manually...  Are you sure the entire document is getting loaded, and that it's not getting truncated silently? 

The limitation is related to the 32-bit address space - it can only calculate the size/offset of a document up to the 2GB mark.  After that, it overflows and your data gets corrupted.

-JD.
#Install, #Educate, #Repair, #Upgrade, #Migrate, #Enhance, #Optimize.

IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SA #Performance #Security #Audits #Customizing #Availability #HA #DR #Training