shah_bs
19th February 2009, 16:54
I am looking for a 'second look' at what I am about to do.
The question is specifically about the domain tieser.a (Effective Unit Series) - at present, this domain has Legal Characters defined as
ABCDEFGHIJKLMNOPQRSTUVWXYZ" "
Due to a business requirement, I am going to remove the contents of the Legal Characters field, so that the domain will allow all characters to be entered.
My question is:
Since the change is relaxing on the validation, is it really necessary to do a "reconfigure tables" for this change, since only the validation has changed? Only future data is going to be 'non-conforming' to the old validation. The reason for this question is that, the reconfigure tables will reconfigure approximately 70 tables, some of which [example, ticst951, tisfc951, tipgc500] are more than half-million records each, and there is no 'quiet time' window available to do this.
I do realize that there is no 'going back' once this is in place without a lot of pain ...
The question is specifically about the domain tieser.a (Effective Unit Series) - at present, this domain has Legal Characters defined as
ABCDEFGHIJKLMNOPQRSTUVWXYZ" "
Due to a business requirement, I am going to remove the contents of the Legal Characters field, so that the domain will allow all characters to be entered.
My question is:
Since the change is relaxing on the validation, is it really necessary to do a "reconfigure tables" for this change, since only the validation has changed? Only future data is going to be 'non-conforming' to the old validation. The reason for this question is that, the reconfigure tables will reconfigure approximately 70 tables, some of which [example, ticst951, tisfc951, tipgc500] are more than half-million records each, and there is no 'quiet time' window available to do this.
I do realize that there is no 'going back' once this is in place without a lot of pain ...