Why is it useful?
|Who would benefit from this IDEA?||DBA's and vendor tools|
How should it work?
One idea is that if an immediate alter is issued and a deferred alter exists, then Db2 should undo the pending alter, apply the immediate alter, then redo the pending alter.
If they're compatible then fine. If they aren't compatible then Db2 undo the whole thing, which would leave the pending alter in place and fail the immediate alter.
A matrix with remaining incompatible Alters would also be helpful, perhaps in one of the manuals.
|Priority Justification||Db2 is becoming more and more complicated. The idea will reduce erros and increase availability when Alters are implemented.|