REPORT control statement
The REPORT control statement determines the plot or plots to be generated for selected IRUF data.
You can request multiple plots with a single REPORT control statement.
A REPORT statement requires a SELECT statement. The SELECT statement identifies the IRUF data to be plotted and produces the plot as specified by the XAXIS and YAXIS keywords. To produce a plot, at least one REPORT and one SEL ECT control statement must be entered per PRSPLT00 execution.
REPORT = pc [(,pc...|'title')]
The pc value is one or more of the plot codes shown in the following table.
The optional title is a user-defined name (from 1 to 255 characters) that is enclosed in single quotation marks immediately following the report code parameter.
Default plot titles, plot descriptions, and plot codes
Default plot title and plot description | IRUF input | SELECT keyword usage | Plot code |
|---|---|---|---|
% DB2 CPU The amount of time attributed to DB2 processing, expressed as a percentage of the total transaction CPU time. This value is the DB2 portion of the total CPU collected in the transaction accounting record only. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | PD |
Average SQL Calls per DB2 Transaction The average number of SQL calls issued by each transaction that accessed a DB2 subsystem. | Database segment of the transaction accounting record data | DATABASE, TRANCODE, MSGREGION, and LTERM | AQ |
Average MQ Calls per MQ Transaction The average number of MQ calls issued by each MQ transaction. | MQ segment of the transaction accounting record data | TRANCODE, MSGREGION, and LTERM | AM |
Number of MQ Calls Total number of MQ calls. | MQ segment of the transaction accounting record data | TRANCODE, MSGREGION, and LTERM | MR |
Average Transaction Input Queue Time in Seconds For message switches, the average input queue time is measured from the arrival of the original transaction from the terminal. For more information, see 'Avg Trans Input Queue Time In Secs (Response Option)' below. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | TQ |
Avg Trans Input Queue Time in Secs (Response Option) The average time a transaction waited in the input queue for processing. This value differs from TQ only for message switches, where it is measured from the arrival of the message switch transaction on the queue. For DBCTL threads and TPI, this field is zero. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | NQ |
Average Transaction Response Time in Seconds The average response time, defined as input queue time (as in TQ) plus transaction elapsed time (ET). This value is valid for all transactions, not just those that respond to the originating terminal. For more information, see 'Avg Trans Response Time in Secs (Response Option)' below. For DBCTL threads and TPI, only the elapsed time is reported. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | TR |
Avg Trans Response Time in Secs (Response Option) The average response time from arrival on the input queue of the transaction from the originating LTERM to the first attempt to transmit an output message back to that LTERM. Nonresponse transactions are not measured. For DBCTL threads and TPI, this field is zero. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | NR |
Buffer Handling Processor (CPU) Time in Seconds The sum of message and control region Buffer CPU time expressed in seconds. For more information, see Message-buffer-CPU and Control-buffer-CPU. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | BP |
Core Allocation (in K-Core Hours) The amount of allocated K-core minutes, calculated as: Program_Elapsed_Time_in_Minutes × Core_Allocated | Program accounting record data | MSGREGION | CA |
Core Utilization (in K-Core Hours) The amount of allocated K-core minutes, calculated as: Program_Elapsed_Time_in_Minutes × Core_Used For DBCTL threads, this field is zero. | Program accounting record data | MSGREGION | CU |
DB2 Processor (CPU) Time in Seconds The amount of CPU time that is used in the dependent region to process DB2 requests. For more information, seeDB2-CPU. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | EC |
DL/I 'NO' Input/Output Count The number of NO I/Os is defined as calls to the IMS buffer handler during database call processing that did not result in an I/O. For more information, see NO-I-O. | Database segment of the transaction accounting record data | DATABASE, TRANCODE, MSGREGION, and LTERM | DN |
DL/I Processor (CPU) Time in Seconds The amount of DL/I CPU, both message and control region. For more information, seeMessage-DL-I-CPU and Control-DL-I-CPU. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | DP |
DL/I Requests The number of DL/I database calls, calculated as: GU + GN + ISRT + DLET + REPL | Database segment of the transaction accounting record data | DATABASE, TRANCODE, MSGREGION, and LTERM | DR |
Elapsed Time per Access Method Request in 1/100 Secs The elapsed time for a transaction, calculated as: (Transaction_Elapsed_Time - Transaction_CPU_Time) ÷ Total_Number_of_Database_I/Os_Measured_for_that_Transaction CPU time includes all CPU values in the transaction record (incurred during transaction execution), application program, DL/I, buffer handler and open/close CPU (both message and control region). I/Os include key and nonkey reads and writes. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | AW |
Fast Path Buffers Used The number of Fast Path buffers used. | Fast Path transaction accounting record data | RTCODE, TRANCODE, MSGREGION, and LTERM | BU |
Fast Path Buffer Waits The number of Fast Path buffer waits. | Fast Path transaction accounting record data | RTCODE, TRANCODE, MSGREGION, and LTERM | BW |
Fast Path CI Contentions The number of Fast Path CI contentions. | Fast Path transaction accounting record data | RTCODE, TRANCODE, MSGREGION, and LTERM | CC |
Fast Path Overflow Buffer Latch Waits The number of Fast Path overflow buffer latch waits. | Fast Path transaction accounting record data | RTCODE, TRANCODE, MSGREGION, and LTERM | OW |
Fast Path SYNC Point Failures The number of Fast Path sync point failures. | Fast Path transaction accounting record data | RTCODE, TRANCODE, MSGREGION, and LTERM | SF |
Key Database I/O The amount of database key I/O, both reads and writes. For more information, see Database-reads and Database-writes. | Database segment of the transaction accounting record data | DATABASE, TRANCODE, MSGREGION, and LTERM | PI |
Message Region Processor (CPU) Time in Seconds The amount of dependent region CPU: application program, message DL/I, message buffer, and DB2 CPU from the transaction record, plus message region overhead CPU from the program record if SELECT=ALL or MSGREGION. For more information, see Application-program-CPU, Message-DL-I-CPU, Message-buffer-CPU, and Message-region-overhead-CPU. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | MP |
Program accounting record data | MSGREGION | MP | |
Message Transfer (Input/Output) Character Count The number of characters input from and output to the originating LTERM. This value is the internal IMS message character counts, after MFS on input, before MFS on output. For DBCTL threads and TPI, this field is zero. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | MT |
Nonkey Database I/O The amount of database nonkey I/O, both reads and writes. For more information, see Database-reads and Database-writes. | Database segment of the transaction accounting record data | DATABASE, TRANCODE, MSGREGION, and LTERM | SI |
Number of SQL Calls The total number of all SQL calls issued by the transactions. | Database segment of the transaction accounting record data | DATABASE, TRANCODE, MSGREGION, and LTERM | ER |
Open/Close Processor (CPU) Time in Milliseconds The amount of open/close CPU in both message and control regions. For more information, see Message-OPEN-CLOSE-CPU and Control-OPEN-CLOSE-CPU. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | OP |
Program Processing Elapsed Time in Seconds The amount of program elapsed time. | Program accounting record data | MSGREGION | EP |
Program Scheduling Time in Seconds The amount of program scheduling CPU in the control/DLISAS regions. For more information, see Program-scheduling-CPU. | Program accounting record data | MSGREGION | PS |
Programs Executed The number of programs executed. | Program accounting record data | MSGREGION | PE |
Q Time as Percent of Response Time (Response Option) The ratio of input queue time (NQ) to response time (NR). Only response transactions are measured. For DBCTL threads and TPI, this field is zero. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | NX |
Queue Time as Percentage of Response Time The ratio of input queue time (TQ) to response time (TR) for all selected transactions. For DBCTL threads and TPI, this field is zero. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | QR |
System Abends The number of application program system abends (abend code Sxxx). | Program accounting record data | MSGREGION | SA |
Total Billable Charges The amount of total billable charges. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | XB |
Total CPU Usage for all IMS Regions in Seconds The amount of total IMS CPU. This value includes both chargeable and overhead CPU from all regions: message, control, DLISAS, and DB2. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | TC |
Program accounting record data | MSGREGION | TC | |
Transaction Processing Elapsed Time in Seconds The amount of transaction elapsed time. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | ET |
Transactions Executed The number of transactions processed. | Transaction accounting record data | TRANCODE, MSGREGION, and LTERM | TE |
User Abends The number of application program user abends (abend code Uxxxx). | Program accounting record data | MSGREGION | UA |
Related topic