-676 THE PHYSICAL CHARACTERISTICS OF THE INDEX ARE INCOMPATIBLE WITH RESPECT TO THE SPECIFIED STATEMENT. THE STATEMENT HAS FAILED. REASON reason-code
Explanation
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.
System action
The statement cannot be processed.
Programmer response
Depending on the reason
code value, take the following action:
- 0001
- Change the buffer pool specification to the name of a buffer pool with a 4KB page size.
- 0002
- Modify the statement so that is does not result in a compressed index with a 4 KB page size.
- 0003
- ALTER the STOGROUP to use a DB2 managed data set or change the CISIZE of the user-managed data set to be compatible with the specified index options. If the index is compressed, the CISIZE must be 4KB. Otherwise, the CISIZE should match the page size or be 4KB.
SQLSTATE
53041