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