3.6.1 Updating a monitoring target

When you update a monitoring target, you first check the logical host name, the instance name, and the monitoring target name. You update a monitoring target host on the executing node.

Before you change an information item, see 2.4.2 Updating a monitoring target in advance. For details about Microsoft SQL Server monitoring-target information, see your Microsoft SQL Server documentation.

Use the jpcconf ha list command to check the logical host name and the instance name. To check the monitoring target name, use the jpcconf target list command.

Use the jpcconf target setup command to update a monitoring target name.

Updating a monitoring target host involves the steps described below. To update multiple monitoring target hosts, repeat the procedure for each monitoring target host.

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 you are going to update.
```
jpcconf target list -key RMSQL -inst instance-name -lhost logical-host-name
```
Execution of this command displays the following items:
```
Targets:
targethost1
targethost2
Groups:
All
```
If the PFM - RM for Microsoft SQL Server service is active in the instance environment that is to be updated, use the cluster software to stop the service.

For details about stopping the services, see the chapter on starting and stopping Performance Management in a cluster system in the JP1/Performance Management User's Guide.
If the shared disk is unmounted when you stop the service, use the cluster software or the volume manager to mount it.
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 -lhost logical-host-name
```
Although an example of interactive command execution is shown here, the jpcconf target setup command can also be executed non-interactively. If 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 the 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 is updated.
Use the cluster software to restart the service in the updated instance environment.

For details about the starting the service, see the chapter on starting and stopping Performance Management in a cluster system in the JP1/Performance Management User's Guide.

Important

If you want to change an item that cannot be updated, delete the monitoring target information and then re-create it.

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

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 the jpcconf target setup command 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 out put 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.

To Page Top