For details on the HiRDB External Data Access facility, see the HiRDB External Data Access Version 7 Description and User's Guide.
Note that some platforms on which HiRDB is run do not support the HiRDB External Data Access facility. For details, see HiRDB External Data Access in the manual HiRDB Version 8 Description.
- 55) pdhubopt
- Specifies the foreign server to which the Hub optimization information definition is applied. Specify this operand in one of the following formats:
- pdhubopt -s foreign-server-name -f Hub-optimization-information-definition-file-name
- pdhubopt -d foreign-server-type [-v foreign-server-version] -f Hub-optimization-information-definition-file-name
- -s foreign-server-name
<identifier consisting of 1-30 characters> - Specifies the name of the foreign server specified by CREATE SERVER. Specify this option to perform Hub optimization for each foreign server. When you specify this option, you cannot specify the -d or -v option.
- If the foreign server name specified in the -s option is not registered, the following operand specification is assumed if a foreign-server.opt file exists under %PDCONFPATH%:
- pdhubopt -s foreign-server-name -f foreign-server-name.opt
- -d foreign-server-type [-v foreign-server-version]
- Specify these options to perform Hub optimization for each foreign server type and each foreign server version. For each foreign server type and each foreign server version, specify the values indicated in the following table. If you specify these options, you cannot specify the -s option.
Foreign server type | -d option specification value1 | -v option specification value2 |
---|
HiRDB Version 6 or later | HIRDB | 6.0 |
HiRDB Version 5.0 | 5.0 |
XDM/RD E2 | XDMRD | 6.0 |
Oracle8i | ORACLE | 8.1.5 |
Oracle9i | 9.2 |
Oracle 10g | 10.1 |
- 1 Same as the server type in the TYPE clause of CREATE SERVER.
- 2 Same as the server version in the VERSION clause of CREATE SERVER.
- -f Hub-optimization-information-definition-file-name
- Specifies the name of the Hub optimization information definition file. Specify only the file name, not the path name. Store this file under %PDDIR%\conf.
- Condition
- HiRDB External Data Access is required.
- Operand specification methods
- This operand can be specified more than once.
- To manage the Hub optimization information definition file of a specific foreign server separately, specify the -s (foreign-server-name) option.
- If you use multiple foreign servers and want to share the Hub optimization information definition file in the same DBMS, specify the -d (foreign-server-type) and -v (foreign-server-version) options.
- Notes
- Note the following when there are multiple Hub optimization information definition files: All Hub optimization information definition files that satisfy the conditions specified here are applied. The priority order is: -s specification, -d and -v specification, and -d only specification, in that order.
- Example:
- HiRDB Version 6 (server name: hirdb_v6_01) and HiRDB Version 5.0 are used as foreign servers. The pdhubopt operand is specified as follows:
pdhubopt -d HIRDB -f hubopt1 1
pdhubopt -d HIRDB -v 6.0 -f hubopt2 2
pdhubopt -s hirdb_v6_01 -f hubopt3 3
- Hub optimization information definition files 1 through 3 are applied to HiRDB Version 6. If same operands are specified, the specification value in 3 has the highest priority. If the same operand is specified in 1 and 2, the specification value in 2 has a higher priority.
- Hub optimization information definition file 1 is applied to HiRDB Version 5.0.