ISSUE WITH - NOTE: The PROCEDURE SORT used XXXX CPU seconds and XXXXK.

[kumarsandip975]

Hi Everyone,

We have mainframe jobs which runs monthly and have some proc sort part in program.
Sysout ID        Jobname     Jobid            Arch Date       Time

xxxxxx             xxxxxxxx    xxxxxxxx    03/10/2023    20:54

xxxxxx             xxxxxxxx    xxxxxxxx    04/09/2023    20:04

Upon investigating, found the below mentioned PROC SORT step executed long time this month,

Current month run:
---------------------------

MPRINT(txxxx):   proc sort data=xxx.abcd ;                      

MPRINT(xxxxx):   by var1 var2 ;                                          

MPRINT(xxxxx):   run ;                                                    

NOTE: There were 9953 observations read from the data set xxx.abcd.

NOTE: The data set xxx.abcd has 9953 observations and 26 variables.

NOTE: The PROCEDURE SORT used 2168.65 CPU seconds and 30027K.    

This sort step processing less than 10K records and the same sort step executed in 0.02 CPU Seconds in the previous month run.

Previous month run:
---------------------------

MPRINT(xxxxx):   proc sort data=xxx.abcd;                      

MPRINT(xxxxx):   by var1 var2 ;                                          

MPRINT(xxxxx):   run ;                                                    

NOTE: There were 9834 observations read from the data set xxx.abcd.

NOTE: The data set xxx.abcd has 9834 observations and 26 variables.

NOTE: The PROCEDURE SORT used 0.02 CPU seconds and 30027K.        

Could you please suggest reason for these issues, how can we troubleshoot. 

[SASKiwi · Accepted solution]

What about the rest of your job? Are there other PROC SORTs in your code? Did they run slowly too? What about other program steps - were any of those slower than normal? I seem to recall that doing host sorts is an option on mainframes. It could be your program was doing a host sort when it was extremely busy with other sorting jobs. If this is just a one-off occurence I wouldn't be too concerned.