To update a monitoring target, check the name of the monitoring target that you want to update, and change the monitoring target information. Update a monitoring target on a PFM - RM host.
Before you change an information item, check the following table. For details about Microsoft SQL Server instance information, see your Microsoft SQL Server documentation.
Table 2-11 Monitoring target information of PFM - RM for Microsoft SQL Server
Item | Description | Specifiable value | Default value |
---|---|---|---|
TARGET_HOST | This item is updatable. Microsoft SQL Server host name for a monitoring target. If the Microsoft SQL Server host is a logical host, specify the logical host. | Host names can consist of 1 to 32 alphanumeric characters and hyphen. Note that you cannot specify a (logical) host name beginning with a hyphen. Physical and logical host names must be unique within the system. | Previous value |
SQL_INSTANCE | This item is updatable. The instance name for monitoring target. | Specifiable value varies depending on how you install Microsoft SQL Server:
| Previous value |
SQL_USER | This item is updatable. Specifies the user name for Microsoft SQL Server authentication. | The user account that has permissions equivalent to sa (the account of a member who has the sysadmin fixed server role). If you specify other user name, see 2.1.4(2)(d) Login permissions of the Microsoft SQL Server. | Previous value |
SQL_PASSWORD | This item is updatable. Specifies the password of the Microsoft SQL Server user used for Microsoft SQL Server authentication. | The password for SQL_USER. | Previous value |
TIMEOUT | This item is updatable. Specifies the query timeout value for database access. | 1 to 3,600 (seconds) | Previous value |
LOGIN_TIMEOUT | This item is updatable. Specifies the access timeout value for database access. The value is in seconds. | 1 to 3,600 (seconds) | Previous value |
DB_FREE_PERC_OPTION | This item is updatable. Specify how to display the value of Free % field in the PD_DS record when the value is negative. | {Y | N} If Y is specified, the value of DB_FREE_PERC_NUMBER is displayed as the value of Free % field when its value is negative. If N is specified, the value of Free % field is displayed as it is when its value is negative. | Previous value |
DB_FREE_PERC_NUMBER | This item is updatable. Specify the value to replace the value of Free % in the PD_DS record when its value is negative. The replacement is enabled only when the value of DB_FREE_PERC_OPTION is Y. | -1 to 999 | Previous value |
LIMIT_PD_LD_NUMBER | This item is updatable. Specify the maximum number of collection records for the PD_LD record. | 0 to 900,000 If you specify 0, no upper limit is set, and all data is collected. | Previous value |
To check the monitoring target name, use the jpcconf target list command. To update a monitoring target, use the jpcconf target setup command.
The following procedure shows how to update a monitoring target. If you want to update multiple monitoring target, repeat the procedure for each monitoring target.
jpcconf target list -key RMSQL -inst instance-name
Targets:
targethost1
targethost2
Groups:
All
# jpcconf target setup -key RMSQL -inst instance-name -target targethost1
For details about commands, see the chapter on commands in the manual Job Management Partner 1/Performance Management Reference.