This subsection describes how to set up Performance Management to run in a cluster system.
When you want to operate Performance Management in a cluster system, setup is needed on both the executing node and the standby node. You must perform setup on the executing node before performing the setup on the standby node.
indicates a task to be performed on the executing node.
indicates a task to be performed on the standby node.
indicates a setup item that is required depending on the environment or an optional setup item used when the default is to be changed.
To perform integrated management of PFM - RM using PFM - Manager and PFM - Web Console, you must register PFM - RM for Microsoft SQL Server with PFM - Manager and PFM - Web Console.
You will need to register PFM - RM for Microsoft SQL Server in the following cases:
Registration is performed separately for PFM - Manager and PFM - Web Console. The registration procedure is the same as in the registration procedure in a non-cluster system.
For details about the procedure, see 2.1.4(1) Registering PFM - RM for Microsoft SQL Server.
Make sure that the shared disk is online. If the shared disk is not online, use the cluster software or the volume manager to bring it online.
Execute the jpcconf ha setup command to set up the logical host environment. When you execute the command, the necessary files are copied to the shared disk, the logical host definition is set up, and the logical host environment is created.
To set up the logical host environment:
jpcconf ha setup -key RMSQL -lhost jp1-halSQL -d S:\jp1
jpcconf ha list -key all
Execute the jpcconf mgrhost define command to specify which PFM - Manager is to manage PFM - RM for Microsoft SQL Server.
jpcconf mgrhost define -host jp1-hal -lhost jp1-halSQL
Execute the jpcconf inst setup command to set up an instance environment for PFM - RM for Microsoft SQL Server.
The setup procedure is the same as the setup procedure in a non-cluster system, except that, in a cluster system, you must specify the logical host name in the -lhost option when executing the jpcconf inst setup command.
In a cluster system, the jpcconf inst setup command is executed in the following format:
jpcconf inst setup -key RMSQL -lhost logical-host-name -inst instance-name
Although an example of interactive command execution is shown here, the jpcconf inst setup command can be also executed non-interactively. For details about the jpcconf inst setup command, see the chapter that describes commands in the manual Job Management Partner 1/Performance Management Reference.
As the agent log output folder (the value of log_path), specify the path of a folder that is on the shared disk.
For details about other settings and procedures, see 2.1.4(2) Setting up an instance environment.
Execute jpcconf target setup command to specify which Microsoft SQL Server host for PFM - RM for Microsoft SQL Server to monitor.
The setup procedure is the same as the setup procedure in a non-cluster system, except that, in a cluster system, you must specify the logical host name in the -lhost option when executing the jpcconf target setup command.
In a cluster system, the jpcconf target setup command is executed in the following format:
jpcconf target setup -key RMSQL -inst instance-name -target monitoring-target-name -lhost logical-host-name
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 Job Management Partner 1/Performance Management Reference.
For details about other settings and procedures, see 2.1.4(2)(b) Set the monitoring target.
If you use the Windows authentication, see 2.1.4(2)(c) Using Windows authentication. For details about the login permissions of the Microsoft SQL Server, see 2.1.4(2)(d) Login permissions of the Microsoft SQL Server.
Register the stored procedure in order for PFM - RM for Microsoft SQL Server to obtain the names and the sizes of the databases from Microsoft SQL Server
The registering procedure is the same as that of the non-cluster-system. For details, see 2.1.4(3) Registering the R4QHITACHIPROCSPDATABASES Stored Procedure.
At this point, set up any other Performance Management programs, such as PFM - Manager or PFM - RM, on the same logical host.
For details about how to set up these products, see the chapters on setup and operation in a cluster system in the Job Management Partner 1/Performance Management User's Guide, and the chapter on operation in a cluster system in the manuals for the applicable version of PFM - RM.
This setup task is necessary only when you change the network settings to match the configuration in which Performance Management is used.
The following are the two network setting items:
Performance Management outputs its operating status to a set of proprietary log files called a common message log. By default, the common message log consists of two 2,048 KB files. Perform this setting if you want to change the default file size.
For details, see the chapter on installation and setup in the Job Management Partner 1/Performance Management Planning and Configuration Guide.
Perform this setting only if you want to change the folders where the database of performance data managed by PFM - RM for Microsoft SQL Server is saved, backed up, exported, or imported.
For details, see 2.4.1 Changing the storage location of performance data.
This setting is required to output action log when alarm occur. The action log stores history information that is output in conjunction with the alarms for thresholds related to system load and other conditions.
For details about how to set up the action log, see J. Outputting Action Log Information.
Once you have created the logical host environment for PFM - RM for Microsoft SQL Server, export the environment definition as a file. In the export process, a file containing the collective definition information for all Performance Management programs set up on that logical host is output. Export the environment definition only after you have set up all additional Performance Management programs on the logical host.
To export the environment definition of the logical host:
jpcconf ha export -f lhostexp.txt
Copy the file you exported in (13) Export the logical-host environment definition file from the executing node to the standby node.
Use the cluster software or the volume manager to take the shared disk offline. Note that if you intend to continue using the shared disk, you do not need to take it offline at this point.
On the standby node, import the exported file you copied from the executing node.
Use the jpcconf ha import command to set up the environment definition for the Performance Management programs of the logical host that you created on the executing node so that they run on the standby node. If more than one Performance Management program was installed on the logical host, the definition information for all of the programs is imported in batch form.
Note that the shared disk does not need to be online when you execute this command.
To import the logical-host environment definition file:
jpcconf ha import -f lhostexp.txt
jpcconf ha list -key all
If you intend to use Performance Management programs in a logical host environment, make sure that the programs are registered in the cluster software. Also, set up the environment so that the Performance Management programs are started and stopped based on instructions from the cluster software.
For details about how to register PFM - RM for Microsoft SQL Server in the cluster software, see your cluster software documentation.
This subsection describes how to register PFM - RM for Microsoft SQL Server in your cluster software, using the settings for Windows MSCS as an example.
Register the following services of PFM - RM for Microsoft SQL Server in the cluster software:
Table 3-3 PFM - RM for Microsoft SQL Server services to be registered in the cluster software
No. | Name | Service name | Dependencies |
---|---|---|---|
1 | PFM - RM Store for Microsoft(R) SQL Server instance-name [LHOST] | JP1PCAGT_4S_instance-name [LHOST] | IP address resource Physical disk resource |
2 | PFM - RM for Microsoft SQL Server instance-name [LHOST] | JP1PCAGT_4A_instance-name [LHOST] | Cluster resource in No. 1 |
3 | PFM - Action Handler [LHOST] | JP1PCMGR_PH [LHOST] | IP address resource Physical disk resource |
Replace LHOST with the logical host name. For example, if the instance name is SQL1 and the logical host name is jp1-halSQL, the display name of the service will be PFM - RM Store for Microsoft(R) SQL Server SQL1 [jp1-halSQL], and the service name will be JP1PCAGT_4S_SQL1 [jp1-halSQL].
When using MSCS as your cluster software, register the services as MSCS resources. Set up each resource according to the instructions below. Text in bold indicates a setting you perform in MSCS.
Check whether the cluster software is operating correctly by using it to issue start and stop requests to Performance Management programs on each node.
After setting up the Performance Management programs, use PFM - Web Console to set up the environment for the programs. You will then be able to display reports on the operating status of monitoring targets, and notify users whenever a problem occurs.
For details about setting up the environment for Performance Management programs, see the chapters on setup and operation in a cluster system in the Job Management Partner 1/Performance Management User's Guide.