Appendix A.2 Maximum and minimum values for databases

Table A-2 lists the maximum and minimum values for databases.

Table A-2 Maximum and minimum values for databases

ItemMinimum valueMaximum valueUnits
Length of character data (defined length)CHAR130,000Characters (Bytes)
VARCHAR132,000Characters (Bytes)
Length of national character data (defined length)NCHAR115,000Characters
NVARCHAR116,000Characters
Length of mixed character data (defined length)MCHAR130,000Bytes
MVARCHAR132,000Bytes
Precision of packed decimalDECIMAL129Digits
Decimal places for packed decimalDECIMAL029Digits
Seconds precision for timestamp dataTIMESTAMP06Digits
Length of BLOB data02,147,483,647Bytes
BINARY data length (defined length)12,147,483,647Bytes
Number of columns in a table130,000Columns
Number of indexes in a table0255Count
Number of index component columns116Columns
Number of cluster key component columns116Columns
Number of RDAREAs for storing table partitions11024Count
Number of BESs where partitioned tables are placed11024Count
Total number of literals specified for storage conditions when a row-partitioned table is defined (if storage condition is omitted, 1 is assumed)115,000Count
Number of tables based on view tables164Count
Number of columns in a view table130,000Columns
Number of primary key component columns116Columns
Number of foreign key component columns116Columns
Number of foreign keys per table0255Count
Number of foreign keys that reference a single primary key0255Count
Number of check constraints that can be specified per table0254Count
Total number of Boolean operators (AND and OR) and check constraint definitions that can be defined per table (excluding the Boolean operators AND and OR in WHEN search conditions in CASE expressions)0254Count
Identifier length
(Applicable to table identifier, column name, data type identifier, index type identifier, attribute name, routine identifier, correlation name, index identifier, cursor name, SQL statement identifier, RDAREA name, embedded variable name, indicator variable name, password, constraint name, condition name, SQL variable name, group ID, query name, trigger identifier, table alias, statement label, loop variable name, host identifier, list name, roll name, RD node name, SQL parameter name)
130Bytes
Row length of FIX table130,000Bytes
Number of SQL parameters in a procedure030,000Count
Number of repetition columns230,000Count
Number of index information files created per serverHP-UX17,616 to 8,0921Count
Solaris11,472 to 1,9481Count
Solaris(64-bit mode)17,616 to 8,0921Count
AIX 5L17,616 to 8,0921Count
Linux1448 to 9241Count
Number of processed rows that can be displayed in messages by the following utilities:
  • pdload
  • pdrorg
  • pdrbal
04,294,967,2952Count
1 The maximum value depends on specifications such as the pd_max_open_fds operand value, whether or not plug-ins are used, and the number of RDAREAs in the server. The table value is the maximum value specified in the pd_max_open_fds operand. If plug-in index delayed batch creation uses a HiRDB file system area, the maximum value is 4,096.
2 When the number of processed data items exceeds 4,294,967,295, the displayed row count is reset to 0 and the count starts again from 1.