In this post, you will see the maximum size of different DB2 objects.
| Item | Limit |
| Longest alias, synonym, collection ID, correlation name, statement name, or name of a column, cursor, index, table, view, or table check constraint | 18 bytes |
| Longest authorization name, package name, or name of a plan, database, table space, storage group, or referential constraint | 8 bytes |
| Longest host identifier | 64 bytes |
| Longest server name or location identifier | 16 bytes |
Related Posts






