This appendix on DB2 limits contains a quick reference for information often sought after by DBAs and application developers alike on architectural limits in DB2. The appendix provides limit definitions in the following areas:
Identifier length limits
Database manager limits
Database manager page-size–specific limits
By developing applications within these limits, you will enable applications to be easily portable across the DB2 family.
The following limit information is taken from Appendix A of IBM’s DB2 9 SQL Reference, Volume 1, and is used with permission.
Identifier Length Limits
Limit (in bytes)
Authorization name (can be single-byte characters only) ...