Accessing AutoCollect Data Using DBSQLPR › Sample Problem - 1 › DBSQLPR DSV Sample › Generated Report

Generated Report

MUF          DATE       TIME                 CPU             IO       REQUESTS
CHAR(8) N.N. DATE N.N.  TIME N.N. DEC(11,0) N.N. DEC(11,0) N.N. DEC(11,0) N.N.
____________ __________ _________ ______________ ______________ ______________
MUFS         2006-06-22 18.50.44              14         219632         410978
MUFS         2006-06-22 18.57.38              13         185681         497565
MUFS         2006-06-26 14.52.19               0            382           1895
___ 3 rows returned ___  

   REQ_PER_CPU     REQ_PER_IO                      COST_PER_REQ        
 DEC(11,2) N.N. DEC(11,2) N.N.                DEC(31,8) NOT NULL     
 ______________ ______________ _________________________________        
      29355.57           1.87                        0.00602513        
      38274.23           2.67                        0.00425379        
          0.00           4.96                        0.00201583        

Use DBSQLPR with the following DSV output parameters to re-execute the query to generate a DSV file.

STDOUT directed to DSN  (//STDOUT DD DSN=seq.file,DISP=(NEW,CATLG),…
Processing Options        
AUTHID=SYSADM              
SQLMODE=DATACOM            
WORKSPACE=128              
PRTWIDTH=1500              
NOECHO                     
NOFORMFEED                 
PAGELEN=999999999          
NOTYPE                     
DATASEPARATOR=;