View previous topic :: View next topic
|
Author |
Message |
Rambhupal.chaudari
New User
Joined: 30 Mar 2007 Posts: 25 Location: Hyderabad
|
|
|
|
I want to sort one file which is on tape, with a record length of 5700. This file is having nearly 30 million records. I've used the below jcl.
Code: |
//PS010 EXEC PGM=SYNCSORT,PARM='MAXSORT,MINWSP=600,DYNATAPE'
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=xxx.XUNLD.TST.CNTLREC.JUL23,DISP=SHR
//SORTOUT DD DSN=yyyy.ALLPERS.ASCNDNG.OUTPUT.JUL23P2,
// DISP=(,CATLG,DELETE),
// UNIT=(CART36,,DEFER),
// LABEL=EXPDT=99000,VOL=(,,,99),
// DCB=(B0.DSCB)
//SORTWK01 DD SPACE=(CYL,(700,700),RLSE),UNIT=WORK
like this i gave 20 work files.
|
i want to sort the input file based on some key condition.
Error which i got in sysout is
SYSIN :
SORT FIELDS=(27,22,CH,A)
WER131I PARM FIELD ERROR - MINWSP=6
WER164B 21,716K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 2M BYTES USED
WER317I MAXSORT OPTION SELECTED
WER300A SORTBKPT DD STATEMENT REQUIRED |
|
Back to top |
|
|
karthikr44
Active User
Joined: 25 Aug 2007 Posts: 235 Location: Chennai
|
|
|
|
Hi,
In MAXSORT there is no PARM like MINWSP.
Only MINWKSP exists.
Code: |
MINWKSP:
This option specifies the minimum amount of disk SORTWK space that MAXSORT can
use. If the MINWKSP value exceeds the primary allocation and sufficient secondary allocation
cannot be obtained to meet the MINWKSP value at the time of execution, the sort terminates.
It can be restarted later when more space is available.
The MINWKSP value may be specified as a decimal number of cylinders (n) or a decimal
number of megabytes (nM) of work space.
The default MINWKSP value is 500 cylinders.
If MINWKSP is specified as n cylinders, MAXSORT will convert the specification to an
actual byte value. MAXSORT will multiply by n the capacity of a cylinder on the disk allocated
to the lowest-numbered SORTWKnn DD statement.
Note: MINWKSP should be specified as less than or equal to MAXWKSP, if specified.
|
Regards
R KARTHIK |
|
Back to top |
|
|
Rambhupal.chaudari
New User
Joined: 30 Mar 2007 Posts: 25 Location: Hyderabad
|
|
|
|
hi,
thanks karthik.. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
I suspect that not all 5700 bytes of all 30million records is needed in this new sequence.
If you do a bit of work and reduce the volume of data to be sorted by both limiting the set of records and/or the fields selected from them, your sort will be much more easily accommodated by the system. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Trying to read your post without code bbtags is a pain. what was somewhat obvious:
Quote: |
WER300A SORTBKPT DD STATEMENT REQUIRED
|
either you need this, or you have entered somuch crap in your control cards that syncsort thinks it needs this dd statement.
Have you even bothered to read about syncsorts' hypersort?
That is a major selling point to this product.
I can not believe that you need 20 sortwk statements for this. Alissa will be along in a while and save your butt.
I would suggest doing some reading about the product.
Can't believe there is not something inhouse for a large sort.
And learn to use bbcode: ibmmainframes.com/faq.php?mode=bbcode |
|
Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 Location: Germany
|
|
|
|
Hi !
Normaly, you don't have to bother about SortWorkAreas, because of the
DynamicAllocation of these Areas, if Syncsort is propper installed.
Plse read more about the following in the SortDocumentation. These Parameters will give more space to Sort when sorting huge files.
//STEP50 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//*
//$ORTPARM DD DSN=J120830.PARMKA.SORTOSP7(SORTPARM),
// DISP=SHR
Content of SORTPARM:
VSCORE=5M
VSCORET=30M |
|
Back to top |
|
|
Rambhupal.chaudari
New User
Joined: 30 Mar 2007 Posts: 25 Location: Hyderabad
|
|
|
|
Hi Umey..
Can u please provide any example how to use the parms VSCORE=5M and VSCORET=30M.
Or it may also helpful if you provide any link related to this..
thanks in advance.. |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
UmeySan did provide you with an example.
The $ORTPARM DD is the statement to be added to your JCL and VSCORE=5M and VSCORET=30M are the parameters needed
Code: |
//$ORTPARM DD *
VSCORE=5M
VSCORET=30M
/* |
Gerry |
|
Back to top |
|
|
Rambhupal.chaudari
New User
Joined: 30 Mar 2007 Posts: 25 Location: Hyderabad
|
|
|
|
Hi Umey..
Can u please provide any example how to use the parms VSCORE=5M and VSCORET=30M.
Or it may also helpful if you provide any link related to this..
thanks in advance.. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Do you not have access to the documentation at your shop ? |
|
Back to top |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006 Posts: 771 Location: Germany
|
|
|
|
@Rambhupal.chaudari !
As gcicchet said: This is the example.
Also plse read more in the dokumentation of syncsort or also search the web for these keywords. |
|
Back to top |
|
|
|