The table below describes how to specify the items in the optimization information parameter file, and Table 16-9 Specification of MAX_VALUE and MIN_VALUE describes how to specify MAX_VALUE and MIN_VALUE. Table 16-10 Default values for items in the optimization information parameter file lists the default values for items in the optimization information parameter file.
Table 16-8 Specifications in the optimization information parameter file
Item | Specification | Permitted minimum value | Permitted maximum value | Units |
---|---|---|---|---|
NROWS | Specify a positive integer. An exponential value can also be specified. | 0 | Maximum FLOAT value supported by HiRDB | Rows |
NPAGES | 0 | Pages | ||
INDEX | Comply with the rules for index definition. | |||
NIPAGES | Specify a positive integer. An exponential value can also be specified. | 1 | Maximum FLOAT value supported by HiRDB | Pages |
NLEVEL | Specify a positive integer. | 1 | Maximum SMALLINT value supported by HiRDB | Columns |
SEQ_RATIO | 0 | 100 | % | |
NENTRY | Specify a positive integer. An exponential value can also be specified. | 0 | Maximum FLOAT value supported by HiRDB | Values |
COLUMN | Comply with the rules for table definition. | |||
NUNIQUE | Specify a positive integer. An exponential value can also be specified. | 0 | Maximum FLOAT value supported by HiRDB | Values |
NNULLS | 0 | Values | ||
N_MAX_DUP_KEY | 0 | Values | ||
N_MIN_DUP_KEY | 0 | Values | ||
MAX_VALUE | -- | |||
MIN_VALUE | ||||
SECTION_COUNT | Specify a positive integer. An exponential value can also be specified. | 0 | 100 | Sections |
SECTION_NO | 1 | Number of sections | -- | |
SEC_TOTAL_COUNT | 1 | Maximum value for the SMALLFLT type in HiRDB | Rows | |
SEC_UNIQUE | 1 | Maximum value for the SMALLFLT type in HiRDB | Values | |
SEC_MAX_VALUE | -- |
--: Not applicable.
Table 16-9 Specification of MAX_VALUE and MIN_VALUE
Data type of column specified for COLUMN | Specification | Maximum and minimum values |
---|---|---|
INT[EGER] | Specify a numeric value. | HiRDB rules for each data type are observed. The permitted maximum number of digits complies with the HiRDB rules for numeric literals. For details, see Data types in the manual HiRDB Version 9 SQL Reference. |
SMALLINT | ||
[LARGE]DEC[IMAL] | ||
FLOAT or DOUBLE PRECISION | Specify a numeric value. An exponential value can also be specified. | |
SMALLFLT or REAL | ||
CHAR | Specify a character or a character string. If the data type is CHAR, VARCHAR, MCHAR, or MVARCHAR and the data contains a control character, such as \0 or a linefeed code, or a character set is specified for the column, specify the character string in hexadecimal characters.#2 You must enclose the character string in double quotation marks (") if any of the following applies:
| One line of character string data including the item name can be specified in the optimization information parameter file. The utility registers the first 16 bytes as the optimization information (not including double quotation marks) and discards any remaining characters. If the data type is MCHAR or MVARCHAR and byte 16 or 17 contains a 2-byte code, at least 17 bytes of character string data must be specified. |
VARCHAR | ||
NCHAR | ||
NVARCHAR | ||
MCHAR | ||
MVARCHAR | ||
DATE | Specify in the format YYYY-MM-DD. | HiRDB rules for each data type are observed. For details, see Data types in the manual HiRDB Version 9 SQL Reference. |
TIME | Specify in the format hh:mm:ss. | |
INTERVAL YEAR TO DAY | Specify in the format (![]() | |
INTERVAL HOUR TO SECOND | Specify in the format (![]() | |
TIMESTAMP | "YYYY-MM-DD![]() ![]() For the fraction part [.nnnnnn], specify 0, 2, 4, or 6 according to the definition.#1 Enclose the specified value in double quotation marks. | |
BINARY | Specify binary data expressed as hexadecimal characters.#2 For data with a length of 0, specify X''. | The utility registers the first 12 bytes as the optimization information and discards any remaining characters. |
Defined length | Decimal places in the second part of input data | ||||
---|---|---|---|---|---|
0 | 2 | 4 | 6 | Other | |
0 | Stored as is | Truncated at the defined length | Error (KFPL31002-E) | ||
2 | Zeros are padded up to the defined length | Stored as is | Truncated at the defined length | ||
4 | Zeros are padded up to the defined length | Stored as is | Truncated at the defined length | ||
6 | Zeros are padded up to the defined length | Stored as is |
Table 16-10 Default values for items in the optimization information parameter file
Item | Value | Name of target dictionary table | Name of target column | Set value | Rows subject to setting in target dictionary table | |
---|---|---|---|---|---|---|
NROWS#1 | Specified | Specified | SQL_TABLE_STATISTICS | N_ROW | Value specified for NROWS | Table specified with -t option |
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
NPAGES | Specified | Specified | N_PAGE | Value specified for NPAGES | ||
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
NIPAGES | Specified | Specified | SQL_INDEX_STATISTICS | N_IXPG | Value specified for NIPAGES | Index specified with INDEX |
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
NLEVEL | Specified | Specified | N_LEVEL | Value specified for NLEVEL | ||
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
SEQ_RATIO | Specified | Specified | SEQ_RATIO | Value specified for SEQ_RATIO | ||
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
NENTRY | Specified | Specified | N_ENTRY | Value specified for N_ENTRY | ||
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
NUNIQUE | Specified | Specified | SQL_COLUMN_STATISTICS | N_UNIQUE | Value specified for NUNIQUE | Column specified with COLUMN |
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
NNULLS#1 | Specified | Specified | N_NULL | Value specified for NNULLS | ||
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
N_MAX_DUP_KEY | Specified | Specified | N_MAX_DUP_KEY | Value specified for N_MAX_DUP_KEY | ||
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
N_MIN_DUP_KEY | Specified | Specified | N_MIN_DUP_KEY | Value specified for N_MIN_DUP_ KEY | ||
Not specified | Null value | |||||
Not specified | -- | Value existing before update | ||||
MAX_VALUE#1 | Specified | Specified | RANGE_VALUES | Value specified for MAX_VALUE | ||
Not specified | Null value | |||||
Not specified | -- | Null value | ||||
MIN_VALUE#1 | Specified | Specified | Value specified for MIN_VALUE | |||
Not specified | Null value | |||||
Not specified | -- | Null value | ||||
SECTION_COUNT | Specified | Specified | Value specified in SECTION_COUNT#2 | |||
Not specified | 0 | |||||
Not specified | -- | 0 | ||||
SECTION_NO | Specified | Specified | Value specified in SECTION_NO | |||
Not specified | Error | |||||
Not specified | -- | Error | ||||
SEC_TOTAL_COUNT | Specified | Specified | Value specified in SEC_TOTAL_COUNT | |||
Not specified | Error | |||||
Not specified | -- | Error | ||||
SEC_UNIQUE | Specified | Specified | Value specified in SEC_UNIQUE | |||
Not specified | Error | |||||
Not specified | -- | Error | ||||
SEC_MAX_VALUE | Specified | Specified | Value specified in SEC_MAX_VALUE | |||
Not specified | Error | |||||
Not specified | -- | Error |
--: Not applicable.