Print System Report (PRTSYSRPT)

The Print System Report (PRTSYSRPT) command generates and prints a system operation overview report from the performance data collected by Collection Services. The report is written to the printer file QPPTSYSR. The system workload, resource utilization, resource utilization expansion, storage pool utilization, disk utilization, communications summary, TCP/IP summary, HTTP server summary, and cross partitions summary are presented in the report.

Parameters

Keyword Description Choices Notes
MBR Member Name Required, Positional 1
TITLE Report title Character value, *MBR Optional, Positional 3
PERIOD Time period for report Element list Optional
Element 1: Element list
Element 1: Starting time Time, *FIRST, *SELECT
Element 2: Starting date Date, *FIRST
Element 2: Element list
Element 1: Ending time Time, *LAST
Element 2: Ending date Date, *LAST
LIB Library Name, QPFRDATA Optional, Positional 2
TYPE Type of information Single values: *ALL
Other values (up to 9 repetitions): *WORKLOAD, *RSC, *RSCEXPN, *POOL, *DISK, *CMN, *TCPIP, *HTTP, *LPAR
Optional
SLTJOB Select jobs Single values: *ALL
Other values (up to 50 repetitions): Qualified job name
Optional
Qualifier 1: Select jobs Generic name, name
Qualifier 2: User Name
Qualifier 3: Number 000000-999999
OMTJOB Omit jobs Single values: *NONE
Other values (up to 50 repetitions): Qualified job name
Optional
Qualifier 1: Omit jobs Generic name, name
Qualifier 2: User Name
Qualifier 3: Number 000000-999999
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
Optional
OMTPOOLS Omit pools Single values: *NONE
Other values (up to 64 repetitions): 1-64
Optional
SLTSBS Select subsystems Single values: *ALL
Other values (up to 50 repetitions): Name
Optional
OMTSBS Omit subsystems Single values: *NONE
Other values (up to 50 repetitions): Name
Optional
SLTLINE Select communications lines Single values: *ALL
Other values (up to 50 repetitions): Name
Optional
OMTLINE Omit communications lines Single values: *NONE
Other values (up to 50 repetitions): Name
Optional
SLTCTL Select control units Single values: *ALL
Other values (up to 50 repetitions): Name
Optional
OMTCTL Omit control units Single values: *NONE
Other values (up to 50 repetitions): Name
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, PRTSYSRPT, *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

Member (MBR)

Specifies the performance data member used. This name should correspond to the member name specified on the TOMBR parameter of the Create Performance Data (CRTPFRDTA) command.

This is a required parameter.

Report title (TITLE)

Specifies the title for the report that is created.

*MBR
The text of the database member, which contains the performance data, is the report title.
character-value
Specify the title you want on your report with up to 50 characters of text, enclosed in apostrophes.

Time period for report (PERIOD)

Specifies the period of time on which to report. The parameter consists of four elements: a starting time and date, and an ending time and date. Data collected prior to the starting time on the starting date and after the ending time on the ending date is not included in the report.

The symbol *N can be used to designate the default value for any of the four elements.

Element 1: Starting time and date

Element 1: Starting time

*FIRST
Data records starting from the beginning of the first day (00:00:00) of the collection period are included.
*SELECT
An interval selection screen is displayed from which you can select one or more intervals for inclusion. This value is valid only in the interactive environment. If this value is used, the remaining values of this parameter (starting time and date and ending time and date) are ignored.
time
Specify the time of the first data record to include in the report, using the format, hhmm or hhmmss, where hh is the hours, mm is the minutes, and ss is the seconds.

The time is specified in 24-hour format 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: Starting date

*FIRST
Data records starting from the first day of the collection period are included in the report.
date
Specify the date of the first data record to include in the report. The date must be entered in the format specified by the system value QDATFMT, and if separators are used, as specified by the system value QDATSEP.

Element 2: Ending time and date

Element 1: Ending time

*LAST
Data records through the end of the day (23:59:59) are included in the report.
time
Specify the time of the last data record to include in the report. Use the same format used for the starting time.

Element 2: Ending date

*LAST
Data records through the last day of the collection period are included in the report.
date
Specify the date of the last record to include in the report. The date must be entered in the format specified by the system value QDATFMT, and if separators are used, as specified by the system value QDATSEP.

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.

Type of information (TYPE)

Specifies the sections of the report that you want to print.

Single values

*ALL
All sections of the report are printed.

Other values (up to 9 repetitions)

*WORKLOAD
Print the Workload section.
*RSC
Print the Resource Utilization section.
*RSCEXPN
Print the Resource Utilization Expansion section.
*POOL
Print the Storage Pool Utilization section.
*DISK
Print the Disk Utilization section.
*CMN
Print the Communication Summary section. This section shows data about IOP, protocol, line utilization, active devices, transactions, response times and bytes received/transmitted.
*TCPIP
Print the TCP/IP Summary section. This section includes additional data for TCP/IP protocols, such as packets received/transmitted, MTU sizes, etc.
*HTTP
Print the HTTP Server Summary section. This section includes statistics for IBM HTTP Server for i (powered by Apache).
*LPAR
Print the Cross Partitions Summary section. This section includes statistics for the logical partitions recorded in the QAPMLPAR file. If no partition information is available in file QAPMLPAR, only the IBM i collecting partition (the partition running Collection Services) will be reported in this section.

Select jobs (SLTJOB)

