Fame Glow Feed

Premium fame highlights with sleek curation.

news

Accounting detail trace—short report (BACCTST) - Documentation for BMC AMI Ops Monitor for Db2 13.1

Writer Matthew Cannon
1 BACCTST : ACCNTG DETAIL TRACE, SHORT 11/18/10 15:46:18 PAGE 21 LOCATION: DEFF ACCOUNTING DETAIL TRACE - SHORT GROUP: N/A MEMBER: N/A SUBSYSTEM: DEFF 10.1 ACTUAL FROM: 11/16/10 13:35:01.11 PRIMAUTH CONNECT CONN TYPE ORIGAUTH CORRELATION ACCOUNTING TIMESTAMP COMMIT OPEN UPDATE INSERT ELAPSED(CL1) ELAPSED(CL2) GETPAGE SYNC RD LK SUSP PLANNAME THREAD TYPE TERMINATION CONDITION SELECT FETCH DELETE PREPARE CPU (CL1) CPU (CL2) BUF UPD PREFTCH LOCKOUT -------- ------------ ----------------------- ------- ------- ------- -------- ------------ ------------ ------- ------- ------- RDAJRG DB2CALL DB2CALL RDAJRG JRGHA01A 11/16/10 13:41:48.38 21 0 0 0 00:00.056027 00:00.040230 137 24 0 ARUQA ALLIED NORM 22 0 3 0 00:00.005622 00:00.005016 0 3 0 ___ PROGRAM NAME TYPE SQLSTMT CL7 ELAP TIME CL7 CPU TIME CL 8 SUSP TIME CL8 SUSP ALLOC SP UDF *ROLLUP* 0000 24 00:00.011271 00:00.002337 00:00.004960 23 2 0 0 *ROLLUP* 0000 1 00:00.017680 00:00.000336 00:00.001852 3 1 0 0 RDAJRG DB2CALL DB2CALL RDAJRG JRGHA01A 11/16/10 13:41:55.28 30 0 8 2 00:05.864413 00:00.060479 175 9 0 ARUQA ALLIED NORM 23 0 2 0 00:00.010623 00:00.008922 26 1 0 ___ PROGRAM NAME TYPE SQLSTMT CL7 ELAP TIME CL7 CPU TIME CL 8 SUSP TIME CL8 SUSP ALLOC SP UDF *ROLLUP* 0000 34 00:00.029733 00:00.004385 00:00.012456 22 2 0 0 *ROLLUP* 0000 1 00:00.001004 00:00.000146 00:00.000000 0 1 0 0 RDAJRG DB2CALL DB2CALL RDAJRG JRGHA01A 11/16/10 13:41:49.57 1 0 0 0 00:00.050921 00:00.041669 113 15 0 ARUQA ALLIED NORM 3 0 0 0 00:00.003200 00:00.002279 0 8 0 ___ PROGRAM NAME TYPE SQLSTMT CL7 ELAP TIME CL7 CPU TIME CL 8 SUSP TIME CL8 SUSP ALLOC SP UDF *ROLLUP* 0000 3 00:00.041662 00:00.002274 00:00.015428 16 1 0 0 RDAJRG DB2CALL DB2CALL RDAJRG JRGHA01A 11/16/10 13:41:49.69 1 0 0 0 00:00.102028 00:00.008115 44 14 0 ARUQA ALLIED NORM 2 0 0 0 00:00.003255 00:00.001348 0 3 0 ___ PROGRAM NAME TYPE SQLSTMT CL7 ELAP TIME CL7 CPU TIME CL 8 SUSP TIME CL8 SUSP ALLOC SP UDF *ROLLUP* 0000 2 00:00.008110 00:00.001344 00:00.003104 8 1 0 0 RDAJRG DB2CALL DB2CALL RDAJRG JRGHA01A 11/16/10 13:41:49.69 1 0 0 0 00:00.000472 00:00.000441 2 0 0 ARUQA ALLIED NORM 1 0 0 0 00:00.000393 00:00.000361 0 0 0 ___ PROGRAM NAME TYPE SQLSTMT CL7 ELAP TIME CL7 CPU TIME CL 8 SUSP TIME CL8 SUSP ALLOC SP UDF *ROLLUP* 0000 1 00:00.000425 00:00.000357 00:00.000000 0 1 0 0