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 ()YYYYMMDD.
INTERVAL HOUR TO SECOND	Specify in the format ()hhmmss.
TIMESTAMP	"YYYY-MM-DDhh:mm:ss[.nnnnnn]" : 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.
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.

¹ The following table describes the storage method when the decimal places are specified for the second part of the TIMESTAMP type:

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

² 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

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.