Most columns in a tableg | 1 012 |
Most columns in a viewa | 5 000 |
Maximum length of a row including all overheadb g | 32 677 |
Maximum size of a table per partition (in gigabytes)c g | 512 |
Maximum size of an index per partition (in gigabytes) | 512 |
Most rows in a table per partition | 4 x 109 |
Longest index key including all overhead (in bytes) | 1 024 |
Most columns in an index key | 16 |
Most indexes on a table | 32 767 or storage |
Most tables referenced in an SQL statement or a view | storage |
Most host variable declarations in a precompiled programc | storage |
Most host variable references in an SQL statement | 32 767 |
Longest host variable value used for insert or update (in bytes) | 2 147 483 647 |
Longest SQL statement (in bytes) | 7 2 097 152 |
Most elements in a select listg | 1 012 |
Most predicates in a WHERE or HAVING clause | storage |
Maximum number of columns in a GROUP BY clauseg | 1 012 |
Maximum total length of columns in a GROUP BY clause (in bytes)g | 32 677 |
Maximum number of columns in an ORDER BY clauseg | 1 012 |
Maximum total length of columns in an ORDER BY clause (in bytes)g | 32 677 |
Maximum size of an SQLDA (in bytes) | storage |
Maximum number of prepared statements | storage |
Most declared cursors in a program | storage |
Maximum number of cursors opened at one time | storage |
Most tables in an SMS table space | 65 534 |
Maximum number of constraints on a table | storage |
Maximum level of subquery nesting | storage |
Maximum number of subqueries in a single statement | storage |
Most values in an INSERT statementg | 1 012 |
Most SET clauses in a single UPDATE statementg | 1 012 |
Most columns in a UNIQUE constraint (supported via a UNIQUE index) | 16 |
Maximum combined length of columns in a UNIQUE constraint (supported via a UNIQUE index) (in bytes) | 1 024 |
Most referencing columns in a foreign key | 16 |
Maximum combined length of referencing columns in a foreign key (in bytes) | 1 024 |
Maximum length of a check constraint specification (in bytes) | 65 535 |
Maximum number of columns in a partitioning keye | 500 |
Maximum number of rows changed in a unit of work | storage |
Maximum number of packages | storage |
Most constants in a statement | storage |
Maximum concurrent users of serverd | 64 000 |
Maximum number of parameters in a stored procedure | 32 767 |
Maximum number of parameters in a user defined function | 90 |
Maximum run-time depth of cascading triggers | 16 |
Maximum number of simultaneously active event monitors | 32 |
Maximum size of a regular DMS table space (in gigabytes)c g | 512 |
Maximum size of a long DMS table space (in terabytes)c | 2 |
Maximum size of a temporary DMS table space (in terabytes)c | 2 |
Maximum number of databases per instance concurrently in use | 256 |
Maximum number of concurrent users per instance | 64 000 |
Maximum number of concurrent applications per database | 60 000 |
Maximum number of connections per process within a DB2 client | 512 |
Maximum depth of cascaded triggers | 16 |
Maximum partition number | 999 |
Most table objects in DMS table spacef | 51 000 |
Longest variable index key part (in bytes)h | 1022 or storage |
Maximum number of columns in a data source table or view that is referenced by a nickname | 5 000 |
Maximum NPAGES in a buffer pool for 32-bit releases | 1 048 576 |
Maximum NPAGES in a buffer pool for 64-bit releases | 2 147 483 647 |
Maximum total size of all buffer pool slots (4K) | 2 147 483 646 |
Maximum number of nested levels for stored procedures | 16 |
1 Maximum number of table spaces in a database | 1 32 768 |
Maximum number of attributes in a structured type | 4082 |
Maximum number of simultaneously opened LOB locators in a transaction | 32 100 |
Notes:
- a This maximum can be achieved using a join in the CREATE VIEW statement. Selecting from such a view is subject to the limit of most elements in a select list.
- b The actual data for BLOB, CLOB, LONG VARCHAR, DBCLOB, and LONG VARGRAPHIC columns is not included in this count. However, information about the location of that data does take up some space in the row.
- c The numbers shown are architectural limits and approximations. The practical limits may be less.
- d The actual value will be the value of the MAXAGENTS configuration parameter.
- e This is an architectural limit. The limit on the most columns in an index key should be used as the practical limit.
- f Table objects include data, indexes, LONG VARCHAR or VARGRAPHIC columns, and LOB columns. Table objects that are in the same table space as the table data do not count extra toward the limit. However, each table object that is in a different table space than the table data does contribute one toward the limit for each table object type per table in the table space in which the table object resides.
- g For page size-specific values, seeTable 12 .
- h This is limited only by the longest index key, including all overhead (in bytes). As the number of index key parts increases, the maximum length of each key part decreases.
|