From a Unix command prompt run report for 600 seconds (10 mins)
Code:
db2 call monreport.dbsummary \(600\)
I really like this report but and having issues believing some of the numbers for the given time period mostly the wait on I/O part. Now I know I have a few too many sort overflows but is this report saying that 20% of the CPU spent was waiting on I/O and 94% of that was waiting on the logs to read/write?
example:
Code:
-- Detailed breakdown of TOTAL_WAIT_TIME --
% Total
--- ---------------------------------------------
TOTAL_WAIT_TIME 100 1280852
I/O wait time
POOL_READ_TIME 0 3541
POOL_WRITE_TIME 0 8514
DIRECT_READ_TIME 0 45
DIRECT_WRITE_TIME 0 1061
LOG_DISK_WAIT_TIME 94 1204324
LOCK_WAIT_TIME 0 148
AGENT_WAIT_TIME 0 0
Network and FCM
TCPIP_SEND_WAIT_TIME 2 35814
TCPIP_RECV_WAIT_TIME 2 27405
IPC_SEND_WAIT_TIME 0 0
IPC_RECV_WAIT_TIME 0 0
FCM_SEND_WAIT_TIME 0 0
FCM_RECV_WAIT_TIME 0 0
WLM_QUEUE_TIME_TOTAL 0 0
Component times
--------------------------------------------------------------------------------
-- Detailed breakdown of processing time --
% Total
---------------- --------------------------
Total processing 100 4830203
Section execution
TOTAL_SECTION_PROC_TIME 81 3952997
TOTAL_SECTION_SORT_PROC_TIME 0 30677
Compile
TOTAL_COMPILE_PROC_TIME 0 19014
TOTAL_IMPLICIT_COMPILE_PROC_TIME 0 0
Transaction end processing
TOTAL_COMMIT_PROC_TIME 0 23383
TOTAL_ROLLBACK_PROC_TIME 0 42
Utilities
TOTAL_RUNSTATS_PROC_TIME 0 0
TOTAL_REORGS_PROC_TIME 0 0
TOTAL_LOAD_PROC_TIME 0 0
Sort
--------------------------------------------------------------------------------
TOTAL_SORTS = 8769
SORT_OVERFLOWS = 139
POST_THRESHOLD_SORTS = 0
POST_SHRTHRESHOLD_SORTS = 0
Network
--------------------------------------------------------------------------------
Communications with remote clients
TCPIP_SEND_VOLUME per send = 486 (755672122/1554606)
TCPIP_RECV_VOLUME per receive = 1700 (2663405006/1565808)
Communications with local clients
IPC_SEND_VOLUME per send = 151 (1210/8)
IPC_RECV_VOLUME per receive = 189 (1518/8)
Fast communications manager
FCM_SEND_VOLUME per send = 0 (0/0)
FCM_RECV_VOLUME per receive = 0 (0/0)
Other
--------------------------------------------------------------------------------
Compilation
TOTAL_COMPILATIONS = 4610
PKG_CACHE_INSERTS = 4604
PKG_CACHE_LOOKUPS = 1643881
Catalog cache
CAT_CACHE_INSERTS = 16
CAT_CACHE_LOOKUPS = 21269
Transaction processing
TOTAL_APP_COMMITS = 292067
INT_COMMITS = 34
TOTAL_APP_ROLLBACKS = 1438
INT_ROLLBACKS = 0
Log buffer
NUM_LOG_BUFFER_FULL = 0
Activities aborted/rejected
ACT_ABORTED_TOTAL = 664
ACT_REJECTED_TOTAL = 0
Workload management controls
WLM_QUEUE_ASSIGNMENTS_TOTAL = 0
WLM_QUEUE_TIME_TOTAL = 0
DB2 utility operations
--------------------------------------------------------------------------------
TOTAL_RUNSTATS = 0
TOTAL_REORGS = 0
TOTAL_LOADS = 0
================================================================================
Part 2 - Application performance drill down
Application performance database-wide
--------------------------------------------------------------------------------
TOTAL_CPU_TIME TOTAL_ TOTAL_APP_ ROWS_READ +
per request WAIT_TIME % COMMITS ROWS_MODIFIED
---------------------- ----------- ------------- ----------------------------
272 20 292067 504010876
dBforums
>
anyone using monreport.dbsummary?
04-28-11, 10:05
Linear Mode
