No need to recreate table when adding new columns to end of table !

Toad for IBM DB2
1

Hi,

I tried to add two new columns (STAGE_PROCESSED_DTTM Timestamp, REPORTS_AVAILABLE_DTM Timestamp) to end of existing table from “DB Browser > Tables > Alter table” and Toad generated script with recreation of table and all dependent objects. It should be done just with alter command:

ALTER TABLE ADM.T_A_POPULATION ADD COLUMN STAGE_PROCESSED_DTTM TIMESTAMP;

ALTER TABLE ADM.T_A_POPULATION ADD COLUMN REPORTS_AVAILABLE_DTM TIMESTAMP;

Tested successfully - Toad for DB2. 5.5.0.480

Tnx,

Ivan

2

Hi, Ivan,

I’m not able to reproduce this error on a simple table. I need some information to investigate the problem.

Is your database on z/OS or LUW, and what version of DB2 is the database?

Is the table range clustered or a typed table? If you can, please send me the DDL for the table and it’s dependents.

Regards,

Adam

3

Hi Adam,

Database is DB2 LUW 10.1 FP 3 on Linuxx64- DPF database with 9 logical partitions (0-8) and table is distributed by hash.

Please check your PM for ddl.

Regards,

Ivan

4

I received the DDL. Thanks Ivan.

5

Hi Ivan,

The view on the table is causing the problem. I opened issue TDB-371 to track this issue.

Thank you for reporting this bug and providing the details. We appreciate it.

Adam

6

Hi Alan,

Thank you for your efforts.

Regards,

Ivan