Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


3.6.2 Updating an instance environment

When you update an instance environment in a cluster system, you first check the logical host name and the name of the instance that you want to update. You update the instance information on the executing node.

Before you change the information items, see in advance 2.4.3 Updating an instance environment.

For details about Microsoft SQL Server instance information, see your Microsoft SQL Server documentation.

Use the jpcconf ha list command to check the instance name. To update an instance environment, use the jpcconf inst setup command.

Updating an instance environment involves the steps described below. To update multiple instance environments, repeat the procedure for each instance environment.

  1. Check the logical host name and the instance name

    Execute the jpcconf ha list command specified with the service key that indicates the PFM - RM for Microsoft SQL Server in the instance environment that is to be updated:

    jpcconf ha list -key RMSQL

    For example, if you execute the command in the system with logical host name jp1_SQL and instance name SQL1, the command will list the following information:

    [Figure]

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

  3. If the shared disk is unmounted when you stop the service, use the cluster software or the volume manager to mount it.

  4. Execute the jpcconf inst setup command specified with the service key and the instance name that indicate the PFM - RM for Microsoft SQL Server in the instance environment that is to be updated.

    For example, if you are updating the instance environment with logical host name jp1_SQL and instance name SQL1, execute the following command:

    jpcconf inst setup -key RMSQL -lhost jp1_SQL -inst SQL1

    Although an example of interactive command execution is shown here, the jpcconf inst setup command can also be executed non-interactively. If you execute the jpcconf inst setup command non-interactively, the operation in step 5 is not needed.

  5. Update the instance information for PFM - RM for Microsoft SQL Server.

    Enter the information in accordance with the command's instructions. For details about the instance information of PFM - RM for Microsoft SQL Server, see 2.4.3 Updating an instance environment. The current settings are displayed (except for the value of Microsoft SQL Server_passwd). To use the displayed value, press the Enter key. When you have finished entering information, the instance environment is updated.

  6. 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 instance environment and then re-create it.

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