Create Performance Data (CRTPFRDTA)
Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
The Create Performance Data (CRTPFRDTA) command creates a set of performance database files from performance information stored in a management collection (*MGTCOL) object. For more information about the database files, see the Performance topic in the IBM i Information Center at http://www.ibm.com/systems/i/infocenter/.
Performance database files and file members will be created as needed based on the data contained in the management collection object and the information requested on this command. If database files already exist and the requested member exists in any of them, the member will be cleared before the collection is generated.
Top |
Parameters
Keyword | Description | Choices | Notes |
---|---|---|---|
FROMMGTCOL | From collection | Single values: *ACTIVE Other values: Qualified object name |
Required, Positional 1 |
Qualifier 1: From collection | Name, *SELECT | ||
Qualifier 2: Library | Name, QPFRDATA | ||
TOMBR | To member | Name, *FROMMGTCOL | Optional |
TOLIB | To library | Name, *FROMMGTCOL | Optional |
TEXT | Text 'description' | Character value, *SAME, *FROMMGTCOL, *GEN, *BLANK | Optional |
CGY | Categories to process | Single values: *FROMMGTCOL Other values (up to 32 repetitions): Name, *APPN, *CMNBASE, *CMNSAP, *CMNSTN, *DISK, *DOMINO, *DPS, *EXTSTG, *HDWCFG, *HTTP, *IOPBASE, *IPCS, *JOBMI, *JOBOS, *JAVA, *LCLRSP, *LPAR, *POOL, *POOLTUNE, *RMVSTG, *SNA, *SNADS, *SQL, *SUBSYSTEM, *SYSBUS, *SYSCPU, *SYSINT, *SYSLVL, *TCPBASE, *TCPIFC, *USRTNS, *WAS |
Optional |
INTERVAL | Time interval (in minutes) | *FROMMGTCOL, 0.25, 0.5, 1.0, 5.0, 15.0, 30.0, 60.0 | Optional |
CRTPFRSUM | Create standard summary data | Single values: *NONE, *ALL Other values (up to 2 repetitions): *PFRSUM, *SYSMON |
Optional |
FROMTIME | Starting date and time | Single values: *FROMMGTCOL Other values: Element list |
Optional |
Element 1: Starting date | Date | ||
Element 2: Starting time | Time | ||
TOTIME | Ending date and time | Single values: *FROMMGTCOL, *ACTIVE Other values: Element list |
Optional |
Element 1: Ending date | Date | ||
Element 2: Ending time | Time |
Top |
From collection (FROMMGTCOL)
Specifies the management collection from which a set of performance database files is to be created.
Single values
- *ACTIVE
- The currently active collection object will be used.
- *SELECT
- Lists all the collection objects available in the specified library so the user can select which collection object to process. This is only Allowed if the command is run in an interactive job.
Qualifier 1: From collection
- name
- Specify the name of the management collection object that is to be used.
Qualifier 2: Library
- QPFRDATA
- IBM-supplied performance data library QPFRDATA is to be used to locate the management collection.
- name
- Specify the name of the library for the management collection.
Top |
To member (TOMBR)
Specifies the database file member to which the output data is to be written. If a member by this name does not exist in each performance database file, one will be created with the specified name.
- *FROMMGTCOL
- The name of the management collection object is used as the performance database file member name.
- name
- Specify the name of the member to which the output should be written.
Top |
To library (TOLIB)
Specifies the library where the database files for performance data are to exist. Each file that is not found in the specified library is automatically created in that library.
- *FROMMGTCOL
- The performance database files are located or created in the same library as the management collection object (FROMMGTCOL parameter).
- name
- Specify the name of the library where the performance database files are located or should be created.
Top |
Text 'description' (TEXT)
Specifies the text to be used for each member across the set of performance data base files associated with the collection.
- *SAME
- The value does not change.
- *FROMMGTCOL
- Text associated with the management collection object is used as the member text.
- *GEN
- The following text will be generated - "Created from <collection name> in library <library name>". If the member already exists, no change is made.
- *BLANK
- No text is specified.
- character-value
- Specify no more that 50 characters of text, enclosed in apostrophes.
Top |
Categories to process (CGY)
Specifies the categories in the management collection object which will be processed into database files.
Single values
- *FROMMGTCOL
- All of the categories present in the management collection object will be processed into database files.
Other values (up to 32 repetitions)
- category-name
- Specify the name of the category of performance information to be processed from the management collection object. Multiple category names may be specified. Valid category names are:
Name Description ------------- --------------------------- *APPN APPN *CMNBASE Communications (base) *CMNSAP Communications (SAP) *CMNSTN Communications (station) *DISK Disk storage *DOMINO IBM Domino for i *DPS Data port services *EXTSTG External storage *HDWCFG Hardware configuration *HTTP IBM HTTP Server for i (powered by Apache) *IOPBASE Input/output processors (base) *IPCS Network server *JOBMI Jobs (MI tasks and threads) *JOBOS Jobs (operating system) *JAVA Java *LCLRSP Local response time *LPAR Logical partition *POOL Memory pool *POOLTUNE Memory pool tuning *RMVSTG Removable storage *SNA SNA *SNADS SNADS *SUBSYSTEM Subsystem *SYSBUS System bus *SYSCPU System CPU *SYSINT System internal data *SYSLVL System-level data *SQL SQL *TCPBASE TCP/IP (base) *TCPIFC TCP/IP (interface) *USRTNS User-defined transaction data *WAS Websphere Application Server
Top |
Time interval (in minutes) (INTERVAL)
Specifies the time interval between successive entries in the database file(s). Within the database, these collection intervals will be identified by interval number and interval time.
Interval numbers will begin with 1 and increment with each interval. Interval time will be based on time at the end of the interval synchronized to the clock time (e.g. if INTERVAL(15) is specified, intervals could be generated as 01:00:00, 01:15:00, 01:30:00, and 01:45:00).
- *FROMMGTCOL
- The default interval from the management collection object will be used.
- number-of-minutes
- Specify an interval value ranging from 0.25 (15 seconds) through 60 minutes.
Top |
Create standard summary data (CRTPFRSUM)
Specifies whether or not to create additional summary type data for this collection.
Single values
- .*NONE
- Summary file data is not generated.
- *ALL
- All Summary file data is generated.
Other values (up to 2 repetitions)
- *PFRSUM
- This option creates additional logical files as supported by the CRTPFRSUM command to improve the SQL performance of functions like the Performance Data Investigator.
- *SYSMON
- This option causes additional system monitoring database files to be created. These files summarize various category data and are necessary to use the system monitoring perspectives within the Performance Data Investigator. Creating these files allows the use of those perspectives with this collection.
Top |
Starting date and time (FROMTIME)
Specifies the starting date and time of the performance data in the management collection object which will be used to create the performance database file(s). This time combined with the interval value will determine the date and time for each data base interval.
Single values
- *FROMMGTCOL
- The starting date and time is the date and time that the management collection object was created.
Element 1: Starting date
- date
- Specify the starting date for which collection data is generated. The date must be entered in the format specified by the system values QDATFMT and, if separators are used, QDATSEP.
Element 2: Starting time
- time
- Specify the starting time on the specified starting date for generating the database intervals.
If the starting date is specified and the starting time is not, the starting time will default as follows:
- If the starting date specifies the first date of the collection, the starting time will be set to the start time of the collection.
- If the starting date does not specify the first date of the collection, the starting time will be set to midnight (00:00:00).
Top |
Ending date and time (TOTIME)
Specifies the ending date and time of the last performance data in the management collection object which will be used to create the performance database file(s).
Single values
- *FROMMGTCOL
- The date and time of the end of the collection in the management collection object will be the ending date and time for data base generation.
- *ACTIVE
- The generation of the data base will continue until the currently active collection ends.
This option causes the data base to be generated concurrently with the active collection. The data base will be generated based on the start time specified for any data currently in the management collection object. Additional data will be processed as it is added to the collection object. This will continue until the current collection ends.
Because this option can result in processing for a very long time, it is recommended that TOTIME(*ACTIVE) be specified only when running CRTPFRDTA in a batch job.
Element 1: Ending date
- date
- Specify the ending date for which data from the collection object is used to generate the data base files. The date must be entered in the format specified by the system values QDATFMT and, if separators are used, QDATSEP.
Element 2: Ending time
- time
- Specify the time for the specified ending date for which data from the collection object is used to generate the data base files.
See the description of the Starting time element of the Starting date and time (FROMTIME) parameter for details about how time values can be specified.
If the ending date is specified and the ending time is not, the ending time will default as follows:
- If the ending date specifies the last date of the collection, the ending time will be set to the ending time of the collection.
- If the ending date does not specify the last date of the collection, the ending time will be set to 23:59:59.
Top |
Examples
Example 1: Generating All Data
CRTPFRDTA FROMMGTCOL(Q099365001) TOMBR(JAN1) TOLIB(MYLIB)
In this example, the database is generated for all categories contained within the management collection object Q099365001 in library QPFRDATA. The performance database files will be created into library MYLIB and the collection member name will be JAN1.
Data is generated from the start of data collection within this management collection object to the end of that collection. The database interval is the default collection interval that was specified at the time the collection was started.
Example 2: Selecting Specific Data
CRTPFRDTA FROMMGTCOL(Q099364002) TOMBR(JAN1J) TOLIB(MYLIB) CGY(*JOBMI) INTERVAL(15) FROMTIME(('01/01/98' '14:00:00')) TOTIME(('01/01/98' '16:00:00'))
In this example, only the database file QAPMJOBMI is generated using *JOBMI category information from management collection Q099364002 in library QPFRDATA. The database interval will be 15 minutes even if the data was collected more frequently (for example, the management collection object may contain data collected every 5 minutes). The generated file will contain only data that was collected between 2:00 PM and 4:00 PM even though the collection object may contain data for a larger time interval.
Top |
Error messages
*ESCAPE Messages
- CPF0A0E
- CRTPFRDTA ended. No files changed.
- CPF0A1A
- No active collection.
- CPF0A2B
- Not able to process management collection object &1 in library &2.
- CPF9801
- Object &2 in library &3 not found.
- CPF9810
- Library &1 not found.
Top |