Implementing Siebel Business Applications on DB2 UDB for z/OS > Customizing a Development Environment > Siebel Tools Considerations on DB2 for z/OS >

Truncation of Unique Index Columns

Indexes on DB2 for z/OS v7 are limited to 255 characters (this limitation does not apply to DB2 for z/OS v8).

If you customize your development environment without setting the database options for DB2 for z/OS, your indexes might be truncated upon migration to the DB2 host and could become nonunique. For more information, see Setting Database Options.

When you analyze your business needs, if the unique indexes seem too long, it is recommended that you reduce the field lengths.