반품
-
제목
Novalidate constraints script -
설명
We are on QSA 6.2.0 version and the coresponding space manager version.
When performing live reorg of some tables it is giving a caution that table has novalidate constraints and those to be validated before running the reorg. upon executing the script it is enabling some constarints on tables.
My question is this being reverted back once the reorg operation is done and keeping it in the original staet at which it was there for that table. and if not, will there be any impact with functionalitywise after reorg. we are yet to implemnet in production so please let us know clearly what exactly being done on the same.
-
해결 방안
If you want, you can manually change the constraints back to ENABLE NOVALIDATE after the reorganization is complete, but there is no reason to do so, in fact it is better to have constraints ENABLE VALIDATE.