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

Discover more from Srinimf

Subscribe now to keep reading and get access to the full archive.

Continue reading