2.4.2 Updating a monitoring target

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‒15: 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. (A character string of 16 or fewer bytes.)	Specifiable value varies depending on how you install Microsoft SQL Server: If you install Microsoft SQL Server by default: [`default`] If you install Microsoft SQL Server and specify the instance name: [`the instance name you specified`]	Previous value
`SQL_USER`	This item is updatable. Specifies the user name for Microsoft SQL Server authentication. (A character string of 128 or fewer bytes.)	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
`DRIVER_NAME`	Specifies the driver name used for communication with Microsoft SQL Server. Change the name when monitoring Microsoft SQL Server version 2016 or later and encrypting communication using the monitored Microsoft SQL Server settings. Specifies the default `SQL Server` (Windows standard driver) when monitoring Microsoft SQL Server 2014 or earlier, or when monitoring Microsoft SQL Server 2016 or later and communicating in plaintext.	`{SQL Server \| SQL Server Native Client 11.0 \| ODBC Driver 17 for SQL Server}`	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 values of the fields related to the percentage of free space in the `PD_DS` record (the Free % field and the Data Unallocate % field) when the value is negative.	`{Y` `\|` `N}` If `Y` is specified, the value specified for `DB_FREE_PERC_NUMBER` is displayed. If `N` is specified, the value of the Free % field and the Data Unallocate % field is displayed as it is when its value is negative.	Previous value
`DB_FREE_PERC_NUMBER`	This item is updatable. Specify the values of the fields related to the percentage of free space in the `PD_DS` record(the Free % and the Data Unallocate % field) 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

Legend:: --: No limit

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.

Check the monitoring target name.

Execute the jpcconf target list command specified with the service key and the instance name that indicate the PFM - RM for Microsoft SQL Server whose monitoring target host you are going to update.
```
jpcconf target list -key RMSQL -inst instance-name
Targets:
targethost1
targethost2
Groups:
All
```
If you change the name of the monitored host (Target Host), use the jpctool alarm unbind command to unbind the bound alarm table.

To unbind an alarm table with the alarm table name of alarmtable1 from the monitored host with the service ID of 4Atargethost1, execute the following command:
```
jpctool alarm unbind -key RMSQL -table alarmtable1 -id 4Atargethost1
```
Stop all the PFM - RM for Microsoft SQL Server services.

For details about how to stop services, see the chapter on starting and stopping Performance Management in the JP1/Performance Management User's Guide.
Execute the jpcconf target setup command specified with the service key, the instance name, and the monitoring target name that indicate the PFM - RM for Microsoft SQL Server whose monitoring target host you are going to update.

For example, if you update the monitoring target whose monitoring target name is targethost1, execute the following command:
```
# jpcconf target setup -key RMSQL -inst instance-name -target targethost1
```
Although an example of interactive command execution is shown here, the jpcconf target setup command can be also executed non-interactively. For details about the jpcconf target setup command, see the chapter that describes commands in the manual JP1/Performance Management Reference.

Note that when you execute the jpcconf target setup command non-interactively, the operation in step 5 is not needed.
Update the monitoring target host of PFM - RM for Microsoft SQL Server.

Enter the information shown in Table 2-15 in accordance with the command's instructions. The current settings are displayed. To use the displayed value, press the Enter key. When you have finished entering the information, the monitoring target host is updated.
Restart the service of the updated instance environment.

For details about how to start and stop services, see the chapter on starting and stopping Performance Management in the JP1/Performance Management User's Guide.
If you unbound the alarm table in step 2, execute the jpctool alarm bind command to bind the alarm table.

To bind the alarm table with the alarm table name of alarmtable1 with the monitored host with the service ID of 4Atargethost1, execute the following command:
```
jpctool alarm bind -key RMSQL -table alarmtable1 -id 4Atargethost1
```

Note:

When you update the monitoring target, make sure that you stop the services on that instance environment of the PFM - RM for Microsoft SQL Server.

If you execute jpcconf target setup to update the monitoring target while the services of the PFM - RM for Microsoft SQL Server is still running, the service of PFM - RM for Microsoft SQL Server updates the monitoring target, then the following message is output to the agent log, and PFM - RM for Microsoft SQL Server stops: "KAVL19848-E".

To restart the collection of the performance information, restart the services of PFM - RM for Microsoft SQL Server.

For details about commands, see the chapter on commands in the manual JP1/Performance Management Reference.

To Page Top