Scalable Database Server, HiRDB Version 8 Command Reference
![[Contents]](FIGURE/CONTENT.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
- -u authorization-identifier
Specifies the authorization identifier used for connecting to HiRDB. If omitted, the value set in the PDUSER environment variable is assumed. If the PDUSER value is not set, the user name corresponding to the user ID in the OS that is being used to execute this utility is assumed.
If a user ID is enclosed in \", it is handled as case sensitive; otherwise, it is handled as all uppercase letters.
- -a authorization-identifier
Specifies the authorization identifier of the owner of the table that is to be subject to collection of optimization information.
If omitted, the authorization identifier assigned by the -u option is assumed.
If an authorization identifier is enclosed in \", it is handled as case sensitive; otherwise, it is handled as all uppercase letters.
- -p password
Specifies the password for the user ID specified in the -u option.
If the -u option is specified but the -p option is omitted, the user is requested to enter a password, and the entered value is used; if entry of a password is not required, the NULL SEND button should be pressed.
If the -u and the -p options are both omitted, the value set in the PDUSER environment variable is assumed; if the PDUSER value is not set, the user is requested to enter a password, and the entered value is used; if entry of a password is not required, the NULL SEND button should be pressed.
This utility must not be executed in an environment in which a required password cannot be entered. Password entry is required in the following cases:
- -u option specified and -p option omitted
- -u and -p options both omitted and no password set in the PDUSER environment variable
If a password is enclosed in \", it is handled as case sensitive; otherwise, it is handled as all uppercase letters.
- -t {table-identifier|ALL}
- table-identifier
- Specifies the identifier of the table that is to be subject to collection of optimization information.
- You cannot specify a data dictionary table, view table, or foreign table. However, when registering optimizing information using a parameter file that contains optimized information, you can specify a foreign table.
- If a table identifier is enclosed in \", the command treats it as being case sensitive. If it is not enclosed in \", the command treats it as in all uppercase letters. If a table identifier contains a space, enclose the identifier in \".
- ALL
- Specifies that all tables in the schema are to be subject to processing. Note that foreign tables cannot be subject to processing.
- -d
Specifies that existing optimization information for the table specified with the -t option and for indexes defined for that table is to be deleted.
- -c {lvl1|lvl2}
Specifies the optimizing information collection level.
For details about the optimizing information collection level, see Section 16.3.2 Optimizing information collection levels.
- lvl1
- Collects the number of rows in the table and the statistical information cache size.
- lvl2
- Collects all optimizing information for the table.
- -s optimization-information-parameter-filename
<pathname>
Specifies the absolute pathname of the optimization information parameter file containing the optimization information. When this option is specified, the utility registers the optimization information from the specified parameter file without collecting it from the current database status. When this option is specified, the -d option cannot be specified.
- -l output-result-filename
<pathname>
Specifies the absolute pathname of the file to which the result of the optimizing information collection utility is to be output. When this option is omitted, the execution result is not output.
If you specify -t ALL along with this option, and pdgetcst results in an error, you can identify the table resulting in the error.
- -v space-conversion-level
Specifies whether or not to convert spaces in the maximum and minimum column values.
When this option is omitted, the utility executes space conversion according to the pd_space_level operand specification in the system common definitions.
For the space conversion level, specify 0, 1, or 3:
- 0
- Space conversion is not executed.
- 1 or 3
- Space conversion is executed. 1 and 3 have the same effects.
- If the table columns to be registered have the national character string type or mixed character string type, the utility converts spaces in the corresponding optimizing parameter file as follows:
- Column of national character string type
The utility converts two consecutive single-byte spaces to one double-byte space, in units of two bytes from the top.
- Column of mixed character string type
The utility converts each double-byte space to two single-byte spaces.
When the character codes are utf-8, the system converts one double-byte space (3 bytes) to two single-byte spaces. For MCHAR, the system adds trailing single-byte spaces up to the definition length. For MVARCHAR, the data length remains shortened.
All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.