We have 5 SAR instances for which i would like to query / report on the following
Our current limit is 1 million lines
How can i get a list of reports in all 5 SAR instances that have over 900,000 lines ?
We recently found a weekly report that was being captured by SAR with 35 million lines
of course, after 1 million lines we see
SARSTC23 Maximum lines exceeded, archival terminated
Release : 14.0
Component : View
You can use SARGRW Report Writer to get this information
Here is an example : -
//SYSIN DD *
/CONTROL DATABASE= YOUR DB HLQ
/TITLE 'DISPLAY REPORTS OVER NNNN LINES'
/DEFINE CNT BIN
/IF LINES GE 900000 < number of lines to report on
/ PRINT ID 'REPORT ID'
/ PRINT JOBNAME 'JOB NAME'
/ PRINT LINES 'LINES '
/ PRINT PAGES 'PAGES '
/ PRINT LOC ' LOC '
/ PRINT TRANS(DISK,'N','TAPE','Y','DISK','T','TEMP') ' DISK'
/ PRINT ARCHDATE 'ARC DATE'
/ PRINT ARCHTIME 'ARC TIME'
/ PRINT JOBID 'JOB ID'
/ PRINT CLASS 'CLASS'
/ SET CNT = CNT+1
/ END
/ON ENDDATA
/ PRINT 'TOTAL REPORTS='||CNT COL(1)
/END