Symptom
- 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;
Read more...
Environment
- SAP PowerDesigner (PD) 16.6
- IBM DB2 for z/OS
Product
SAP PowerDesigner 16.6
Keywords
db2mvs, physical, space, additional, 807617, CR807617, CR#807617 , KBA , BC-SYB-PD , PowerDesigner , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.