2.2.2 Procedure for canceling setup

This subsection describes how to cancel setup of PFM - RM for Microsoft SQL Server.

Organization of this subsection

(1) Canceling setup of an instance environment

(1) Canceling setup of an instance environment

Canceling setup of an instance environment involves the tasks listed below. To cancel setup of multiple instance environments, you must repeat the procedure for each environment.

Deleting a monitoring target
Deleting an instance environment
Deleting the registered stored procedure

To cancel the setup of an instance environment:

(a) Deleting a monitoring target

Check a monitoring target name before deleting the monitoring target. Delete the monitoring target on the PFM - RM host.

Use the jpcconf target list command to check the monitoring target name. Use the jpcconf target unsetup command to delete the monitoring target.

The following procedure describes how to delete a 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 name you are going to delete.
```
jpcconf target list -key RMSQL -inst instance-name
```
The monitoring target name is displayed:
```
Targets:
targethost1
targethost2
Groups:
All
```
Stop all the PFM - RM for Microsoft SQL services.

For details about how to start and stop the service, see the chapter on starting and stopping Performance Management in the JP1/Performance Management User's Guide.
Delete the monitoring target.

Execute the jpcconf target unsetup command specified with the service key, the instance name, and the monitoring target name that indicate PFM - RM for Microsoft SQL Server whose monitoring target you are going to delete.
```
jpcconf target unsetup -key RMSQL -inst instancename -target monitoringtargetname
```

If the jpcconf target unsetup command terminates successfully, the Microsoft SQL Server host specified by the monitoring target is no longer monitored.

Notes:

Canceling setup of an instance environment does not delete the service information that is displayed with the jpctool service list command.

When you want to update the PFM - Web Console host to reflect the deletion of monitoring target, you need to execute the jpctool service sync command to synchronize the agent information of the PFM - Manager host and that of the PFM - Web Console host.
Use the jpcconf target unsetup command to delete the monitoring target while PFM - RM for Microsoft SQL Server stops.
If you delete the monitoring target while PFM - RM for Microsoft SQL Server is still running, the service of PFM - RM for Microsoft SQL Server deletes the monitoring target, then the following message is output to the agent log, and PFM - RM for Microsoft SQL Server stops: "KAVL19848-E".

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

(b) Delete an instance environment

Check the instance name and delete the instance environment. Delete an instance environment on the PFM - RM host.

To check the instance name, use the jpcconf inst list command. To delete an instance environment that has been created, use the jpcconf inst unsetup command.

To delete an instance environment:

Check the instance name.

Execute the jpcconf inst list command specified with the service key that indicates PFM - RM for Microsoft SQL Server.
```
jpcconf inst list -key RMSQL
```
For example, if the instance name is SQL1, the command displays SQL1.
Stop all active PFM - RM for Microsoft SQL Server services in the instance environment.

For details about how to stop services, see the chapter on starting and stopping Performance Management in the JP1/Performance Management User's Guide.
Delete the instance environment.

Execute the jpcconf inst unsetup command specified with the service key that indicates PFM - RM for Microsoft SQL Server and the instance name.

For example, if the instance name is SQL1, use the following command line:
```
jpcconf inst unsetup -key RMSQL -inst SQL1
```
Although an example of interactive command execution is shown here, the jpcconf inst unsetup command can be also executed non-interactively. For details about the jpcconf inst unsetup command, see the chapter that describes commands in the manual JP1/Performance Management Reference.

When the jpcconf inst unsetup command terminates successfully, the folders created as the instance environment are deleted, as well as the service IDs and Windows services.

Note:

Canceling setup of an instance environment does not delete the service information that is displayed with the jpctool service list command. Use the jpctool service delete command to delete service information, and then restart PFM - Manager.

If you want to update the PFM - Web Console host to reflect the deletion of instance environment, you need to execute the jpctool service sync command to synchronize the agent information of the PFM - Manager host and that of the PFM - Web Console host.

The following shows sample conditions and a command line applicable for the conditions.

Instance name: SQL1
Host name: host1
Service ID of the Remote Monitor Collector service: 4A1SQL[host1]
Service ID of the Remote Monitor Store service: 4S1SQL[host1]

jpctool service delete 4?1SQL1[host1] -host host1

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

(c) Deleting the Stored Procedure

If you register the following stored procedure to the master database in the Microsoft SQL Server instance on the monitoring target host, delete the stored procedure.

R4QHITACHIPROCSPDATABASES

Delete the stored procedure on the monitoring target host where the Microsoft SQL Server is running.

To Page Top