SAP Knowledge Base Article - Preview

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

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.