|
|
|
The DB2 System Services Report provides an extract of the most pertinent information from the DB2 System Activity File (DB2DSY) which is created from the SMF type 100 subtype 0 record. It details the system activity of each active DB2 subsystem. The DB2 System Services 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(DB2SYSPT). To activate this report for use in DYDB2MBO or MNDB2MBO, you must set the macro variable SYSREP=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 SYSREP 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 DDYREP=Y. Set all other macro variables to N to produce ONLY the System Services 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 SYSTEM SERVICES REPORT SUBPAGE: 1 RUN DATE: Friday, December 2, yyyy ================================================================================================================================= ! ! ! ! SYSID: A1A1 ! DB2 SYSTEM: RA1A ! ! ! DB2 RELEASE: 8.1 ! ================================================================================================================================= ! ! CPU TIME ! THREAD SUMMARY ! IFC CHECKPOINT DATA ! ! TCB ! THREADS 20,451 ! CHECKPOINTS 1 SYSTEM SERVICES 0:00:25.7 ! ! DATA BASE SERVICES 0:00:42.8 ! ! IMS RESOURCE LOCK MANAGER 0:00:00.0 ! ! DDF SERVICES 0:00:02.3 ! ! ! ! --------------------------------------------------------------------------------------------------------------------------------- SUBSYSTEM SERVICES CONNECT 621 COMMIT 4 SSI CALLS 629 EXIT 494 CREATE THREAD 20,451 ABORT 19,382 RESOLVE 0 END OF TASK 8 SIGNON 0 INDOUBT THREADS 0 SYNCHRONIZE 8,897 END OF MEMORY 0 TERMINATE 21,072 PREPARE TO COMMIT 0 THREADS WAITED 0 --------------------------------------------------------------------------------------------------------------------------------- ! AGENT SERVICES ! STORAGE MANAGER ! ALLOCATION FAILURES ! SHORT ON STORAGE UNAVAILABLE RESOURCE 0 ! DETECTED 0 DEADLOCK 0 ! CONTRACTION 0 INVALID RESOURCE 0 ! ABEND 0 ! PHYSICAL SUSPENDS 611,941 ! GETMAIN/FREEMAIN ERRORS 0 ! --------------------------------------------------------------------------------------------------------------------------------- LOG MANAGER LOG WRITE REQUESTS CONTROL INTERVALS LOG READ REQUESTS ARCHIVE LOG WRITE ACTIVE 46,153 CREATED 50,494 SATISFIED FROM ALLOCATIONS WAIT 0 OFFLOADED 297,000 OUTPUT BUFFER 166 READ 0 NO WAIT 278,821 ACTIVE LOG 0 WRITE 1 FORCE 13,770 ARCHIVE LOG 0 READS DELAY 0 BUFFER WAITS 0 --------------------------------------------------------------------------------------------------------------------------------- REPORTING PERIOD Friday, September 3, yyyy 6:02:23 TO Friday, September 3, yyyy 17:53:23 --------------------------------------------------------------------------------------------------------------------------------- CA PAGE: 2 CA MICS/DB2 DB2 SYSTEM SERVICES REPORT SUBPAGE: 2 RUN DATE: Friday, December 2, yyyy ================================================================================================================================= ! ! ! ! SYSID: A1A1 ! DB2 SYSTEM: RA1A ! ! ! DB2 RELEASE: 8.1 ! ================================================================================================================================= COMMAND DATA DISPLAY START STOP MISCELLANEOUS DATABASE 0 DB2 0 DB2 0 RECOVER BSDS 0 THREAD 4 DATABASE 0 DATABASE 0 RECOVER INDOUBT 0 UTILITY 0 TRACE 0 TRACE 0 TERM UTILITY 4 RLIMIT 0 RLIMIT 0 RLIMIT 0 MODIFY TRACE 0 LOCATION 0 DDF 0 DDF 0 CANCEL DDF THREAD 0 ARCHIVE LOG 0 --------------------------------------------------------------------------------------------------------------------------------- IFC DESTINATION DATA DESTINATION RECORDS ACCEPTED BUFFER ERRORS NOT ACCEPTED NOT ACTIVE WRITER FAILURE SMF 82,158 0 0 0 0 RES 0 0 0 0 0 GTF 0 0 0 0 0 OP1 97,816 0 0 0 0 OP2 0 0 0 0 0 OP3 0 0 0 0 0 OP4 0 0 0 0 0 OP5 0 0 0 0 0 OP6 0 0 0 0 0 OP7 0 0 0 0 0 OP8 0 0 0 0 0 --------------------------------------------------------------------------------------------------------------------------------- LATCH MANAGER ! IFI COUNTERS ! TEST SHARED/EXCLUSIVE 0 LOG BSDS ACCESS 297 ! ABENDS 0 SERVICE TASK CONTROLLER 0 BUFFER MANAGER EXCLUSIVE 2 117 ! UNRECOGNIZED FUNCTIONS 0 SSSC ALLIED AGENT QUEUE 9 DATA MANAGER HASH TABLES 3 ! COMMAND REQUESTS 7 SUBSYSTEM INTERFACE 1 DATA MANAGER 0 ! READA REQUEST 60,019 DATABASE ALLOCATION CONTROL 5 ADDRESS SPACE ACTIVE 1 ! READS REQUESTS 47 BUFFER MANAGER SHARED 0 SERVICE QUEUE 0 ! WRITE REQUESTS 0 BUFFER MANAGER EXCLUSIVE 192 SYSTEM ADDRESS SPACE 0 ! RECOVERY MANAGER STATUS 0 TRACE TABLE 2 ! SYNONYM CHAIN 1 0 STORAGE MGR VECTOR TABLE 8,393 ! SYNONYM CHAIN 2 0 STORAGE MGR HEADER BLOCK 2,568 ! LOG WRITE FUNCTION 41 ! ! --------------------------------------------------------------------------------------------------------------------------------- REPORTING PERIOD Friday, September 3, yyyy 6:02:23 TO Friday, September 3, yyyy 17:53:23 --------------------------------------------------------------------------------------------------------------------------------- CA PAGE: 3 CA MICS/DB2 DB2 SYSTEM SERVICES REPORT SUBPAGE: 3 RUN DATE: Friday, December 2, yyyy ================================================================================================================================= ! ! ! ! SYSID: A1A1 ! DB2 SYSTEM: RA1A ! ! ! DB2 RELEASE: 8.1 ! ================================================================================================================================= DDF SERVICES STATISTICS ---------------------------------------------------------------------------------------------------------------- REMOTE ! ! ! TYPE TRANS ! ! CONVERS.! ! SQL ! DATA ! BYTES/1000 LOCATION(S) ! TYPE ! TRANS. ! ABORTS ! COMMITS! CONVERS. ! QUEUED ! MESSAGES !STATEMENTS! ROWS ! TRANSMITTED --------------------------------------------------------------------------------------------------------------------------------- DRDA REMOTE LOCS !SENT TO:! 0 0 0 0 0 54,933 0 732 33,648 ! AVG ! 0 0.0 0.0 1.0 0.0 54,933.0 0.0 732 33,648 (STAT.RECORDS) ! MAX ! 0 0 0 0 0 2,520 0 672 3,339 71 !RECVD FR! 185 5 6,329 185 ------ 54,944 122,247 0 34,244 ! AVG ! 1 0.0 34.2 1.0 ------ 297.0 660.8 0 185 ! MAX ! 21 2 645 21 ------ 2,531 6,742 0 2,019 ! ! +-------------------------------------------------------------------------------------------------------------- @ - INDICATES REPORTED BYTE COUNT IS NOT DIVIDED BY 1000 NOTE: * DDF AVERAGES ARE BASED ON TRANSACTIONS SENT/RECEIVED NOTE: * DDF MAXIMUMS ARE BASED ON DDF STATISTICS RECORD COUNT --------------------------------------------------------------------------------------------------------------------------------- REPORTING PERIOD Friday, September 3, yyyy 6:02:23 TO Friday, September 3, yyyy 17:53:23 ---------------------------------------------------------------------------------------------------------------------------------
Figure 3-1. DB2 System Services Report Sample
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |