DB2 12 - SQL - Limits in DB2 for z/OS
Db2® for z/OS® has system limits, object and SQL limits, length limits for identifiers and strings, and limits for certain data type values.
System storage limits might preclude the limits specified in this section. The limit for items not that are not specified below is limited by system storage.
The following table shows the length limits for identifiers.
Otherwise, 32704 bytes
Otherwise, 16352 double-byte characters
4096, depending on what is specified for DSSIZE or LARGE and the page size.
For table spaces that are defined with LARGE or a DSSIZE of 4 GB:
For table spaces that are defined with a DSSIZE greater than 4 GB:
For partition-by-range table spaces with relative numbering:
For 5-byte EA table spaces:
For table spaces that are defined with LARGE:
Where n is the number of columns in the key that allow nulls and m is the number of varying-length columns in the key
2147483647 bytes (2 GB - 1 byte) for a LOB, subject to the limitations that are imposed by the application environment and host language
2147483647 bytes (2 GB - 1 byte) for a LOB, subject to the limitations imposed by the application environment and host language