Accessing AutoCollect Data Using DBSQLPR › Sample Problem - 2

Sample Problem - 2

The user wants a detailed list of logical and physical I/O per database for each of the LAST rowsets on file.

Using standard DBSQLPR, execute a query which generates the requested report. Default options chosen for most DBSQLPR parameters.

STDOUT directed to SYSOUT

Processing Options
       

AUTHID=SYSADM              
AUTHID=SYSADM                                                                
PRTWIDTH=160                                                                 
SQLMODE=DATACOM                                                              
WORKSPACE=128                                                                
NOTYPE                                                                       

INPUT STATEMENT:        
SELECT                                                   
  MUF_NAME,                                              
  DATE (D_MUF_ENABLE) AS DATE,                           
  DBID,                                                  
  SUM(PHYSICAL_READS + PHYSICAL_WRITES) AS PHYS_IO,      
  SUM(LOGICAL_READS + LOGICAL_WRITES) AS LOGIC_IO        
FROM AUTOCOLLECT.D_MUF_AREA_STATS                        
  WHERE  D_MUF_TYPE = 'LAST'                             
 GROUP BY MUF_NAME, D_MUF_ENABLE,  DBID;