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