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‒14: 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
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

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.

1. 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

2. 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.

3. 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 4 is not needed.

4. Update the monitoring target host of PFM - RM for Microsoft SQL Server.

   Enter the information shown in Table 2-14 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.

5. 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.

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