MVSFORUMS.com

mfjin · Beginner Joined: 26 Apr 2003 Posts: 94 Topics: 17

Guys

has anyone of you tried this performance booster? I decided to give it a try after a sas job ran for ever. And I did not find any performance
improvement. A sort with 5000000 observations in the job took 25 cpu secs without the option and 27.13 cpu secs after adding the SORTBLKMODE option. Am I missing something?

kolusu · Posted: Fri Aug 27, 2004 8:03 am Post subject:

Mfjin,

I think you also need SORTANOM=512 which enables SAS support for block-mode sorting. If it is already set to 512 at your site, then may be can try some of the options suggested here.

http://v9doc.sas.com/cgi-bin/sasdoc/cgigdoc?file=../hosto390.hlp/a000217305.htm

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

mfjin · Beginner Joined: 26 Apr 2003 Posts: 94 Topics: 17

kolusu,

how would I know what the SORTANOM option is set at my site???
The dfsort system options displayed in the sysout of sort jobs does not
show this option.

cheers...

kolusu · Posted: Fri Aug 27, 2004 9:01 am Post subject:

Mfjin,

For the installed defaults and override parms, you can look up in DDNAME associated to CONFIG in the SAS JCL.

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu