Report on number of Lines over 900000 in a View database
search cancel

Report on number of Lines over 900000 in a View database

book

Article ID: 246154

calendar_today

Updated On:

Products

View

Issue/Introduction

 

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     

 

Environment

Release : 14.0

Component : View

Resolution

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