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

SAP Knowledge Base Article - Preview

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

Symptom

  • 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";


Read more...

Environment

  • SAP PowerDesigner (PD) 16.6
  • IBM DB2

Product

SAP PowerDesigner 16.6

Keywords

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

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.