Appendix A.2 Maximum and minimum values for databases

The following table lists 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 decimalDECIMAL or NUMERIC138Digits
Decimal places for packed decimalDECIMAL or NUMERIC038Digits
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 partitions14,096Count
Number of BESs where partitioned tables are placed14,096Count
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, query name, trigger identifier, statement label, loop variable name, host identifier, list 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 server----#1--
Number of processed rows that can be displayed in messages by the following utilities:
  • pdload
  • pdrorg
  • pdrbal
04,294,967,295#2Count
#1: The maximum value depends on specifications such as whether plug-ins are used and the number of RDAREAs in the server. 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.