Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

PARASORT concerns.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: PARASORT concerns.
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    Post subject:
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    Post subject:
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    Post subject:
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

Moderator Team Head


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

PostPosted: Thu Dec 04, 2008 7:33 pm    Post subject: Reply to: PARASORT concerns.
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    Post subject:
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: 500
Location: USA

PostPosted: Thu Dec 04, 2008 10:18 pm    Post subject:
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: 500
Location: USA

PostPosted: Thu Dec 04, 2008 10:33 pm    Post subject:
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    Post subject: Reply to: PARASORT concerns.
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    Post subject:
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

Site Director


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

PostPosted: Thu Dec 11, 2008 11:46 pm    Post subject: Reply to: PARASORT concerns.
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Help needed on PARASORT kiran_nikam JCL & VSAM 10 Tue Aug 24, 2010 3:51 pm
No new posts Accepting Function keys in CLIST - co... jozef TSO/ISPF 5 Wed Apr 21, 2010 12:47 am
No new posts PARASORT utility in reducing the elap... Rajeev Saluja JCL & VSAM 1 Mon Mar 30, 2009 6:21 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us