Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


2.4.1 Changing the storage location of performance data

The performance data collected by PFM - RM for Microsoft SQL Server is managed by using the Store database for the Remote Monitor Store service of PFM - RM for Microsoft SQL Server.

By executing jpcconf db define command, you can change the following storage folders for performance data managed by the Store database:

Use the jpcconf db define command with -move option if you want to copy the performance data to the new storage location of the Store database.

For details about the jpcconf db define command, see the manual JP1/Performance Management Reference.

The following table describes the options of the jpcconf db define command, including the values that can be specified.

Table 2‒14: Settings related to the storage locations of performance data

Description

Option name

Specifiable value#1

Default#2

The folder in which performance data is stored

sd

Folder name, from 1 to 214 bytes

installation-folder\agt4\store\instance-name

The folder to which performance data is backed up

bd

Folder name, from 1 to 211 bytes

installation-folder\agt4\store\instance-name\backup

The folder to which performance data is partially backed up

pbd

Folder name, from 1 to 214 bytes

installation-folder\agt4\store\instance-name\partial

The maximum number of generations of performance data to be backed up

bs

1 to 9

5

The folder to which performance data is exported

dd

Folder name, from 1 to 127 bytes

installation-folder\agt4\store\instance-name\dump

The folder to which performance data is imported

id

Folder name, from 1 to 222 bytes

installation-folder\agt4\store\instance-name\import

#1

You must specify as the folder name either the relative path name from the default storage folder for the Store database (installation-folder\agt4\instance-name) or the absolute path name.

#2

For the default save destination for logical host operation, replace installation-folder with environment-folder\jp1pc.