15.2.3 Setup when linking with an ODBC-compliant application program
- Organization of this subsection
(1) Performing additional setup for PFM - Agent or PFM - RM
Skip this procedure if PFM - Manager has been installed on a host that uses the PFM ODBC driver, and PFM - Agent or PFM - RM has already been registered when PFM - Manager is setup.
You can omit this procedure if you are using PFM - Manager version 09-00 or later, because PFM - Agent or PFM - RM is registered automatically. However, if the release date for PFM - Agent or PFM - RM is later than that of PFM - Manager, PFM - Agent or PFM - RM needs to be registered manually.
If PFM - Manager has not been installed but PFM - Base has been installed on a host that uses the PFM ODBC driver, copy the setup files for PFM - Agent or PFM - RM onto a host that uses the PFM ODBC driver, and then execute the setup command in the same way as registering PFM - Agent or PFM - RM during the setup of PFM - Manager.
(a) Copying the setup files for PFM - Agent or PFM - RM
Copy, in binary mode, the setup files from a host that has PFM - Agent or PFM - RM onto a host that has PFM - Base installed. The following table lists the copy source and destination.
Platform |
File |
||
---|---|---|---|
Copy source PFM - Agent or PFM - RM |
Copy destination PFM - Base |
Copy source PFM - Agent or PFM - RM |
Copy destination PFM - Base |
Windows |
Windows |
installation-folder\setup\jpcxxxxw.EXE# |
installation-folder\setup\ |
UNIX |
installation-folder\setup\jpcxxxxu.Z# |
/opt/jp1pc/setup |
|
UNIX |
Windows |
/opt/jp1pc/setup /jpcxxxxw.EXE# |
installation-folder\setup\ |
UNIX |
/opt/jp1pc/setup /jpcxxxxu.Z# |
/opt/jp1pc/setup |
(b) Executing the setup command on the PFM - Base host
Execute the following command on the PFM - Base host to set up PFM - Agent or PFM - RM.
jpcconf agent setup -key xxxx
xxxx indicates the service key of each PFM - Agent or PFM - RM. For details on service keys, see the appropriate PFM - Agent or PFM - RM manual.
For example, execute the following command to set up PFM - Agent for Oracle:
jpcconf agent setup -key Oracle
In this example, the jpcconf agent setup command is executed in interactive mode. However, the command can also be executed in non-interactive mode. For details on the jpcconf agent setup command, see the chapter on commands in the manual Job Management Partner 1/Performance Management Reference.
- Note
-
An error might occur if you execute the jpcconf agent setup command when Performance Management programs and services have not completely stopped on the local host where you want to execute the command. In such cases, make sure that the Performance Management programs and services have completely stopped, and then execute the jpcconf agent setup command.
You can delete the setup files for PFM - Agent or PFM - RM after this procedure has finished.
(2) Specifying PFM - Manager for the connection destination
Before using the PFM ODBC driver, you must specify the PFM - Manager at the connection destination. Use the jpcconf mgrhost define command to set the PFM - Manager for the connection destination.
For example, execute the following command to specify the destination when you set the PFM - Manager on host host01 as the connection target:
jpcconf mgrhost define -host host01
In this example, the jpcconf mgrhost define command is executed in interactive mode. However, the command can also be executed in non-interactive mode. For details on the jpcconf mgrhost define command, see the chapter that describes commands in the manual Job Management Partner 1/Performance Management Reference.
- Note:
-
Only one PFM - Manager can be specified as the connection target per host. If more than one Performance Management program is installed on the same host, you cannot specify different PFM - Managers as connection destinations.
(3) Specifying data sources
Specify the data source of the PFM ODBC driver in the ODBC Data Source Administrator dialog box in Windows.
-
Display the ODBC Data Source Administrator dialog box.
From the Windows Start menu, choose Administrative Tools, and then Data Sources (ODBC).
-
In the ODBC Data Source Administrator dialog box, click the System DSN tab.
-
From Name, choose Performance Management, and then click the Configure button.
-
In the Performance Management Driver Data Source Setup dialog box, enter the information needed to create the data source.
Specify the settings as follows:
Item
Details
Data Source Name
Specify the data source name that is required for the connection request from an ODBC-compliant application program. You can use 1-32 bytes of alphanumeric characters or symbols to specify the name. However, you cannot use the following symbols:
[ ] { } ( ) , ; ? * = ! @ \
The default setting is Performance Management.
Description
Specify the text describing the function or contents of the data source. You can use 0-259 bytes of alphanumeric characters or symbols. However, you cannot use the following symbols:
[ ] { } ( ) , ; ? * = ! @
You can omit this item.
-
To specify detailed options for the data source, click the Options button.
Specify the settings as follows:
Item
Description
Instance Name Suffix
Specify the suffix to be added to the PFM ODBC driver instance name. You can use 0-8 bytes of alphanumeric characters to specify the suffix. You can omit this item.
Description
Specify the text describing the function or contents of the data source. You can use 0-259 bytes of alphanumeric characters or symbols. However, you cannot use the following symbols:
[ ] { } ( ) , ; ? * = ! @
You can omit this item.
Use Alias Names in Output
Specify whether or not the PFM - Manager name of each field of records is included in output data. When you select this item, output data includes the PFM - Manager names.
Cache Node Names
Select whether to access the PFM - Manager each time data is required. When you select this item, the node name that is obtained during the first query is cached. In such a case, the node name is not requested during the second and subsequent queries. Any PFM - Agent or PFM - RM added during linkage with an ODBC-compliant application program is not searched for by the query.
Enable Debugging
Select whether to enable the debug function for the PFM ODBC driver. When you select this item, the debug function becomes active and trace logs are output. Use this item when an error occurs.
Show Progress During Connect
Select whether to display a progress message when the PFM ODBC driver connects to PFM - Manager. When you select this item, a progress message appears.
Trace PQL Requests
Select whether to enable traces of requests for Program Query Language (PQL). When you select this item, the trace function becomes active.
PQL Trace File
When you select Trace PQL Requests, specify the name of the file where traces are output. The name must be an absolute path of 1 - 259 bytes.
-
Click the OK button in the Performance Management Driver Data Source Options dialog box.
-
Click the OK button in the Performance Management Driver Data Source Setup dialog box.
-
Click the OK button in the ODBC Data Source Administrator dialog box.