Overview
Transaction statistics record resource usage by transaction (that is, across tasks). At run time, IDMS DC accumulates transaction statistics when requested to do so by a user program.
The program initiates collection with a BIND TRANSACTION STATISTICS statement and terminates collection with an END TRANSACTION STATISTICS statement. The END TRANSACTION STATISTICS and ACCEPT TRANSACTION STATISTICS statements write statistics to the DC/UCF log file.
Note: For more information about transaction statistics and how to collect transaction statistics, see the CA IDMS System Operations Guide.
Summary of Transaction Statistics Reports
Three statistics reports summarize transaction activity:
|
SREPORT 010 |
Summarizes transaction statistics by user identifier. |
|
SREPORT 011 |
Summarizes transaction statistics by logical terminal identifier. |
|
SREPORT 021 |
Summarizes transaction statistics by dialog. |
Sample SREPORT 010:
REPORT NO. 10 IDMS-DC TRANSACTION STATISTICS BY USER ID Rnn.n mm/dd/yy PAGE 4
SELECTED FROM: yyddd hh:mm TO: yyddd hh:mm
CV SYSTEM START: yyddd hh:mm TO: yyddd hh:mm
CV JOB NAME: jobname
CV NUMBER: nnn
USER ID: CMH
NUMBER PROGRAMS CALLED 404 NUMBER PROGRAMS LOADED 20
NUMBER TERMINAL READS 22 NUMBER TERMINAL WRITES 22
NUMBER TERMINAL ERRORS 0 NUMBER GETSBG REQUESTS 1,200
NUMBER GETSCR REQUESTS 61 NUMBER PUTSCR REQUESTS 71
NUMBER DELSCR REQUESTS 19 NUMBER GETQUE REQUESTS 48
NUMBER PUTQUE REQUESTS 33 NUMBER DELQUE REQUESTS 11
NUMBER GETTIME REQUESTS 313 NUMBER SETTIME REQUESTS 0
NUMBER DB SERVICE RQSTS 42 NUMBER PAGES READ 180
TASK USER MODE TIME .8382 TASK SYSTEM MODE TIME 2.7998
TASK WAIT TIME 18.2473
NUMBER PAGES WRITTEN 15 NUMBER PAGES REQUESTED 2,556
NUMBER CALC RECS NO OFLOW 11 NUMBER CALC RECS OFLOW 0
NUMBER VIA RECS NO OFLOW 33 NUMBER VIA RECS OFLOW 0
NUMBER RECORDS REQUESTED 2,737 NUMBER RECORDS CURRENT OF RU 920
NUMBER FRAGMENTS STORED 0 NUMBER RECORDS RELOCATED 0
NUMBER CALLS TO DBMS 581 TOTAL LOCKS ACQUIRED 7,466
NUMBER SR8 SPLITS 56 NUMBER SR8 STORES 44
NUMBER SR8 SPAWNS 4 NUMBER SR8 ERASES 44
NUMBER ORPHAN ADOPT 18 NUMBER SR7 STORES 2
NUMBER BTREE SEARCHES 381 NUMBER SR7 ERASES 2
NUMBER SQL COMMANDS 27 NUMBER SQL SORTS 1
NUMBER TUPLES FETCHED 785 NUMBER TUPLES SORTED 728
NUMBER ROWS INSERTED 0 NUMBER AM RECOMPILES 0
NUMBER ROWS UPDATED 0
NUMBER ROWS DELETED 0
TASK SYSTEM MODE CPU 17.487940 TASK ZIIP ON CP CPU .000000
TASK ZIIP ON ZIIP CPU .000000 TASK USER MODE CPU .000000
TOTAL TASK TCB CPU 17.487940 ENCLAVE CPU .000000
Sample SREPORT 011:
REPORT NO. 11 IDMS-DC TRANSACTION STATISTICS BY LTERM ID Rnn.n mm/dd/yy PAGE 13
SELECTED FROM: yyddd hh:mm TO: yyddd hh:mm
CV SYSTEM START: yyddd hh:mm TO: yyddd hh:mm
CV JOB NAME: jobname
CV NUMBER: nnn
LTERM ID: LT12022
NUMBER PROGRAMS CALLED 404 NUMBER PROGRAMS LOADED 20
NUMBER TERMINAL READS 22 NUMBER TERMINAL WRITES 22
NUMBER TERMINAL ERRORS 0 NUMBER GETSBG REQUESTS 1,200
NUMBER GETSCR REQUESTS 61 NUMBER PUTSCR REQUESTS 71
NUMBER DELSCR REQUESTS 19 NUMBER GETQUE REQUESTS 48
NUMBER PUTQUE REQUESTS 33 NUMBER DELQUE REQUESTS 11
NUMBER GETTIME REQUESTS 313 NUMBER SETTIME REQUESTS 0
NUMBER DB SERVICE RQSTS 42 NUMBER PAGES READ 180
TASK USER MODE TIME .8382 TASK SYSTEM MODE TIME 2.7998
TASK WAIT TIME 18.2473
NUMBER PAGES WRITTEN 15 NUMBER PAGES REQUESTED 2,556
NUMBER CALC RECS NO OFLOW 11 NUMBER CALC RECS OFLOW 0
NUMBER VIA RECS NO OFLOW 33 NUMBER VIA RECS OFLOW 0
NUMBER RECORDS REQUESTED 2,737 NUMBER RECORDS CURRENT OF RU 920
NUMBER FRAGMENTS STORED 0 NUMBER RECORDS RELOCATED 0
NUMBER CALLS TO DBMS 581 TOTAL LOCKS ACQUIRED 7,466
NUMBER SR8 SPLITS 56 NUMBER SR8 STORES 44
NUMBER SR8 SPAWNS 4 NUMBER SR8 ERASES 44
NUMBER ORPHAN ADOPT 18 NUMBER SR7 STORES 2
NUMBER BTREE SEARCHES 381 NUMBER SR7 ERASES 2
NUMBER SQL COMMANDS 27 NUMBER SQL SORTS 1
NUMBER TUPLES FETCHED 785 NUMBER TUPLES SORTED 728
NUMBER ROWS INSERTED 0 NUMBER AM RECOMPILES 0
NUMBER ROWS UPDATED 0
NUMBER ROWS DELETED 0
TASK SYSTEM MODE CPU 17.487940 TASK ZIIP ON CP CPU .000000
TASK ZIIP ON ZIIP CPU .000000 TASK USER MODE CPU .000000
TOTAL TASK TCB CPU 17.487940 ENCLAVE CPU .000000
Sample SREPORT 021:
REPORT NO. 21 IDMS-DC TRANSACTION STATISTICS BY DIALOG Rnn.n mm/dd/yy PAGE 7
SELECTED FROM: yyddd hh:mm TO: yyddd hh:mm
CV SYSTEM START: yyddd hh:mm TO: yyddd hh:mm
CV JOB NAME: jobname
DIALOG: ASFRDEFD
NUMBER PROGRAMS CALLED 404 NUMBER PROGRAMS LOADED 20
NUMBER TERMINAL READS 22 NUMBER TERMINAL WRITES 22
NUMBER TERMINAL ERRORS 0 NUMBER GETSBG REQUESTS 1,200
NUMBER GETSCR REQUESTS 61 NUMBER PUTSCR REQUESTS 71
NUMBER DELSCR REQUESTS 19 NUMBER GETQUE REQUESTS 48
NUMBER PUTQUE REQUESTS 33 NUMBER DELQUE REQUESTS 11
NUMBER GETTIME REQUESTS 313 NUMBER SETTIME REQUESTS 0
NUMBER DB SERVICE RQSTS 42 NUMBER PAGES READ 180
TASK USER MODE TIME .8382 TASK SYSTEM MODE TIME 2.7998
TASK WAIT TIME 18.2473
NUMBER PAGES WRITTEN 15 NUMBER PAGES REQUESTED 2,556
NUMBER CALC RECS NO OFLOW 11 NUMBER CALC RECS OFLOW 0
NUMBER VIA RECS NO OFLOW 33 NUMBER VIA RECS OFLOW 0
NUMBER RECORDS REQUESTED 2,737 NUMBER RECORDS CURRENT OF RU 920
NUMBER FRAGMENTS STORED 0 NUMBER RECORDS RELOCATED 0
NUMBER CALLS TO DBMS 581 TOTAL LOCKS ACQUIRED 7,466
NUMBER SR8 SPLITS 56 NUMBER SR8 STORES 44
NUMBER SR8 SPAWNS 4 NUMBER SR8 ERASES 44
NUMBER ORPHAN ADOPT 18 NUMBER SR7 STORES 2
NUMBER BTREE SEARCHES 381 NUMBER SR7 ERASES 2
NUMBER SQL COMMANDS 27 NUMBER SQL SORTS 1
NUMBER TUPLES FETCHED 785 NUMBER TUPLES SORTED 728
NUMBER ROWS INSERTED 0 NUMBER AM RECOMPILES 0
NUMBER ROWS UPDATED 0
NUMBER ROWS DELETED 0
TASK SYSTEM MODE CPU 17.487940 TASK ZIIP ON CP CPU .000000
TASK ZIIP ON ZIIP CPU .000000 TASK USER MODE CPU .000000
TOTAL TASK TCB CPU 17.487940 ENCLAVE CPU .000000
|
Copyright © 2013 CA.
All rights reserved.
|
|