|
|
|
The DB2 Accounting Report provides an extract of the most pertinent information from the DB2 User Activity File (DB2DSU), which is created from the SMF Type 101 record. It details the activity of active DB2 users. The Accounting Report is normally produced as a part of the DAILYRPT and MONTHRPT jobs, which are automatically submitted during the DAILY and MONTHLY runs, respectively. DAILYRPT executes the SAS program found in sharedprefix.MICS.SOURCE(DYDB2MBO), while MONTHRPT executes sharedprefix.MICS.SOURCE(MNDB2MBO). Both of these programs prepare data and then execute the actual report generation program located in sharedprefix.MICS.SOURCE(DB2ACTPT), which produces the Accounting report. The program will produce a separate report for each DB2 subsystem. To activate this report for use in DYDB2MBO or MNDB2MBO, you must set the macro variable USRAREP=Y in the #DB2MOBJ member of your unit library prefix.MICS.USER.SOURCE. The system default report macro variable values are in sharedprefix.MICS.SOURCE member #DB2MOBJ. To create this report directly, ensure the macro variable USRAREP is set equal to Y in member #DB2MOBJ of your unit library prefix.MICS.USER.SOURCE. If you require the DDF reporting block for this report, you must also set the macro variable DDUREP=Y. Set all other macro variables to N to produce ONLY the DB2 Accounting report. Finally, you must execute the program DYDB2MBO or MNDB2MBO as is done in the DAILYRPT and MONTHRPT jobs.
CA PAGE: 1 CA MICS/DB2 DB2 ACCOUNTING REPORT SUBPAGE: 1 RUN DATE: Monday, July 11, YYYY ================================================================================================================================ ! ! ! ! SYSID:A1A1 ! DB2 SYSTEM: RA1A ! USER: * ALL * ! PLAN: * ALL * ! THREADS: 40479 ! RELEASE: 9.1 !ORIGINAL USER: * ALL * ! FACILITY: * ALL * ! ================================================================================================================================ CPU TIME CLASS 1 TCB TIME 0:02:39.085 TOTAL I/O TIME 0:00:31.179 CLASS 1 zIIP TIME 0:00:34.173 TOTAL LOCK AND LATCH TIME 0:00:00.406 CLASS 1 ELAPSED TIME 8:07:39.445 OTHER READ TIME 0:00:45.111 CLASS 2 TCB TIME 0:02:07.258 OTHER WRITE TIME 0:00:12.373 CLASS 2 zIIP TIME 0:00:27.804 SERVICE TASK TIME 0:03:08.620 CLASS 2 ELAPSED TIME 0:13:22.783 ARCHIVE LOG TIME 0:00:00.000 zIIP ELIGIBLE TIME 0:00:00.000 NO. ENTRY/EXIT EVENTS 723,356 NO. WAIT TRACE EVENTS 22,376 -------------------------------------------------------------------------------------------------------------------------------- THREAD STATUS NORMAL TERMINATION ABNORMAL TERMINATION WORK UNIT IN DOUBT END OF TASK 3 APPLICATION ABENDED 0 APPLICATION ABENDED 0 APPLICATION ENDED 0 END OF MEMORY 0 END OF MEMORY 0 DEALLOCATION 20,673 RESOLVE INDOUBT 0 RESOLVE INDOUBT 0 NEW USER 0 FORCE COMMAND 0 FORCE COMMAND 0 -------------------------------------------------------------------------------------------------------------------------------- SQL CALLS MANIPULATIVE STATEMENTS CONTROL STATEMENTS DEFINITIONAL STATEMENTS SELECT 2,203 LOCK TABLE 0 CREATE DROP ALTER INSERT 3,953 GRANT 2 UPDATE 2,251 REVOKE 0 TABLE 0 0 0 DELETE 3,357 INCREMENTAL BIND 0 INDEX 0 0 0 DESCRIBE 14,503 COMMENT 0 TABLESPACE 0 0 0 PREPARE 31,420 SET SQLID 22,657 STOREGROUP 0 0 0 OPEN 48,168 SET HOST VARIABLE 5 DATA BASE 0 0 0 CLOSE 20,169 SYNONYM 0 0 FETCH 68,314 VIEW 0 0 LABEL 0 PACKAGE 0 DESCRIBE TABLE 0 -------------------------------------------------------------------------------------------------------------------------------- COMMITS 50,689 ABORT REQUESTS 19,723 -------------------------------------------------------------------------------------------------------------------------------- REPORTING PERIOD Friday, July 08, YYYY 6:01:17 TO Friday, July 08, YYYY 18:01:16 --------------------------------------------------------------------------------------------------------------------------------
Figure 3-3. DB2 Accounting Report Sample (Part 1 of 3)
CA PAGE: 2 CA MICS/DB2 DB2 ACCOUNTING REPORT SUBPAGE: 2 RUN DATE: Monday, July 11, YYYY ================================================================================================================================ ! ! ! ! SYSID:A1A1 ! DB2 SYSTEM: RA1A ! USER: * ALL * ! PLAN: * ALL * ! THREADS: 40479 ! RELEASE: 9.1 !ORIGINAL USER: * ALL * ! FACILITY: * ALL * ! ================================================================================================================================ LOCKING DEADLOCKS 0 RESOURCE TABLE ID 01 OTHER SUSPEND COUNT 10,149 SUSPENSIONS 10,237 HOW LIMIT WAS DETERMINED INFINITE LIMIT LOCK REQUEST COUNT 709,101 TIMEOUTS 0 SERVICE UNIT TIME LIMIT 0 QUERY REQUEST COUNT 3,156 ESCALATED TO SHARED 0 CPU TIME LIMIT 0:00:00.000 CHANGE REQUEST COUNT 178,248 ESCALATED TO EXCLUSIVE 1 HIGHEST CPU TIME USED 0:02:36.461 OTHER IRLM REQUEST COUNT 0 MAX. PAGE LOCKS HELD 30,664 LATCH SUSPEND COUNT 79 -------------------------------------------------------------------------------------------------------------------------------- BUFFER MANAGER SUMMARY GETPAGE REQUESTS 2,179,916 RECORD IN SYSTEM PAGE UPDATED 182,218 SYNCHRONOUS READ I/O 8,434 SYNCHRONOUS WRITE I/O 3,118 SEQUENTIAL PREFETCH REQUESTS 12,450 LIST PREFETCH REQUESTS 3,837 DYNAMIC PREFETCH REQUESTS 12,982 UNSUCCESSFUL GET PAGE OPERATIONS 0 ASYNC PAGES READ BY PREFETCH 159,369 -------------------------------------------------------------------------------------------------------------------------------- REPORTING PERIOD Friday, July 08, YYYY 6:01:17 TO Friday, July 08, YYYY 18:01:16 --------------------------------------------------------------------------------------------------------------------------------
Figure 3-3. DB2 Accounting Report Sample (Part 2 of 3)
CA PAGE: 3 CA MICS/DB2 DB2 ACCOUNTING REPORT SUBPAGE: 3 RUN DATE: Monday, July 11, YYYY ================================================================================================================================ ! ! ! ! SYSID:A1A1 ! DB2 SYSTEM: RA1A ! USER: OPCPROD ! PLAN: * ALL * ! THREADS: 40479 ! RELEASE: 9.1 !ORIGINAL USER: * ALL * ! FACILITY: * ALL * ! ================================================================================================================================ DDF ACCOUNTING STATISTICS REMOTE REQUESTING!------------------------------------------------------------------------------------------------------------- LOCATION(S) ! DDF ! ABORT ! COMMIT ! CONVERS. ! SQL ! ROWS !------ MESSAGES ------!-- BYTES/1000 ---- (PROTOCOLS) ! THRDS ! RECEIVED ! RECEIVED ! RECEIVED ! RECEIVED ! SENT ! SENT ! RECEIVED ! SENT ! RECEIVED ------------------------------------------------------------------------------------------------------------------------------ DEGNO50R_DSN8 ! 11! 0 0 1 2,015 666 2,026 2,036 384 323 (DRDA & PRIVATE) ! AVG ! 0.0 0.0 0.1 183.2 60.5 184.2 185.1 34 29@ ! MAX ! 0 0 1 200 71 201 202 39 32 ! ! 10.64.96.193 ! 12623! 5 249 0 95,741 3 38,411 38,411 27,354 27,184 (DRDA & PRIVATE) ! AVG ! 0.0 0.0 0.0 7.6 0.0 3.0 3.0 2,167@ 2@ ! MAX ! 1 1 0 67 1 61 61 58 20 ! ! 10.64.98.1 ! 7272! 0 5,977 0 24,534 65 14,042 14,042 5,854 6,673 (DRDA & PRIVATE) ! AVG ! 0.0 0.8 0.0 3.4 0.0 1.9 1.9 805@ 1@ ! MAX ! 0 1 0 39 3 22 22 23 9,436@ ! ! 10.96.139.43 ! 3! 0 3 0 7 0 10 10 1,117@ 786@ (DRDA & PRIVATE) ! AVG ! 0.0 1.0 0.0 2.3 0.0 3.3 3.3 372@ 262@ ! MAX ! 0 1 0 3 0 4 4 478@ 318@ ! ! 10.96.139.93 ! 5! 0 0 0 0 0 0 0 0@ 0@ (DRDA & PRIVATE) ! AVG ! 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0@ 0@ ! MAX ! 0 0 0 0 0 0 0 0@ 0@ ! ! +------------------------------------------------------------------------------------------------------------ @ - INDICATES THE REPORTED BYTE COUNT IS NOT DIVIDED BY 1000 -------------------------------------------------------------------------------------------------------------------------------- REPORTING PERIOD Friday, July 08, YYYY 6:01:17 TO Friday, July 08, YYYY 18:01:16 --------------------------------------------------------------------------------------------------------------------------------
Figure 3-3. DB2 Accounting Report Sample (Part 3 of 3)
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |