Change Bufferpool to 32k results in a DROP and CREATE using RC/Migrator

Products

• RC/Migrator for DB2 for z/OS
• RC Compare for DB2 for z/OS

Issue/Introduction

When altering the Bufferpool (BP1 to BP32K) of a Tablespace, RC/Migrator for Db2 for z/OS (RCM) generates a DROP and CREATE rather than an ALTER.
Why does RC/Migrator not henerate an ALTER TABLESPACE.

Resolution

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.