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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.