Max Index Keys / UDB


Max Index Keys / UDB
Our client has db2/zos and UDB/win2003. They have an UNIQUE index defined on one of the tables with 25 key columns. We are trying to setup a warehouse table on UDB with the same structure. Since UDB has limit of 16 keys/index (on mainframe we have 64keys/index is the limit). How do we address this. Please advise.


Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at