Table A-2 lists the maximum and minimum values for databases.
Table A-2 Maximum and minimum values for databases
Item | Minimum value | Maximum value | Units | |
---|---|---|---|---|
Length of character data (defined length) | CHAR | 1 | 30,000 | Characters (Bytes) |
VARCHAR | 1 | 32,000 | Characters (Bytes) | |
Length of national character data (defined length) | NCHAR | 1 | 15,000 | Characters |
NVARCHAR | 1 | 16,000 | Characters | |
Length of mixed character data (defined length) | MCHAR | 1 | 30,000 | Bytes |
MVARCHAR | 1 | 32,000 | Bytes | |
Precision of packed decimal | DECIMAL | 1 | 29 | Digits |
Decimal places for packed decimal | DECIMAL | 0 | 29 | Digits |
Seconds precision for timestamp data | TIMESTAMP | 0 | 6 | Digits |
Length of BLOB data | 0 | 2,147,483,647 | Bytes | |
BINARY data length (defined length) | 1 | 2,147,483,647 | Bytes | |
Number of columns in a table | 1 | 30,000 | Columns | |
Number of indexes in a table | 0 | 255 | Count | |
Number of index component columns | 1 | 16 | Columns | |
Number of cluster key component columns | 1 | 16 | Columns | |
Number of RDAREAs for storing table partitions | 1 | 1024 | Count | |
Number of BESs where partitioned tables are placed | 1 | 1024 | Count | |
Total number of literals specified for storage conditions when a row-partitioned table is defined (if storage condition is omitted, 1 is assumed) | 1 | 15,000 | Count | |
Number of tables based on view tables | 1 | 64 | Count | |
Number of columns in a view table | 1 | 30,000 | Columns | |
Number of primary key component columns | 1 | 16 | Columns | |
Number of foreign key component columns | 1 | 16 | Columns | |
Number of foreign keys per table | 0 | 255 | Count | |
Number of foreign keys that reference a single primary key | 0 | 255 | Count | |
Number of check constraints that can be specified per table | 0 | 254 | Count | |
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) | 0 | 254 | Count | |
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) | 1 | 30 | Bytes | |
Row length of FIX table | 1 | 30,000 | Bytes | |
Number of SQL parameters in a procedure | 0 | 30,000 | Count | |
Number of repetition columns | 2 | 30,000 | Count | |
Number of index information files created per server | HP-UX | 1 | 7,616 to 8,0921 | Count |
Solaris | 1 | 1,472 to 1,9481 | Count | |
Solaris(64-bit mode) | 1 | 7,616 to 8,0921 | Count | |
AIX 5L | 1 | 7,616 to 8,0921 | Count | |
Linux | 1 | 448 to 9241 | Count | |
Number of processed rows that can be displayed in messages by the following utilities:
| 0 | 4,294,967,2952 | Count |