16.4.2 Specifications in the optimization information parameter file

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

ItemSpecificationPermitted minimum valuePermitted maximum valueUnits
NROWSSpecify a positive integer. An exponential value can also be specified.0Maximum FLOAT value supported by HiRDBRows
NPAGES0Pages
INDEXComply with the rules for index definition.
NIPAGESSpecify a positive integer. An exponential value can also be specified.1Maximum FLOAT value supported by HiRDBPages
NLEVELSpecify a positive integer.1Maximum SMALLINT value supported by HiRDBColumns
SEQ_RATIO0100%
NENTRYSpecify a positive integer. An exponential value can also be specified.0Maximum FLOAT value supported by HiRDBValues
COLUMNComply with the rules for table definition.
NUNIQUESpecify a positive integer. An exponential value can also be specified.0Maximum FLOAT value supported by HiRDBValues
NNULLS0Values
N_MAX_DUP_KEY0Values
N_MIN_DUP_KEY0Values
MAX_VALUE[Figure]
MIN_VALUE

[Figure]: Not applicable.

Table 16-9 Specification of MAX_VALUE and MIN_VALUE

Data type of column specified for COLUMNSpecificationMaximum and minimum values
INTSpecify 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 PRECISIONSpecify a numeric value. An exponential value can also be specified.
SMALLFLT or REAL
CHARSpecify 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
DATESpecify in the format YYYY-MM-DD.HiRDB rules for each data type are observed.
TIMESpecify in the format hh:mm:ss.
INTERVAL YEAR TO DAYSpecify in the format ([Figure])YYYYMMDD.
INTERVAL HOUR TO SECONDSpecify in the format ([Figure])hhmmss.
TIMESTAMP"YYYY-MM-DD[Figure]hh:mm:ss[.nnnnnn]"
[Figure]: Single-byte space
For the fraction part [.nnnnnn], specify 0, 2, 4, or 6 according to the definition.1 Enclose the specified value in double quotation marks.
BINARYSpecify 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.
1 The following table describes the storage method when the decimal places are specified for the second part of the TIMESTAMP type:
Defined lengthDecimal places in the second part of input data
0246Other
0Stored as isTruncated at the defined lengthError (KFPL31002-E)
2Zeros are padded up to the defined lengthStored as isTruncated at the defined length
4Zeros are padded up to the defined lengthStored as isTruncated at the defined length
6Zeros are padded up to the defined lengthStored as is
2 Hexadecimal representation is x'****' or X'****'. For ****, specify a hexadecimal value in units of two characters (0-9, a-f, and A-F).

Table 16-10 Default values for items in the optimization information parameter file

ItemValueName of target dictionary tableName of target columnSet valueRows subject to setting in target dictionary table
NROWS*SpecifiedSpecifiedSQL_TABLE_STATISTICSN_ROWValue specified for NROWSTable specified with -t option
Not specifiedNull value
Not specified[Figure]Value existing before update
NPAGESSpecifiedSpecifiedN_PAGEValue specified for NPAGES
Not specifiedNull value
Not specified[Figure]Value existing before update
NIPAGESSpecifiedSpecifiedSQL_INDEX_STATISTICSN_IXPGValue specified for NIPAGESIndex specified with INDEX
Not specifiedNull value
Not specified[Figure]Value existing before update
NLEVELSpecifiedSpecifiedN_LEVELValue specified for NLEVEL
Not specifiedNull value
Not specified[Figure]Value existing before update
SEQ_RATIOSpecifiedSpecifiedSEQ_RATIOValue specified for SEQ_RATIO
Not specifiedNull value
Not specified[Figure]Value existing before update
NENTRYSpecifiedSpecifiedN_ENTRYValue specified for N_ENTRY
Not specifiedNull value
Not specified[Figure]Value existing before update
NUNIQUESpecifiedSpecifiedSQL_COLUMN_STATISTICSN_UNIQUEValue specified for NUNIQUEColumn specified with COLUMN
Not specifiedNull value
Not specified[Figure]Value existing before update
NNULLS*SpecifiedSpecifiedN_NULLValue specified for NNULLS
Not specifiedNull value
Not specified[Figure]Value existing before update
N_MAX_DUP_KEYSpecifiedSpecifiedN_MAX_DUP_KEYValue specified for N_MAX_DUP_KEY
Not specifiedNull value
Not specified[Figure]Value existing before update
N_MIN_DUP_KEYSpecifiedSpecifiedN_MIN_DUP_KEYValue specified for N_MIN_DUP_ KEY
Not specifiedNull value
Not specified[Figure]Value existing before update
MAX_VALUE*SpecifiedSpecifiedRANGE_VALUESValue specified for MAX_VALUE
Not specifiedNull value
Not specified[Figure]Null value
MIN_VALUE*SpecifiedSpecifiedValue specified for MIN_VALUE
Not specifiedNull value
Not specified[Figure]Null value

[Figure]: Not applicable.

* If either NROWS, NNULLS, MAX_VALUE, or MIN_VALUE is omitted, the null value is set in the RANGE_VALUES column.