Print Transaction Report (PRTTNSRPT)
| Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
The Print Transaction Report (PRTTNSRPT) command creates and prints performance reports that show detailed information about the transactions that occurred during the time that the performance data was collected. These reports require that trace data be collected by using the Start Performance Trace (STRPFRTRC) command. Jobs may be selectively included or excluded from the reports, based on a variety of job details and interval times.
| Top |
Parameters
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| MBR | Member | Name | Required, Positional 1 |
| TITLE | Report title | Character value, *BLANK | Optional, Positional 3 |
| RPTTYPE | Report type | Values (up to 5 repetitions): *SUMMARY, *TNSACT, *TRSIT, *FILE, *TRCDTA | Optional, Positional 4 |
| PERIOD | Time period for report | Element list | Optional |
| Element 1: | Element list | ||
| Element 1: Starting time | Time, *FIRST | ||
| Element 2: | Element list | ||
| Element 1: Ending time | Time, *LAST | ||
| LIB | Library | Name, QPFRDATA | Optional, Positional 2 |
| OPTION | Report option | Values (up to 7 repetitions): *SS, *SI, *OZ, *EV, *HV, *DI, *DQ, ' ' | Optional |
| DETAIL | Report detail | *JOB, *THREAD | Optional |
| SLTJOB | Select jobs | Single values: *ALL Other values (up to 50 repetitions): Element list |
Optional |
| Element 1: Job name | Character value | ||
| Element 2: | Element list | ||
| Element 1: Thread | Character value, *ALL | ||
| OMTJOB | Omit jobs | Single values: *NONE Other values (up to 50 repetitions): Element list |
Optional |
| Element 1: Job name | Character value | ||
| Element 2: | Element list | ||
| Element 1: Thread | Character value, *ALL | ||
| SLTUSRID | Select users | Single values: *ALL Other values (up to 50 repetitions): Generic name, name |
Optional |
| OMTUSRID | Omit users | Single values: *NONE Other values (up to 50 repetitions): Generic name, name |
Optional |
| SLTPOOLS | Select pools | Single values: *ALL Other values (up to 64 repetitions): 1-64, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
Optional |
| OMTPOOLS | Omit pools | Single values: *NONE Other values (up to 64 repetitions): 1-64, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
Optional |
| SLTFCNARA | Select functional areas | Single values: *ALL Other values (up to 50 repetitions): Character value |
Optional |
| OMTFCNARA | Omit functional areas | Single values: *NONE Other values (up to 50 repetitions): Character value |
Optional |
| JOB | Job name | Name, PRTTNSRPT, *MBR | Optional |
| JOBD | Job description | Single values: *NONE Other values: Qualified object name |
Optional |
| Qualifier 1: Job description | Name, QPFRJOBD | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB |
| Top |
Member (MBR)
Specifies the performance data member used. This name should correspond to the member name specified on the MBR parameter of the End Performance Trace (ENDPFRTRC) command.
This is a required parameter.
| Top |
Report title (TITLE)
Specifies the title for the transaction report that is created.
- *BLANK
- No title is placed on the transaction report.
- character-value
- Specify the title you want on your transaction report. Specify up to 50 characters enclosed in apostrophes.
| Top |
Report type (RPTTYPE)
Specifies the type of transaction analysis report that is printed. A list of report types can be requested, so that both summary level and transaction detail reports can be requested at the same time. The transaction detail and transition detail reports are quite detailed, and should only be combined with a selection of specific jobs, users, and/or time intervals.
- *SUMMARY
- A summary level report is printed.
- *TNSACT
- The transaction detail report is printed.
- *TRSIT
- The transition detail report is printed.
- *FILE
- Transaction summary, job summary, and job trace database file members are created. The summaries exist in the files QTRTSUM, QTRJSUM, and QTRJOBT in the library specified for the Library (LIB) parameter. The member names are specified on the Member (MBR) parameter. The data in an existing member is replaced as a result of running this command. This value is used to build field level database files that are processed by user-defined programs and the Print Job Trace Report (PRTTRCRPT) command.
- *TRCDTA
- A database file version of the trace data file QAPMDMPT is created. The database file is named QTRDMPT and is a field-level database file which can be processed by user-defined programs.
| Top |
Time period for report (PERIOD)
Specifies the times when transactions are reported.
Element 1: Starting time
Element 1: Starting time
- *FIRST
- Transactions are reported beginning with the first one recorded.
- time
- Specify the time of the first transaction to include in the report. The time is specified as 4 or 6 digits (hhmm or hhmmss), where hh is the hour, mm is the minute, and ss is the second.
The time can be specified with or without a time separator:
- Without a time separator, specify a string of 4 or 6 digits (hhmm or hhmmss) where hh = hours, mm = minutes, and ss = seconds.
- With a time separator, specify a string of 5 or 8 digits where the time separator specified for your job is used to separate the hours, minutes, and seconds. If you enter this command from the command line, the string must be enclosed in apostrophes. If a time separator other than the separator specified for your job is used, this command will fail.
Element 2: Ending time
Element 1: Ending time
- *LAST
- Transactions are reported ending with the last one recorded.
- time
- Specify the time of the last transaction to include in the report. The time is specified as 4 or 6 digits (hhmm or hhmmss), where hh is the hour, mm is the minute, and ss is the second.
The time can be specified with or without a time separator:
- Without a time separator, specify a string of 4 or 6 digits (hhmm or hhmmss) where hh = hours, mm = minutes, and ss = seconds.
- With a time separator, specify a string of 5 or 8 digits where the time separator specified for your job is used to separate the hours, minutes, and seconds. If you enter this command from the command line, the string must be enclosed in apostrophes. If a time separator other than the separator specified for your job is used, this command will fail.
| Top |
Library (LIB)
Specifies the library where the performance data is located.
- QPFRDATA
- The performance data files are located in the IBM-supplied performance data library, QPFRDATA.
- name
- Specify the name of the library where the performance database files are located.
| Top |
Report option (OPTION)
Specifies additional options that you apply to the transaction report.
- *SS
- An additional set of system summary reports are included. These reports are included if *SUMMARY is specified on the Report type (RPTTYPE) parameter.
- *SI
- All jobs of type interactive are selected.
- *OZ
- All jobs that have zero transactions are omitted from the *SUMMARY report.
- *EV
- Event wait is considered as a transaction boundary. This is useful in the analysis of communications jobs.
- *HV
- System Licensed Internal Code (SLIC) tasks are listed on the *SUMMARY report.
- *DI
- The trace records for the display I/O transaction boundary are counted as transactions, instead of wait-to-active state transitions.
- *DQ
- The trace records for the data queue transaction boundary are counted as transactions, instead of wait-to-active state transitions.
| Top |
Report detail (DETAIL)
Specifies whether you want the report to provide detailed job information at the job level or the thread level.
- *JOB
- Specifies that you want detailed information at the job level.
- *THREAD
- Specifies that you want detailed information at the thread level.
| Top |
Select jobs (SLTJOB)
Specifies which jobs are included in the report. This allows the user to narrow the scope of the report to certain jobs through job selection.
The Select jobs (SLTJOB) parameter and Omit jobs (OMTJOB) parameter are mutually exclusive, so the default must be used for at least one of them.
Single values
- *ALL
- All jobs are included in the report.
Other values (up to 50 repetitions)
Element 1: Job name
- character-value
- Specify the jobs that are included in the report. A generic job name may be specified in the form, NAME*.
Note: The job name is not a fully qualified job name. It is the ten-character job name portion of the qualified name. The job number is allowed on this parameter. You cannot mix the use of job name and job number, one or the other must be used on a given request.
Element 2: Thread
Element 1: Thread
- *ALL
- All threads are included, unless excluded by some other selection criterion.
- character-value
- Specify the thread identifier to select. Because multiple jobs can have identical thread identifiers, this value may not identify a specific job.
| Top |
Omit jobs (OMTJOB)
Specifies which jobs are omitted from the report. This allows the user to narrow the scope of the report to certain jobs through job omission.
The Select jobs (SLTJOB) parameter and Omit jobs (OMTJOB) parameter are mutually exclusive, so the default must be used for at least one of them.
Single values
- *NONE
- No jobs are excluded from the report.
Other values (up to 50 repetitions)
Element 1: Job name
- character-value
- Specify the job names that are excluded from the report. A generic job name may be specified in the form, NAME*.
Note: The job name is not a fully qualified job name. It is the ten-character job name portion of the qualified name. The job number is allowed on this parameter. You cannot mix the use of the job name and job number, one or the other must be used on a given request.
Element 2: Thread
Element 1: Thread
- *ALL
- All threads are excluded, unless included by some other selection criterion.
- character-value
- Specify the thread identifier to omit. Because multiple jobs can have identical thread identifiers, this value may not identify a specific job.
| Top |
Select users (SLTUSRID)
Specifies a list of up to 50 user names to be included in the report. Only jobs with one of the specified user names are included in the report.
Note: This parameter and the Omit users (OMTUSRID) parameter are mutually exclusive.
Single values
- *ALL
- All jobs with user names are included, unless excluded by another selection value.
Other values (up to 50 repetitions)
- generic-name
- Specify the generic user name of the jobs to select.
Note: A generic name is a character string that contains one or more characters followed by an asterisk(*), for example, ABC*. The asterisk substitutes for any valid characters. A generic name specifies all objects with names that begin with the generic prefix for which the user has authority. If an asterisk is not included with the generic name, the system assumes it to be the complete object name.
- name
- Specify the user name of the jobs to select. Because jobs may have identical user names, this value may not identify a specific job. SLTUSRID(user) is equivalent to SLTJOB(*N/user/*N).
| Top |
Omit users (OMTUSRID)
Specifies a list of up to 50 user names to be omitted from the report.
Note: This parameter and the Select users (SLTUSRID) parameter are mutually exclusive.
Single values
- *NONE
- No jobs are excluded based on the user name.
Other values (up to 50 repetitions)
- generic-name
- Specify the generic user name of the jobs to omit.
Note: A generic name is a character string that contains one or more characters followed by an asterisk(*), for example, ABC*. The asterisk substitutes for any valid characters. A generic name specifies all objects with names that begin with the generic prefix for which the user has authority. If an asterisk is not included with the generic name, the system assumes it to be the complete object name.
- name
- Specify the user name of the jobs to omit. Because jobs may have identical user names, this value may not identify a specific job. OMTUSRID(user) is equivalent to OMTJOB(*N/user/*N).
| Top |
Select pools (SLTPOOLS)
Specifies a list of up to 64 pools to be included in the report.
Note: This parameter and the Omit pools (OMTPOOLS) parameter are mutually exclusive.
Single values
- *ALL
- Jobs that ran in all pools are included, unless excluded by another selection value.
Other values (up to 64 repetitions)
- 1-64
- Specify the number of a pool to select.
| Top |
Omit pools (OMTPOOLS)
Specifies a list of up to 64 pools to omit. Jobs that ran in any of the specified pools are excluded from the report.
Note: This parameter and the Select pools (SLTPOOLS) parameter are mutually exclusive.
Single values
- *NONE
- Jobs are not excluded based on their pool.
Other values (up to 64 repetitions)
- 1-64
- Specify the number of a pool to omit.
| Top |
Select functional areas (SLTFCNARA)
Specifies a list of up to 50 functional areas to select. Only jobs and users identified in one of the functional areas are included in the report.
A functional area is a list of job names and/or user names previously defined by the user. More information on functional areas is in the IBM Performance Tools for i book.
Note: This parameter and the Omit functional areas (OMTFCNARA) parameter are mutually exclusive.
Single values
- *ALL
- All jobs are included in the report, unless excluded by another selection value.
Other values (up to 50 repetitions)
- character-value
- Specify the name of a functional area to select.
| Top |
Omit functional areas (OMTFCNARA)
Specifies a list of up to 50 functional areas to omit. Jobs and users identified in any of the functional areas are excluded from the report.
A functional area is a list of job names and/or user names previously defined by the user. More information on functional areas is in the IBM Performance Tools for i book.
Note: This parameter and the Select functional areas (SLTFCNARA) parameter are mutually exclusive.
Single values
- *NONE
- Jobs are not excluded from the report based on functional area.
Other values (up to 50 repetitions)
- character-value
- Specify the name of a functional area to omit.
| Top |
Job name (JOB)
Specifies the job name to be used if submitting the job for batch processing.
Any value for this parameter is ignored if *NONE is specified for the Job description (JOBD) parameter.
Note: If JOBD(*NONE) is specified, job processing is performed interactively.
- PRTTNSRPT
- The command name is used for the job name.
- *MBR
- The name selected for the performance data member in the Member (MBR) parameter is used.
- name
- Specify the name to be used for any and all batch jobs.
| Top |
Job description (JOBD)
Specifies the job description used to submit the job for batch processing.
Single values
- *NONE
- A batch job is not submitted; processing continues interactively while the user waits. The user's workstation is not available for other use during this time, which could be significant for long jobs.
Qualifier 1: Job description
- QPFRJOBD
- The IBM-supplied job description, QPFRJOBD, is used.
- name
- Specify the name of the job description to be used.
Qualifier 2: Library
- *LIBL
- All libraries in the job's library list are searched until the first match is found.
- *CURLIB
- The current library for the job is used to locate the job description. If no current library entry exists in the library list, QGPL is used.
- name
- Specify the library in which the job description is located.
| Top |
Examples
Example 1: Printing a Summary Transaction Report
PRTTNSRPT MBR(TUESAM)
This command produces a summary transaction report. The data input to the report is all the data that exists in member TUESAM in library QPFRDATA. The request is sent to batch. The report output is directed to the output queue specified in the job description, QPFRJOBD.
Example 2: Printing a Transaction Detail Report
PRTTNSRPT MBR(TUESAM) RPTTYPE(*TNSACT) SLTJOB(WS01)
This command produces a transaction detail report for the selected job, WS01. The request is sent to batch. The report output is directed to the output queue specified in the job description, QPFRJOBD.
| Top |
Error messages
None
| Top |