Simple query

Summary tables are already summarized (by time), so a basic query does not require any scalar functions. The following query lists selected fields in the summary table:
SELECT TRAN,                                         
       INT(TASKCNT)               AS TASKCNT,        
       DEC(RESPONSE_TIME,8,2)     AS RESPONSE_TIME,  
       DEC(CPU_TIME,8,2)          AS CPU_TIME,       
       DEC(SUSPEND_TIME,8,2)      AS SUSPEND_TIME,   
       DEC(DISPATCH_TIME,8,2)     AS DISPATCH_TIME   
FROM CICSPA.CICSP1H                                
This query produces output like the following:
Figure 1. Simple SQL query against Summary DB2® table
                      RESPONSE         CPU       SUSPEND     DISPATCH
TRAN      TASKCNT       TIME           TIME       TIME         TIME  
----  -----------  -----------  -----------  -----------  -----------
CSOL            1      1887.43        16.00         9.00        16.00
CSMT            1      1887.22        16.00         9.00        16.00
FICX            1         0.00         1.00         1.00         1.00
SU4B            1         0.07       625.00       625.00       625.00
CWBG            1         0.00         1.00         1.00         1.00
BIC2            1         0.00         1.00         1.00         1.00
BIC2            1         0.00         1.00         1.00         1.00
AP77            1         1.17      3969.00      3969.00      3969.00
CAMA            1         0.01        25.00        25.00        25.00
CKPT            4         0.56      2313.00      2313.00      2313.00
CM99            1         0.01         1.00         1.00         1.00
CNA7            9         0.47       180.00       180.00       180.00
CNB0            3         0.17       891.00       891.00       891.00

Information Information

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//cpaug322.htm