DB2 SQL-Error: -671
SQLState: 53040
Short Description: THE BUFFERPOOL ATTRIBUTE OF THE TABLE SPACE CANNOT BE ALTERED AS SPECIFIED BECAUSE IT WOULD CHANGE THE PAGE SIZE OF THE TABLE SPACE
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 executed. 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.