4.2.2 Exporting event data

You can export the event data stored in the Store database to a text file. Use the jpctool db dump command to export data.

1. Log on to the host where PFM - Manager is installed.

2. Execute the jpctool service list command to make sure that the Name Server, Master Manager, and Master Store services are all up and running.

3. Execute the jpctool db dump command.

   For example, of the events in the Store database of the monitoring manager, if you want to export the events collected from 02:00:00 (GMT) to 14:59:00 (GMT) on July 10, 2006 to the file pa.out, use the following command:

   jpctool db dump -id PS* -stime 2006/07/10 02:00 -etime 2006/07/10 14:59 -f pa.out -dbid PA -rec *

   When the command finishes normally, the export file for the event data is created in the following location:

   On physical hosts:

   • In Windows:

     installation-folder\mgr\store\dump\pa.out

   • In UNIX:

     /opt/jp1pc/mgr/store/dump/pa.out

   On logical hosts:

   • In Windows:

     environment-directory\jp1pc\mgr\store\dump\pa.out

   • In UNIX:

     environment-directory/jp1pc/mgr/store/dump/pa.out

To Page Top