15.2.3 Setup when linking with an ODBC-compliant application program

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

jpcconf agent setup -key xxxx

jpcconf agent setup -key Oracle

To Page Top

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

To Page Top

(3) Specifying data sources

Specify the data source of the PFM ODBC driver in the ODBC Data Source Administrator dialog box in Windows.

1. Display the ODBC Data Source Administrator dialog box.

   From the Windows Start menu, choose Administrative Tools, and then Data Sources (ODBC).

2. In the ODBC Data Source Administrator dialog box, click the System DSN tab.

3. From Name, choose Performance Management, and then click the Configure button.

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

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

6. Click the OK button in the Performance Management Driver Data Source Options dialog box.

7. Click the OK button in the Performance Management Driver Data Source Setup dialog box.

8. Click the OK button in the ODBC Data Source Administrator dialog box.

To Page Top