Specifying RECORDSIZE for an Alternate Index with Nonunique Keys

When you define an alternate index with many nonunique keys, specify a RECORDSIZE value that is large enough to handle all the nonunique keys. All occurrences of primary keys for a particular alternate key must be within a single alternate index logical record. If the maximum RECORDSIZE value is 1000, for example, you would not be able to support as many nonunique keys as you would if the maximum RECORDSIZE value were 5000. The maximum number of prime keys that a single alternate index logical record can contain is 32767.