I have a column declared as Decimal (12,0). GUI passses the data to MF stored procedures.
Till last week, we were able to pass the data to MF SP's with out any issues. Over the week end, DB2 V10 upgrade happened.
Thereafter even if try to pass 11 decimal values to MF SP it is getting resulted in below error. But i could able to see the value which are greater than the value which i am passing today is already available in Table , with the date in last week.
"Invalid data conversion: Requested conversion would result in a loss of precision of XXXXXXXXXX, Error code: -461, Sqlstate = -42815"
There was no changes happened to Source components over the week end nor any significant data change from Business side.
At the same time, i am not sure whether this error is because of version upgrade, cannot point that with out knowing the actual reason.
Please let me know if any one of is aware of such issues and the solutions you have tried.