-676   THE PHYSICAL CHARACTERISTICS OF THE INDEX ARE INCOMPATIBLE WITH RESPECT TO THE SPECIFIED STATEMENT. THE STATEMENT HAS FAILED. REASON reason-code

A reason code is issued during the processing of a CREATE INDEX or ALTER INDEX statement. When the statement fails, the reason for the failure is indicated by the following reason code value:

0001

You specified a buffer pool with a page size other then 4KB in the CREATE or ALTER INDEX statement.

0002

An ALTER INDEX or CREATE INDEX statement results in an invalid combination of a 4KB page size and COMPRESS YES. This reason-code will be issued for the following reasons:

• If you tried to CREATE or ALTER an index, you did not specify a buffer pool having a page size that is supported for index compression. You can only choose a buffer pool with an 8KB, 16KB, or 32KB page size for a compressed index.
• If you tried to ALTER an index using ALTER INDEX with the COMPRESS YES clause, then the existing index is not defined with a buffer pool that has an 8KB, 16KB, or 32KB page size, and therefore, the index cannot be compressed.

0003

The ALTER INDEX statement has resulted in an index that's on-disk page size in incompatible with the CISIZE of the index's underlying non-DB2® managed data set. This reason-code will be issued for the following reasons:

• If the index is not compressed, a 4 KB page size must reside in a data set that has a 4 KB CISIZE. A page size greater than 4KB must have a CISIZE that is either 4KB or equal to the page size.
• If the index is compressed, then the index pages on disk are always 4 KB. The CISIZE for the data set must also be 4KB.