2.4.3 Updating an instance environment

To update an instance environment, check the name of the instance that you want to update, and change the instance information. Update an instance environment 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‒16: PFM - RM for Microsoft SQL Server instance information
Item	Description	Specifiable value	Default value
`LOG_PATH`	This item is updatable. Specifies the full path name of the folder for storing agent log information. If you specify a path containing space characters, do not enclose the path in quotation marks (`"`).	A character string of 245 or fewer bytes that does not include the following characters: Tabs The following symbols: `/ , ; * ? " < > \|`	Previous value
`LOG_SIZE`	This item is updatable. Specifies the maximum size of one agent log file.	1 to 32 (megabytes). The minimum recommended value is 16.	Previous value

Use the jpcconf inst list command to check the instance name. To update an instance environment, use the jpcconf inst setup command. For details about the command, see the chapter on the commands in the manual JP1/Performance Management Reference.

Updating an instance environment involves the steps described below. To update multiple instance environments, repeat the procedure for each 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.

For example, when you check the instance name of the PFM - RM for Microsoft SQL Server, execute the following command:
```
jpcconf inst list -key RMSQL
```
For example, if the instance name is SQL1, the command displays SQL1.
Stop all the PFM - RM for Microsoft SQL services.

If the service is still active in the instance environment that is to be updated when you execute the jpcconf inst setup command, a confirmation message is displayed to enable you to stop the service. If you stop the service, update processing resumes; if you do not stop the service, update processing is canceled.
Execute the jpcconf inst setup command specified with the service key that indicates PFM - RM for Microsoft SQL Server and the instance name.

For example, if you are updating the instance environment for the PFM - RM for Microsoft SQL Server with instance name SQL1, execute the following command:
```
jpcconf inst setup -key RMSQL -inst SQL1
```
Although an example of interactive command execution is shown here, the jpcconf inst setup command can be also executed non-interactively.

Note that when you execute the jpcconf inst setup command non-interactively, the operation in step 4 is not needed.
Update the instance information for Microsoft SQL Server.

Enter the information shown in Table 2-16 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 information, the instance environment is updated.
Restart the services in the updated instance environment.

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

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

To Page Top