Hello,
I am trying to compare 2 files based on a condition and listing out the records which matches. I used JOINKEYS
JOINKEYS FILES=F1,FIELDS=(322,4,A)
JOINKEYS FILES=F2,FIELDS=(1,4,A)
REFORMAT FIELDS=(F1:1,1016,F2:1,4,F2:98,2),FILL=X'FF'
OPTION COPY
OUTFIL FILES=01,INCLUDE=(7,4,CH,GE,X'0090700C',AND,7,4,CH,LE,
X'0091008C',
AND,(1021,2,CH,EQ,C'48',OR,1021,2,CH,EQ,C'33',OR,
1021,2,CH,EQ,C'27',OR,1021,2,CH,EQ,C'28',OR,
1021,2,CH,EQ,C'35',OR,1021,2,CH,EQ,C'38',OR,
1021,2,CH,EQ,C'41'),
AND,(218,2,CH,EQ,C'US',OR,666,2,CH,EQ,C'US',OR,
736,2,CH,EQ,C'US',OR,933,2,CH,EQ,C'US'))
But as the file has 45 million records ,getting error as
WER486A ERROR IN JNF1 PROCESSING
WER482I JNF1 STATISTICS
WER483B 1,032K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER483B 0 BYTES RESERVE REQUESTED, 988K BYTES USED
WER108I SORTJNF1 : RECFM=F ; LRECL= 1016; CISIZE = 4096
WER039A INSUFFICIENT VIRTUAL STORAGE
But the same above sort card is processing fine for smaller files.
I tried giving BUFNO values and sortwork as well. But nothing worked.
how can the virtual storage be increased?
Getting insufficient space - SYNCSORT
Moderators: Frank Yaeger, Moderator Group
-
- Member
- Posts: 25
- Joined: Tue Apr 28, 2009 10:53 pm
- Location: USA
- Contact:
uthami,
Please send me the complete job listing, including the JES Job Log, JCL and SYSOUT messages, and I would be happy to review it for you and make any necessary recommendations. You can forward that output as a text attachment to alissa.margulies@syncsort.com.
Regards,
Please send me the complete job listing, including the JES Job Log, JCL and SYSOUT messages, and I would be happy to review it for you and make any necessary recommendations. You can forward that output as a text attachment to alissa.margulies@syncsort.com.
Regards,
-
- Member
- Posts: 2
- Joined: Sat Mar 19, 2011 8:22 am
- Location: Philippines
-
- Moderator
- Posts: 1625
- Joined: Sat Aug 09, 2008 9:02 am
- Location: Mumbai, India
A high value of REGION won't guarantee a successful execution of the Job/step - you might need to consider the VSCORE and VSCORET in this specific case.
By the way, topic is just around 2 years old.
By the way, topic is just around 2 years old.
Last edited by Anuj Dhawan on Thu Aug 11, 2011 3:40 pm, edited 2 times in total.
Regards,
Anuj
Anuj
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
FYI, this Forum is actually for "DFSORT , ICETOOL & Utilities" questions, so it's the correct place for all sort utility questions.Also note, that while the topic is in the DFSORT part of the forum, the question relates to Syncsort.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
FREE TUTORIALS
Tutorials
Free tutorials from mainframegurukul
- JCL Tutorial
Covers all important JCL concepts. - Cobol Tutorial
This tutorials covers all Cobol Topics from STRING to COMP-3. - DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. - SORT Tutorial
This Tutorial covers all important aspects of DFSORT with examples - CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page