Here is The Permissible Length of DB2-Object-Names

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

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.