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 for Me (Login required).

Search for additional results

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