IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

PARASORT concerns.


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
fazilbe

New User


Joined: 03 Dec 2008
Posts: 25
Location: INDIA

PostPosted: Thu Dec 04, 2008 3:43 pm
Reply with quote

I have a sort job which runs for more than 10 hours everymonth. Found the input of the sort job has been written to tape and used MAXSORT to reduce the run time. But still it runs for more than 10 hours. I heard about PARASORT which can be used for a tape sort input having data in mutiple volumes. Can someone provide me an example JCL with parasort utility being used.

We are using SYNCSORT RELEASE 1.3 version.
Back to top
View user's profile Send private message
fazilbe

New User


Joined: 03 Dec 2008
Posts: 25
Location: INDIA

PostPosted: Thu Dec 04, 2008 4:05 pm
Reply with quote

Hay thank you..

I guess we cannot bring it to DASD because of the huge data content. The sortin file holds more than 300 million record and if we try to being it to DASD, i think that will lead to DASD violation defined here.

MAXSORT has been used in that particular job. But it still runs for longer time. I thought PARASORT might be the best possible option available. Please help me out tuning this job. Thank you very much.
Back to top
View user's profile Send private message
fazilbe

New User


Joined: 03 Dec 2008
Posts: 25
Location: INDIA

PostPosted: Thu Dec 04, 2008 4:27 pm
Reply with quote

Below is the JCL i found in GOOGLE and used it. But its not working. Seems like some estoric names needed to be defined for the SORTPAR1-4 . I don't know what it is...


//JS010 EXEC PGM=SORT,
// PARM='PARASORT,NOEQUALS'
//SORTIN DD DSN=TEMP
// DISP=SHR
//SORTPAR1 DD DSN=*.SORTIN,DISP=SHR,UNIT=AFF=SORTIN
//SORTPAR2 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),UNIT=
// (TAPE,,DEFER),VOL=PRIVATE
//SORTPAR3 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),UNIT=
// (TAPE,,DEFER),VOL=PRIVATE
//SORTPAR4 DD DSN=*.SORTIN,DISP=(,KEEP,KEEP),UNIT=
// (TAPE,,DEFER),VOL=PRIVATE
//SORTOUT DD DSN=TEMP2,
// VOL=(,,,99),
// DISP=(NEW,CATLG,CATLG),
// UNIT=&UNIT2,
// LABEL=RETPD=&RETPD1
Back to top
View user's profile Send private message
fazilbe

New User


Joined: 03 Dec 2008
Posts: 25
Location: INDIA

PostPosted: Thu Dec 04, 2008 6:00 pm
Reply with quote

below is the sysout message...


WER276B SYSDIAG= 308279, 2451773, 2451773, 5627986
WER164B 18,436K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 504K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=FB ; LRECL= 660; BLKSIZE= 32340
WER110I SORTOUT : RECFM=FB ; LRECL= 660; BLKSIZE= 32340
WER453A FOR PARASORT SORTPAR2-4 UNITS CANNOT BE THE SAME AS THE SORTIN UNIT
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Thu Dec 04, 2008 7:33 pm
Reply with quote

While we wait on a response to this, I was wondering if you've already read this note from another similar topic:

Alissa Margulies wrote:
Bill Dennis wrote:
It's still reading one tape at a time.
While this is true for a standard sort, PARASORT allows you to read more than one at a time. PARASORT is fully documented in Chapter 10 of the SyncSort for z/OS Programmer's Guide.
Back to top
View user's profile Send private message
fazilbe

New User


Joined: 03 Dec 2008
Posts: 25
Location: INDIA

PostPosted: Thu Dec 04, 2008 8:26 pm
Reply with quote

I don't have the manual. icon_sad.gif . Searching for one to learn about parasort. Please do pass on if you have one. Thank you very much.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 496
Location: USA

PostPosted: Thu Dec 04, 2008 10:18 pm
Reply with quote

fazilbe wrote:
I don't have the manual. icon_sad.gif . Searching for one to learn about parasort. Please do pass on if you have one. Thank you very much.

Hello Fazilbe.

Email me at alissa.margulies@syncsort.com and I can assist you with acquiring electronic copies of the manuals. I can also help you resolve the Parasort errors and tune your application.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 496
Location: USA

PostPosted: Thu Dec 04, 2008 10:33 pm
Reply with quote

Fazil,

I have just been informed by one of my colleagues that you have already opened a ticket with SyncSort Support for this issue. I do not feel that pursuing this in the forums is beneficial at this time. I suggest that you continue to work with your SyncSort Support Representative on this matter. Thank you.
Back to top
View user's profile Send private message
fazilbe

New User


Joined: 03 Dec 2008
Posts: 25
Location: INDIA

PostPosted: Fri Dec 05, 2008 2:52 pm
Reply with quote

Alissa,

You are absolutely correct. I had a chance to communicate with one of your colleague and i i am working with my team to provide the informations he soughted from me. Thanks for your help on this issue.

Also i thank everybody who replied for my queries. I will post the solution for the parasort issue once i solve it with the help of SYNCSORT guys.
Back to top
View user's profile Send private message
fazilbe

New User


Joined: 03 Dec 2008
Posts: 25
Location: INDIA

PostPosted: Thu Dec 11, 2008 9:39 pm
Reply with quote

Guys i got the parasort working great time. It reduced my job run time by close to 20% in the initial testing. Please find the example parasort jcl below. Thanks for all your help.

Also the ESOTERIC name which i was talking about also depends upon the system and enviroment one works with. Thanks a lot SYNCSORT for solving this for me.

//JS010 EXEC PGM=SORT,
// PARM='PARASORT,NOEQUALS'
//SORTIN DD DSN=TEMP1,
// DISP=SHR
//SORTPAR1 DD DSN=*.SORTIN,DISP=OLD,UNIT=AFF=SORTIN
//SORTPAR2 DD DSN=*.SORTIN,
// DISP=(NEW,KEEP,KEEP),UNIT=(CART,,DEFER),VOL=PRIVATE
//SORTPAR3 DD DSN=*.SORTIN,
// DISP=(NEW,KEEP,KEEP),UNIT=(CART,,DEFER),VOL=PRIVATE
//SORTPAR4 DD DSN=*.SORTIN,
// DISP=(NEW,KEEP,KEEP),UNIT=(CART,,DEFER),VOL=PRIVATE
//SORTOUT DD DSN=TEMP2,
// VOL=(,,,99),
// DISP=(NEW,CATLG,CATLG),
// UNIT=CART
//SYSIN DD *
SORT FIELDS=(1,123,A),FORMAT=BI
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Dec 11, 2008 11:46 pm
Reply with quote

Good to hear you have a solution - thank you for letting us know icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Help needed on PARASORT JCL & VSAM 10
No new posts Accepting Function keys in CLIST - co... TSO/ISPF 5
No new posts PARASORT utility in reducing the elap... JCL & VSAM 1
Search our Forums:

Back to Top