Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Customizing a Development Environment > Siebel Tools Considerations on DB2 UDB for z/OS and OS/390 >
Reducing Field Lengths of Unique Indexes to Avoid Truncation
Indexes on DB2 UDB for z/OS and OS/390 are limited to 255 characters. If you customize your development environment without setting the database options for DB2 UDB for z/OS and OS/390, your indexes might be truncated upon migration to the DB2 host and could become nonunique. For more information, see Setting Database Options.
When analyzing your business needs, if the unique indexes seem too long, it is recommended that you reduce the field lengths.