2.4.1 Changing the storage location of performance data
The performance data collected by PFM - Agent for Microsoft SQL Server is managed by using the Store database for the Remote Monitor Store service of PFM - Agent for Microsoft SQL Server.
- Organization of this subsection
(1) Using the jpcconf db define command to change settings
The Store database uses the following folders to manage the collected performance data. These folders can be changed by using the jpcconf db define command. If you need the performance data collected before the Store database storage location is changed, execute the jpcconf db define command with the -move option specified. For details about the jpcconf db define command, see the manual JP1/Performance Management Reference.
-
Save folder
-
Backup folder
-
Partial backup destination folder#
-
Export folder
-
Import destination folder#
- #
-
This folder can be set only when the Store version is 2.0.
The following table describes the options of the jpcconf db define command, including the values that can be specified.
Description |
Option name |
Specifiable value (Store 1.0)#1 |
Specifiable value (Store 2.0)#1 |
Default#2 |
---|---|---|---|---|
The folder in which performance data is stored |
sd |
Folder name, from 1 to 127 bytes |
Folder name, from 1 to 214 bytes |
installation-folder\agtq\store\instance-name |
The folder to which performance data is backed up |
bd |
Folder name, from 1 to 127 bytes |
Folder name, from 1 to 211 bytes |
installation-folder\agtq\store\instance-name\backup |
The folder to which performance data is partially backed up |
pbd |
-- |
Folder name, from 1 to 214 bytes |
installation-folder\agtq\store\instance-name\partial |
The maximum number of generations of performance data to be backed up |
bs |
1 to 9 |
1 to 9 |
5 |
The folder to which performance data is exported |
dd |
Folder name, from 1 to 127 bytes |
Folder name, from 1 to 127 bytes |
installation-folder\agtq\store\instance-name\dump |
The folder to which performance data is imported |
id |
-- |
Folder name, from 1 to 222 bytes |
installation-folder\agtq\store\instance-name\import |
- Legend:
-
--: This item cannot be set.
- #1
-
You must specify as the folder name either the relative path name from the default storage folder for the Store database (installation-folder\agtq\store\instance-name) or the absolute path name.
- #2
-
For the default save destination for logical host operation, replace installation-folder with environment-folder\jp1pc.
(2) Editing the jpcsto.ini file to change settings (for Store version 1.0 only)
If the Store version is 1.0, you can directly edit the jpcsto.ini file to change the settings of the above items.
(a) Setting items in jpcsto.ini
The following table lists the label names for which information can be edited in the jpcsto.ini file, and other information such as the values that can be specified.
Description |
Label name |
Specifiable value (Store 1.0)#1 |
Default#2 |
---|---|---|---|
The folder in which performance data is stored |
Store Dir#3 |
Folder name, from 1 to 127 bytes |
installation-folder\agtq\store\instance-name |
The folder to which performance data is backed up |
Backup Dir#3 |
Folder name, from 1 to 127 bytes |
installation-folder\agtq\store\instance-name\backup |
The maximum number of generations of performance data to be backed up |
Backup Save |
1 to 9 |
5 |
The folder to which performance data is exported |
Dump Dir#3 |
Folder name, from 1 to 127 bytes |
installation-folder\agtq\store\instance-name\dump |
- #1
-
-
The folder name must be an absolute path name or a relative path name from the default Store database folder (installation-folder\agtq\store).
-
Characters that can be specified are alphanumeric characters, symbols, and spaces, excluding the characters listed below:
; , * ? ' " < > |
-
If the specified value is invalid, the Agent Store service cannot start.
-
- #2
-
For the default save destination for logical host operation, replace installation-folder with environment-folder\jp1pc.
- #3
-
You cannot specify the same folders for Store Dir, Backup Dir, and Dump Dir.
(b) Before editing the jpcsto.ini file
-
When changing the Store database folder, make sure that the folder after the change has already been created.
-
When the Store database folder is changed, performance data collected before the change can no longer be used. If the performance data collected before the change is needed, carry the data over as follows:
-
Use the jpctool db backup command to back up the performance data stored in the Store database.
-
Change the Store database folder as described in (c) Editing the jpcsto.ini file.
-
Use the jpctool db restore command to restore the backed up data into the new folder.
-
(c) Editing the jpcsto.ini file
To edit the jpcsto.ini file:
-
Stop the PFM - Agent service.
If PFM - Agent programs and services are active on the local host, stop them all.
-
Use a text editor, for example, to open the jpcsto.ini file.
-
Change the storage destination folder for performance data, for example.
Modify the shaded areas below as needed.
- Important
-
-
Do not insert a space at the beginning of the line or before or after the equal sign (=).
-
(.) in each label value indicates the default storage destination folder (installation-folder\agtq\store) for the Store database of the Agent Store service. To change the storage destination, specify a relative path from the storage destination folder, or specify an absolute path.
-
The jpcsto.ini file also describes definition information in addition to the database storage destination folder. Therefore, do not change the values other than those in the [Data Section] section. If you change the values other than those in the [Data Section] section, Performance Management might not operate normally.
-
-
Save and close the jpcsto.ini file.
-
Start the Performance Management programs and services.
- Note:
-
When you use this procedure to change the Store database folder, the performance data files are not deleted from the previous folder. If these files are no longer necessary, delete only the following files:
-
All files with the .DB extension
-
All files with the .IDX extension
-