CRTPEXDTA (Create Performance Explorer Data)

CRTPEXDTA Command syntax diagram

 

Purpose

The Create Performance Data (CRTPEXDTA) command creates the PEX database files based on the data in a PEX management collection object (object type *MGTCOL).

Additional information about the performance explorer tool can be found in the Performance Tools for iSeries book.

 

Restrictions

1. This command is shipped with PUBLIC *EXCLUDE authority.
   
   
2. The user must have add and execute authority to the specified TOLIB library, and read and execute authority to the FROMLIB library.
   
   
3. The user must have read authority to the management collection object.
   
   
4. To use this command have *SERVICE special authority, or be authorized to the Service Trace function of Operating System/400 through iSeries Navigator's Application Administration support. The Change Function Usage Information (QSYCHFUI) API, with a function ID of QIBM_SERVICE_TRACE, can also be used to change the list of users that are allowed to perform trace operations.
5. The following user profiles have private authorities to use the command:
   
   

• QPGMR
  
  
• QSRV
  
  

 

Required Parameters

FROMMGTCOL

Specifies the name of the PEX management collection object. The data in this object will be stored in the PEX database files in the specified member.

QPEXDATA: The QPEXDATA library is the recommended library for storing data collected by the performance explorer tool. The first time the performance explorer tool is used, this library is created for the user.

data-library-name: Specify the name of the library where the management collection object exists.

management_collection_object-name: Specify the name of the management collection object.

 

Optional Parameters

TOMBR

Specifies the member name used to store the data in the PEX database files. the specified member.

*FROMMGTCOL: The name of the management collection object is used as the member name.

member-name: Specify the name of the member for the database used to store the PEX data.

TOLIB

Specifies the library used to store the data in the PEX database files.

*FROMMGTCOL: The library specified for the management collection object is used.

library-name: Specify the name of the library for the database used to store the PEX data.

RPLDTA

Specifies whether to replace the data in an existing set of file members with new performance data.

*NO: If a member already exists with the same name, an error message is sent to the user. This prevents the user from inadvertently writing over existing data.

*YES: If a member already exists with the same name, the old data is lost and is replaced by the new data.

NBRTHD

Specifies the number of concurrent threads that CRTPEXDTA will use to process the data in the session being ended. Specifying a number greater than 1 will allow CRTPEXDTA to take advantage of available CPU cycles, especially on a multi-processor system. While this may speed up CRTPEXDTA processing, it may also degrade the performance of other jobs on the system. You can minimize this impact by changing the priority of the job that runs CRTPEXDTA to a higher number. You should also verify the disk subsystem can handle the additional threads. Typically, CRTPEXDTA will need at least one disk arm for each active thread.

*CALC: The system will calculate a reasonable number of threads to do the CRTPEXDTA processing which will not use excessive CPU or disk resources. Usually this is one or two threads for each available processor.

'number-of-threads': Specify the number of threads for CRTPEXDTA to use to process the collected data.

TEXT

Specifies the text that briefly describes the type of data collected. More information on this parameter is in Commonly used parameters.

*BLANK: Text is not specified.

'description': Specify no more than 50 characters of text, enclosed in apostrophes.

Example for CRTPEXDTA

Example 1: Creating PEX data

CRTPEXDTA FROMMGTCOL(QAPEXDTA/MYCOL) TOMBR(TEST)
TOLIB(QAPEXDTA) NBRTHD(2)

This command creates PEX data in member name TEST in library QAPEXDATA. The collected data exists in the management collection object found in QAPEXDTA/MYCOL. Two threads will be used to process the data.

Error messages for CRTPEXDTA

*ESCAPE Messages