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
 

 

Sort performance

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
sijayapal

New User


Joined: 23 Dec 2008
Posts: 69
Location: India

PostPosted: Wed Aug 26, 2009 8:55 pm    Post subject: Sort performance
Reply with quote

Hi,

I have a sort card

SORT FIELDS=(12,9,CH,A,21,9,CH,A),DYNALLOC=(SYSDA,80)
.

The size of the input record is 104229006.
This takes 55 minutes of elapsed time and 7 minutes of cpu time.

Is there any possibilty to improve the performance..?
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Aug 26, 2009 9:41 pm    Post subject:
Reply with quote

Please add the following to the job to show diagnostic messages:

//SORTDIAG DD DUMMY

Rerun the job and send the complete JES output to the DFSORT Performance Team Lead, Dave Betten (betten@us.ibm.com) and ask him to help you tune the job.
Back to top
View user's profile Send private message
sijayapal

New User


Joined: 23 Dec 2008
Posts: 69
Location: India

PostPosted: Thu Aug 27, 2009 5:04 pm    Post subject:
Reply with quote

I ran the job with SORTDIAG.
this is the report. If anybody can help me tune this i will be grateful icon_smile.gif

SYNCSORT FOR Z/OS 1.2.2.1R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCSO
* * z/OS 1.9.0
PRODUCT LICENSED FOR CPU SERIAL NUMBER xxxxx, MODEL 2097 709 LICEN
SYSIN :
SORT FIELDS=(12,9,CH,A,21,9,CH,A),DYNALLOC=(SYSDA,80)
WER276B SYSDIAG= 876458, 3352180, 3352180, 2991026
WER164B 102,408K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 102,404K BYTES USED
WER108I SORTIN : RECFM=FB ; LRECL= 500; BLKSIZE= 27500
WER110I SORTOUT : RECFM=FB ; LRECL= 500; BLKSIZE= 27500
WER410B 101,380K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
WER410B 0 BYTES RESERVE REQUESTED, 101,380K BYTES USED
WER036B G=93830,B=113,BIAS=06
WER162B 0 PREALLOCATED SORTWORK TRACKS, 82,500 DYNAMICALLY ALLOCATED,
WER162B 36,000 ACQUIRED IN 12 SECONDARY EXTENTS, 7,515 RELEASED, TOTAL OF 1
WER045C END SORT PHASE
WER418I DATASPACE(S) AND/OR HIPERSPACE(S) USED
WER209B 27,928 PRIMARY AND 80,451 SECONDARY SORTOUT TRACKS ALLOCATED, 106,583
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
WER416B SORTIN : EXCP'S=126,UNIT=3390,DEV=1301,CHP=(B0B1B2B3B4B5B6B7,2),VOL=
WER416B SORTOUT : EXCP'S=409,UNIT=3390,DEV=35B3,CHP=(D0D1D2D3D4D5D6D7,2),VOL=
WER416B SORTWK01 : EXCP'S=135,UNIT=3390,DEV=2442,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB
WER416B SORTWK02 : EXCP'S=11,UNIT=3390,DEV=1214,CHP=B0B1B2B3B4B5B6B7,VOL=TPU27
WER416B SORTWK03 : EXCP'S=5,UNIT=3390,DEV=2440,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB52
WER416B SORTWK04 : EXCP'S=10,UNIT=3390,DEV=2444,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB5
WER416B SORTWK05 : EXCP'S=14,UNIT=3390,DEV=2441,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB5
WER416B SORTWK06 : EXCP'S=23,UNIT=3390,DEV=2600,CHP=C0C1C2C3C4C5C6C7,VOL=TPU27
WER416B SORTWK07 : EXCP'S=7,UNIT=3390,DEV=2443,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB55
WER416B SORTWK08 : EXCP'S=1,UNIT=3390,DEV=243E,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB50
WER416B SORTWK09 : EXCP'S=22,UNIT=3390,DEV=243F,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB5
WER416B SORTWK10 : EXCP'S=7,UNIT=3390,DEV=2445,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB57
WER416B SORTWK11 : EXCP'S=18,UNIT=3390,DEV=243F,CHP=C0C1C2C3C4C5C6C7,VOL=TPUB5
WER416B TOTAL OF 253 EXCP'S ISSUED FOR SORTWORKS
WER416B TOTAL OF 788 EXCP'S ISSUED FOR SORTING
WER246I FILESIZE 5,862,042,000 BYTES
WER054I RCD IN 11724084, OUT 11724084
WER072I EQUALS IN EFFECT
WER169I RELEASE 1.2 BATCH 0460 TPF LEVEL 2.1
WER052I END SYNCSORT - TSOSIJA1,R050,,DIAG=C400,DB53,E81B,BD75,9DF7,68EB,2F08,

**licensing information edited to protect company information** -Alissa
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Thu Aug 27, 2009 5:39 pm    Post subject:
Reply with quote

This is SYNCSORT not DFSORT. Topic moved to correct forum.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu Aug 27, 2009 8:05 pm    Post subject:
Reply with quote

Hello Sija.

Please add the following statements to the sort step in question:

//$ORTPARM DD *
MSG=AP,LIST,BMSG,GMSG

This should produce some additional diagnostic messages. Feel free to email me offline at alissa.margulies@syncsort.com with the complete and unedited joblog as a text attachment and I would be happy to further assist you.
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 Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts SORT to append Month and YEAR in MMYY... tisamf DFSORT/ICETOOL 1 Wed Mar 08, 2017 4:46 pm
No new posts JCL sort Match and NoMatch rakeshsekar1987 SYNCSORT 2 Thu Feb 02, 2017 10:26 pm


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