DB2: The Maximum Size of Its Objects

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.