Previous Topic: CA7xx016  Composite Database Activity ProfileNext Topic: CA7xx018  Queue Posting Activity


CA7xx017 Composite Queue Activity Profile

The Composite Queue Activity Profile report provides a composite profile of the queue activity. The report is a summary of the information provided on reports CA7xx002 through CA7xx007. Activity is shown in time increments as specified by the SUMM parameter. The log record type from which this report is produced is TYPE=161.

Information is provided in groups of seven detail lines and a total line for each increment of time.

12/11/yy CA-7 COMPOSITE QUEUE ACTIVITY PROFILE PAGE 1 TIME: 13.56.17 REQUEST - CA7xx017 ----------------------------------------------------------------------------------------------------------------------------------- TIMES/ PCT PCT QUEUES ADDS DELETES READS REPLACES TOTAL READS QLOCKS QLOCKS ----------------------------------------------------------------------------------------------------------------------------------- yy.062/19:00 - 19:15 QUEUE - REQ 164 82 40,004 466 40,716 98.2 QUEUE - RDY 111 0 6,076 214 6,401 94.9 QUEUE - ACT 77 0 6,571 804 7,452 97.1 QUEUE - PRN 0 0 51,201 78 51,279 99.8 QUEUE - PRE 0 0 0 0 0 .0 QUEUE - PST 0 0 0 0 0 .0 TOTALS 352 82 103,852 1,562 105,848 98.1 2,394 2.3 yy.062/19:15 - 19:30 QUEUE - REQ 183 111 53,507 351 54,152 98.8 QUEUE - RDY 59 0 5,616 187 5,862 95.8 QUEUE - ACT 94 0 9,691 978 10,763 90.0 QUEUE - PRN 0 0 153,257 115 153,372 99.9 QUEUE - PRE 0 0 0 0 0 .0 QUEUE - PST 0 0 0 0 0 .0 TOTALS 336 111 222,071 1,631 224,149 99.0 1,453 0.6 yy.062/19:30 - 19:45 QUEUE - REQ 286 149 69,295 754 70,484 98.3 QUEUE - RDY 111 0 4,526 316 4,953 91.3 QUEUE - ACT 113 0 13,165 1,323 14,601 90.1 QUEUE - PRN 0 0 76,823 145 76,968 99.8 QUEUE - PRE 0 0 0 0 0 .0 QUEUE - PST 0 0 0 0 0 .0 TOTALS 510 149 163,809 2,538 167,006 98.0 2,234 1.3 yy.062/19:45 - 20:00 QUEUE - REQ 244 134 66,379 598 67,355 98.5 QUEUE - RDY 113 0 2,635 287 3,035 86.8 QUEUE - ACT 112 0 11,945 1,488 13,545 yy.1 QUEUE - PRN 0 0 38,547 126 38,673 99.6 QUEUE - PRE 0 0 0 0 0 .0 QUEUE - PST 0 0 0 0 0 .0 TOTALS 469 134 119,506 2,499 122,608 97.4 1,796 1.5 yy.062/20:00 - 20:15 QUEUE - REQ 324 167 79,735 873 81,099 98.3 QUEUE - RDY 138 0 4,966 351 5,455 91.0 QUEUE - ACT 136 0 16,340 1,125 17,601 92.8 QUEUE - PRN 0 0 76,891 175 77,066 99.7 QUEUE - PRE 0 0 0 0 0 .0 QUEUE - PST 0 0 0 0 0 .0 TOTALS 598 167 177,932 2,524 181,221 98.1 1,658 0.9 END OF REPORT

This report contains the following fields:

TIMES/QUEUES

Identifies the increment of date and time. Each increment spans the number of minutes specified in the SUMM parameter. The FROM parameter sets the first increment start time. The THRU parameter sets the end time of the last increment.

QUEUE - xxx appears in this column for queue detail lines to identify the queue.

ADDS

Identifies the number of records added to the queue.

DELETES

Identifies the number of records deleted from the queue.

READS

Identifies the number of records read from the queue.

REPLACES

Identifies the number of records replaced (updated) in the queue.

TOTAL

Identifies the total number of accesses to the queue.

PCT READS

Identifies the percent of total accesses that were reads.

QLOCKS

Identifies the number of times that queue access was prevented due to update activity.

PCT QLOCKS

Identifies the percent of QLOCKS that occurred as compared to total accesses.