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. 22.214.171.1240
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.
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.
I received the DDL. Thanks 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.
Thank you for your efforts.