|
db2 call sysproc.am_get_rpt(-2, 21, 'auth_id=''DB2FP9A'' and appl_name=''db2bp''', 5)
結果セット 1
--------------
STMT_TEXT
AVERAGE_STMT_EXEC_TIME TOTAL_EXEC_TIME NUM_EXECUTIONS TOTAL_USR_CPU_TIME
TOTAL_SYS_CPU_TIME ROWS_READ ROWS_WRITTEN STMT_SORTS NUM_COMPILATIONS PREP_TIME_BEST
PREP_TIME_WORST INT_ROWS_INSERTED INT_ROWS_UPDATED INT_ROWS_DELETED
----------------------------------------------------------------------------------------------------------------------
select l_orderkey, sum(l_extendedprice * (1 - l_discount)) as revenue, o_orderdate, o_shippriority from tpcd.customer,
tpcd.orders, tpcd.lineitem where c_mktsegment = 'BUILDING' and c_custkey = o_custkey and l_orderkey = o_orderkey and o_
orderdate < date ('1995-03-15') and l_shipdate > date ('1995-03-15') and l_shipmode = 'RAIL' group by l_orderkey, o_orde
rdate, o_shippriority order by revenue desc, o_orderdate fetch first 10 rows only
123 1107 9 289
21 56411906 3732712 33 1
43 43 0 0 0
|
|