-671   THE BUFFERPOOL ATTRIBUTE OF THE TABLE SPACE CANNOT BE ALTERED AS SPECIFIED BECAUSE IT WOULD CHANGE THE PAGE SIZE OF THE TABLE SPACE

Explanation

For example, the change to the buffer pool attribute for the table space specified in the ALTER TABLESPACE statement would change the page size of the table space—either from 4KB to 32KB, 8KB to 16KB, or vice versa.

Use of the ALTER TABLESPACE statement to change the page size of a table space is not permitted.

System action

The statement cannot be processed. The table space definition was not altered.

Programmer response

For example, if the table space uses one of the 4KB buffer pools (for example, BP0, BP1, or BP2), it can be reassigned to one of the other 4KB buffer pools (but not buffer pool BP32K). If, however, it is assigned to buffer pool BP32K, the buffer pool assignment cannot be subsequently altered.

SQLSTATE

53040