The following table describes certain DB2 Everyplace and SQL limits. Adhering
to the most restrictive case can help the programmer design application programs
that are easily portable. Many of these limits might be further restricted
due to physical memory and system limitations imposed by the devices.
ǥ 157. DB2 Everyplace database and SQL limits
| Description | Limit |
|---|---|
| Maximum table size (on a 32 bit system) | 2 Gigabytes |
| Maximum length of a database | 75 bytes |
| Maximum number of tables in a data store | 65535 |
| Maximum number of indices on a table | 15 |
| Maximum number of foreign keys in a table | 8 |
| Maximum number of columns in an index | 8 |
| Maximum number of columns in a primary key | 8 |
| Maximum length of SQL statement | 64 kilobytes |
| Maximum number of connections to a data store path | 1 |
| Maximum number of rows in a table | Limited by table size |
| Maximum number of columns in a table | 256 |
| Maximum length for a CHAR column | 32767 bytes |
| Maximum length for VARCHAR or BLOB column | 32767 bytes |
| Maximum cumulative length for a row's 32767 fixed-length columns | 32767 bytes |
| Maximum number of statement handles per connection | 20 |
| Maximum length of check constraints | 512 bytes |
| Maximum size of decimals | 31 digits |
| Maximum length of each column in a single index | 1024 bytes |
Related reference