We've been creating feature classes in new Enterprise GIS based on DB2 database. The new feature classes are created based on importing/loading data from the existing feature classes on different database. We encountered a problem with data loading when we imported a feature class with two fields set as double with precision 31 and scale 8 in the old environment, but updated the precision and scale to 9 and 5 respectively in the new environment. We get the consistent error and can't load the data.
Underlying DBMS error [[IBM][CLI Driver]CLI0111E Numeric value out of range. SQLSTATE=22003::22003]
Any thoughts please?