Change Bufferpool to 32k results in a DROP and CREATE

Document ID : KB000117451
Last Modified Date : 31/12/2018
Show Technical Document Details
Question:
When altering the Bufferpool (BP1 to BP32K) of a Tablespace, RC Migrator generates a DROP and CREATE rather than an ALTER.

Why doesn't RC/Migrator generate an ALTER TABLESPACE?
Answer:
In this scenario, RC/Migrator reflects the functionality provided by the DB2 ALTER statement. With DB2, an ALTER statement with a BUFFERPOOL clause, where a different page size is specified, is allowed only for LOB and Universal table spaces (excluding XML table spaces). In this particular case, the Tablespace is a regular segmented Tablespace, so RC/Migrator generates DROP/CREATE since ALTER is not allowed.