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

DBSQLPR DSV Sample

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

STDOUT directed to SYSOUT

Processing Options

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

INPUT STATEMENT:        
   SELECT MUF_NAME AS MUF,                                                    
       DATE(D_MUF_DATETIME) AS DATE,                                          
       TIME(D_MUF_DATETIME) AS TIME,                                          
       CURRENT_CPU AS CPU,                                                    
       PHYSICAL_IO AS IO,                                                     
       DB_REQUESTS AS REQUESTS,                                               
       REQUESTS_2_CPU AS REQ_PER_CPU,                                         
       REQUESTS_2_PIO AS REQ_PER_IO,                                          
       ((CURRENT_CPU * 20)/DB_REQUESTS)+((PHYSICAL_IO*.01)/DB_REQUESTS) AS    
       COST_PER_REQ                                                           
  FROM AUTOCOLLECT.D_BUSINESS_VALUE_METRICS                                   
 WHERE D_MUF_TYPE = 'LAST';