Adding a column to a DD target

I am wondering if I was bitten by one of the IWDELTRACKER tables or something else completely.

We have had DD 6.0.1 running on Win2k deploying to DB2 for a while.

New requirement to add data to the DB. New column, not null. Admin put blanks in and kept the old data.

I added the entry into the deploy config file.

Strange thing that happened is that while DD returned success, no data (new column or old) changed.

If I added a new DCR, it worked great. I just could never change data that was in the DB before.

We dropped old records. DD worked great.

This was on our dev server. The issue is I need to go to production. Do I tell management that I need to drop all records in this table and run DD on everything ? That will not be popular.

Again, I have no idea if the admin who put the temp data in the column did something that prevented me from over writing it, or if there is something inside DD that I am not understanding.

Ring any bells for anyone ?

Andy

Find more posts tagged with

Comments

Opeth

I think it's a Teamsite DD Bug. I had the same issue. First my DD returned success and the new column data was not updated in my table and in my log. Later after few hours, my dd log was updated with the new column entry and the data has been updated to the table too.

If you look into DD log- you will see teamsite cache your table information into some TS system table. I don't know how often TS refresh its cache for the table information. I think there might be a way to force TS to refresh its cache.

If I find any other helpful info I'll post it here.

Best of luck.