4.1.4 Exporting performance data
You can export the performance data stored in the Store database to a text file. Use the jpctool db dump command to export data.
The purpose of this command is to output performance data to a text file. The file it creates cannot be imported using the jpctool db import command.
-
Log on to the host that has PFM - Agent or PFM - RM installed.
-
Execute the jpctool service list command to make sure that the Name Server, Master Manager, and Master Store services are running.
-
Execute the jpctool db dump command.
For example, if you want to export to the file named pcsr.out that contains the performance data collected from 02:00:00 (GMT) to 14:59:00 (GMT) on July 10, 2006, which is stored in the Processor Overview (PI_PCSR) record on PFM - Agent for Platform (Windows) host host02, use the following command:
jpctool db dump -id TS* -host host02 -stime 2006/07/10 02:00 -etime 2006/07/10 14:59 -f pcsr.out -dbid PI -rec PCSR
When the command finishes normally, the export file for the performance data is created in the following location:
On physical hosts:
-
In Windows:
environment-directory\jp1pc\xxxx#1\store[\instance-name]#2\dump\pcsr.out
-
In UNIX:
environment-directory/jp1pc/xxxx#1/store[/instance-name]#2/dump/pcsr.out
- #1
-
xxxx indicates the service key of PFM - Agent or PFM - RM. Every PFM - Agent or PFM - RM has a specific service key, such as agto for PFM - Agent for Oracle and agtt for PFM - Agent for Platform (Windows). For details on service keys, see the description of the naming rules in an appendix of the JP1/Performance Management Planning and Configuration Guide.
- #2
-
If PFM - Agent or PFM - RM is monitoring an application program that can start multiple service sets on a host, there is one more directory created under the Store directory bearing the same name as the instance name.
-