Create Performance Data (CRTPFRDTA)

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.

Parameters

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.

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.

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.

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.

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

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.

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.

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

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.

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.

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.