2463799 - DB2 tablespace is unnecessarily altered right after it is created - SAP PD

• At least one tablespace's physical option has changed and a table created in this tablespace has been modified.
• The tablespace is dropped and created again in the generated SQL file.
• An unnecessary ALTER TABLESPACE statement is generated right after CREATE TABLESPACE to define the same option again.
• As an example,

drop tablespace TABLESPACE_1;

create tablespace TABLESPACE_1
in DSNDB04
maxpartitions 1 numparts 1
bufferpool BP4;

alter tablespace TABLESPACE_1
bufferpool BP4;

create table TABLE_1 (
COLUMN_1 CHAR(10)
)
in DSNDB04.TABLESPACE_1;

• SAP PowerDesigner (PD) 16.6
• IBM DB2 for z/OS

db2mvs, physical, space, additional, 807617, CR807617, CR#807617 , KBA , BC-SYB-PD , PowerDesigner , Problem