You can view the Transaction Duration screen either graphically or numerically. The default display presents a graph. Choose the Numbers option by typing N to change the display from graph to numbers. When in the numeric display, choose the Graph option by typing G to change to the graphical display. The Graph option of this screen presents a graph that indicates the overall real-time processing performance of the database. It shows the transaction rate (number per second, by default) and the time required to complete transactions. The duration of each transaction is measured from the first SQL SET TRANSACTION statement to the completion of the COMMIT or ROLLBACK verb. In addition to displaying average transaction duration, this screen shows a graph of the transaction durations. As each transaction completes, it is added to the cumulative histogram display. The 95 percentile response time is continuously updated to show the time in which 95 percent or more of the transactions complete. The screen gives an indication of subjective system response time. The Numbers option of this screen provides the exact number of transactions in each of the 16 time categories. The numeric display also shows the number of transactions that completed and the number of transactions that did not complete within each time category. The information in the numeric version of the Transaction Duration screen includes: o Total transaction count This is the total number of transactions represented by the information on the screen. Reset the number of transactions with the Reset option by typing R. o Duration This column contains the transaction duration categories. For the short-duration transaction display, the format n-<m means that each category includes transactions of n seconds to less than but not including m seconds. For the long-duration transaction display, the format n-<m means that each category includes transactions of n minutes to less than but not including m minutes. o Tx.Count, % The Tx. Count column contains the number of transactions in each transaction duration category. The % column shows the percentage of the total transactions in each transaction duration category. o #Complete, % The #Complete column contains the total number of transactions that completed by the end of the the time specified by each transaction duration category. The % column shows the percentage of the total transactions that completed by the end of the time specified by each transaction duration category. o #Incomplete, % The #Incomplete column contains the total number of transactions that did not complete before the end of the time specified by each transaction duration category. The % column shows the percentage of the total transactions that did not complete before the end of the time specified by each transaction duration category. The Complete % and Incomplete % should always add up to 100% for each transaction duration category. o <- average The <- average indicator on the right side of the screen points to the transaction duration category that contains the average transaction duration time. This indicator changes at runtime to maintain an accurate indication of the average transaction duration time. You can use the Config menu option to configure the Transaction Duration screen. Select this option, by typing the letter C, to display the configuration submenu. The configuration submenu provides the following options: o Total transaction duration Displays read-only and read/write transactions o Read/Write transaction duration Displays read/write transactions o Read-Only transaction duration Displays read-only transactions o XXX duration transaction display Displays either the short or long duration transaction display. The option description changes depending on which duration is currently being displayed. If you collect statistics in an output file using the Output qualifier for the RMU Show Statistics command, you can replay the Transaction Duration screen by using the Input qualifier.