Limits DB2 object names to know quickly

 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

Read for more detailed limits here.

Advertisements

Author: Srini

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