Table 16-8 describes how to specify the items in the optimization information parameter file, and Table 16-9 describes how to specify MAX_VALUE and MIN_VALUE. Table 16-10 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 |
: 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 | 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. |
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 character string contains a blank or its length is zero, enclose it in double quotation marks ("). | 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. |
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* | 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* | 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* | Specified | Specified | RANGE_VALUES | Value specified for MAX_VALUE | ||
Not specified | Null value | |||||
Not specified | ![]() | Null value | ||||
MIN_VALUE* | Specified | Specified | Value specified for MIN_VALUE | |||
Not specified | Null value | |||||
Not specified | ![]() | Null value |
: Not applicable.
* If either NROWS, NNULLS, MAX_VALUE, or MIN_VALUE is omitted, the null value is set in the RANGE_VALUES column.