Specifies a list of up to 50 jobs to be included in the report. Only specified jobs are included in the report.

Individual jobs are identified by a "job identifier." A job identifier is either the special value *ALL or a qualified name that consists of up to three qualifiers: a job number, a user name, and a job name. Job identifiers are written in the form, job-number/user-name/job-name, but all three qualifiers do not have to be specified. The symbol *N can be used as a placeholder for up to two of the qualifiers of the job identifier.

Note: This parameter and the Omit jobs (OMTJOB) parameter are mutually exclusive.

Single values

*ALL
All jobs in the collected data are included, unless excluded by another selection value.

Other values (up to 50 repetitions)

Element 1: Job name

Qualifier 1: Job name

generic-name
Specify the generic job 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 job name of the job to select. Because jobs may have identical job names, this value may not identify a specific job.

Qualifier 2: User

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.

Qualifier 3: Number

000000-999999
Specify the 6-digit number of a job to select. All six digits must be specified, including zeros.

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 some jobs can have identical thread identifiers, this value may not identify a specific job.

Omit jobs (OMTJOB)

Specifies a list of up to 50 jobs to be omitted from the report.

Individual jobs are identified by a "job identifier." A job identifier is either the special value *NONE or a qualified name that consists of up to three qualifiers: a job number, a user name, and a job name. Job identifiers are written in the form, job-number/user-name/job-name, but all three qualifiers do not have to be specified. The symbol *N can be used as a placeholder for up to two of the qualifiers of the job identifier.

Note: This parameter and the Select jobs (SLTJOB) parameter are mutually exclusive.

Single values

*NONE
Jobs are not excluded based on job identifier.

Other values (up to 50 repetitions)

Element 1: Job name

Qualifier 1: Job name

generic-name
Specify the generic job 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 job name of the job to omit. Because jobs may have identical job names, this value may not identify a specific job.

Qualifier 2: User

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.

Qualifier 3: Number

000000-999999
Specify the 6-digit number of a job to omit. All six digits must be specified, including zeros.

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 some jobs can have identical thread identifiers, this value may not identify a specific job.

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).

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).

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.

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.

Select subsystems (SLTSBS)

Specifies a list of up 50 subsystems to select. Only jobs that ran in one of the specified subsystems are included in the report.

Note: This parameter and the Omit subsystems (OMTSBS) parameter are mutually exclusive.

Single values

*ALL
Jobs in all subsystems are included, unless excluded by another selection value.

Other values (up to 50 repetitions)

name
Specify the name of a subsystem to select.

Omit subsystems (OMTSBS)

Specifies a list of up to 50 subsystems to omit. Jobs that ran in any of the specified subsystems are excluded from the report.

Note: This parameter and the Select subsystems (SLTSBS) parameter are mutually exclusive.

Single values

*NONE
Jobs are not excluded based on their subsystem.

Other values (up to 50 repetitions)

name
Specify the name of a subsystem to omit.

Select communications lines (SLTLINE)

Specifies a list of up to 50 communications lines to select. Only jobs that use a remote device connected through one of the specified communications lines are included in the report.

Note: This parameter and the Omit communications lines (OMTLINE) 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)

name
Specify the name of a communications line to select. This excludes jobs using remote devices connected through other communications lines, even if the controllers to which those devices are attached are specified on the Select control units (SLTCTL) parameter.

Omit communications lines (OMTLINE)

Specifies a list of up to 50 communications lines to omit. Jobs that use a remote device connected through any of the specified communications lines are excluded from the report.

Note: This parameter and the Select communications lines (SLTLINE) parameter are mutually exclusive.

Single values

*NONE
Jobs are not excluded from the report based on communications line.

Other values (up to 50 repetitions)

name
Specify the name of a communications line to omit.

Select control units (SLTCTL)

Specifies a list of up to 50 communications controllers to select. Only jobs that use a device connected to one of the specified controllers are included in the report.

Note: This parameter and the Omit control units (OMTCTL) parameter are mutually exclusive.

Single values

*ALL
All jobs are included, unless excluded by another selection value.

Other values (up to 50 repetitions)

name
Specify the name of a communications controller to select.

Omit control units (OMTCTL)

Specifies a list of up to 50 communications controllers to omit. Jobs that use a device connected to any of the specified controllers are excluded from in the report.

Note: This parameter and the Select control units (SLTCTL) parameter are mutually exclusive.

Single values

*NONE
Jobs are not excluded based on communications controllers.

Other values (up to 50 repetitions)

name
Specify the name of a communications controller to omit.

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.

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.

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.

PRTSYSRPT
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.

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.

Examples

Example 1: Printing a Report

PRTSYSRPT   MBR(APRIL18)  TYPE(*ALL)

These commands print a complete system report for the performance data member APRIL18 in library QPFRDATA. The report title is the same as the text in the member.

Example 2: Selecting Intervals to Include in Report

PRTSYSRPT   MBR(NOV1)  PERIOD(*SELECT)
            TITLE('Intervals with Highest Response Times')

This command prints a system report for the data member NOV1 in library QPFRDATA. The user is presented with the interval-selection screen, which allows sorting of the intervals according to various criteria and the selection of certain intervals to be included in the report. The title of the report is Intervals with Highest Response Times.

Example 3: Selecting Sections to Include in Report

PRTSYSRPT   MBR(NOV1)  TYPE(*DSKUTL)

This command prints only the Disk Utilization section of the system report for the data member NOV1.

Error messages

None