DW_LASTTIME TIMESTAMP NOT NULL GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP
The project died on the vine and I just found out that my online reorg script has been failing with this error.Online Reorg fails with SQL2219N Reason code: "13"
https://www.ibm.com/support/pages/online-reorg-fails-sql2219n-reason-code-13
I can't start doing offline reorgs due to the nature of the business so I would like to change that column to just a regular timestamp or date or varchar.ALTER table TESTTABLE ALTER COLUMN DW_LASTTIME SET DATA TYPE VARCHAR(30);
But when I try I getERROR [42837] [IBM][DB2/NT64] SQL0190N ALTER TABLE "AE" specified attributes for column "DW_LASTTIME" that are not compatible with the existing column.
I know I can drop it but I was trying to be less intrusive. Is there any way to change this sort of dropping the column?Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>
Our community of experts have been thoroughly vetted for their expertise and industry experience.