2560606 - Temporary table has no database/tablespace assigned and is not dropped - SAP PD

• In IBM DB2 for z/OS, a universal table space can hold one table only.
• Running Apply Model Changes to Database with the Backup tables option leads to 2 tables on the same universal table space: the temporary table and the table being recreated.
• The Drop temporary tables option is selected.
• Renaming or modifying a table, SAP PD generates:

create table "tmp_table" (
<columns>
);

insert into "tmp_table" (<columns>)
select <columns>
from "table_old";

create table "table_new" (
<columns>
)
in "database"."tablespace";

insert into "table_new" (<columns>)
select <columns>
from "tmp_table";

• The information where the temporary table is generated is missing.
• The temporary table is not dropped at the end of the SQL script.
• SAP PD should have generated:

create table "tmp_table" (
<columns>
)
in "database"."tablespace";

insert into "tmp_table" (<columns>)
select <columns>
from "table_old";

create table "table_new" (
<columns>
)
in "database"."tablespace";

insert into "table_new" (<columns>)
select <columns>
from "tmp_table";

drop table "tmp_table";

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP PowerDesigner (PD) 16.6
• IBM DB2

db2mvs, backup, CURRENT, SQLID, 811760, CR811760, CR#811760 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed