RoundHalfwayMagUp

Database
Teradata Employee

RoundHalfwayMagUp

We are considering changing this system setting to TRUE in a new financial data-warehouse. Are there any known issues setting this to TRUE? I don't need a discussion on the benefits etc....I just want to know if anybody has reported any bugs or problems with it.

Thanks

1 REPLY
Teradata Employee

Re: RoundHalfwayMagUp

Not aware of any "bugs". If you have any tables with PPI where the partitioning expression includes DECIMAL calculations, you need to ALTER TABLE ... REVALIDATE PRIMARY INDEX WITH {DELETE|INSERT} after you change the value of this setting.