| Item |
Limite |
| Maximum number of columns in a table or view (the value
depends on the complexity of the CREATE VIEW statement) |
750 or fewer
749 if the table is a dependent |
| Maximum number of base tables in a view |
225 |
| Maximum row and record sizes for a table |
See "Maximum record size" in topic 6.24
under CREATE TABLE |
| Maximum number of volume IDs in a storage group |
133 |
| Maximum number of partitions in a partitioned table space
or partitioned index |
64 for table spaces that are not defined
with LARGE or a DSSIZE greater than 2G
254 for table spaces that are defined
with LARGE or a DSSIZE greater than 2G |
| Maximum size of a partition (table space or index) |
For table spaces that are not defined
with LARGE or a DSSIZE greater than 2G::
4 gigabytes, for 1 to 16 partitions
2 gigabytes, for 17 to 32 partitions
1 gigabyte, for 33 to 64 partitions
For table spaces that are large:
4 gigabytes, for 1 to 254 partitions
For table spaces that are defined with a DSSIZE greater than 2G:
64 gigabytes, for 1 to 254 partitions |
| Maximum size of a DBRM entry |
131072 bytes |
| Longest index key |
255 bytes less the number of key columns that allow nulls. See
Table 18 in topic 6.20. |
| Maximum number of bytes used in the partitioning of a partitioned index
(30) |
40 |
| Maximum number of columns in an index key |
64 |
| Maximum number of tables in a FROM clause |
225 or fewer, depending on the complexity of the statement |
| Maximum total length of host and indicator variables pointed to in an SQLDA |
32767 bytes
2 147 483 647 bytes (2 gigabytes - 1 byte) for a
LOB,
subject to the limitations imposed by the application
environment and host language |
| Longest host variable used for insert or update |
32704 bytes for a non-LOB
2 147 483 647 bytes (2 gigabytes - 1 byte)
for a
LOB, subject to the limitations imposed by the application
environment and host language |
| Longest SQL statement |
32765 bytes |
| Maximum number of elements in a select list |
750 or fewer, depending on whether the select list is for the result
table of a scrollable cursor (41) |
| Maximum number of predicates in a WHERE or HAVING clause |
750 |
| Maximum total length of columns of a query operation requiring a sort key
(SELECT DISTINCT, ORDER BY, GROUP BY, UNION without the ALL keyword, and the DISTINCT column function) |
4000 bytes |
| Maximum length of a table check constraint |
3800 bytes |
| Maximum number of parameters of a stored procedure and any CALL statement
referencing the procedure |
As many as can be defined by the parameter list stored in
SYSPROCEDURES.PARMLIST. The maximum length of the column is 3000 bytes. |
| Maximum number of bytes that can be passed in a single parameter of an SQL
CALL statement |
32765 bytes for a non-LOB
2 147 483 647 bytes (2 gigabytes - 1 byte) for a
LOB,
subject to the limitations imposed by the application
environment and host language |
| Maximum number of stored procedures, triggers, and user-defined functions
that an SQL statement can implicitly or explicitly reference |
16 nesting levels |
| Maximum length of the SQL path |
254 bytes |
