IC72114: IT IS POSSIBLE TO UPDATE FLOAT COLUMNS TO OUT OF RANGE VALUES WHICH CAUSES DBIMPORT AND LOAD TO FAIL WITH ERROR -1223

APAR status

• Closed as fixed if next.

Error description

• It is possible to update float columns to values which causes
  dbimport and load to fail with error -1223.
  
  The following update statement does not raise an error:
  
  update tab1 set f1 = 1.11e-307/10;
  
  select * from tab1;
  
             f1
  1.110000e-308
  
  
  An insert of this value will fail with
    204: An illegal floating point number has been found in the
  statement.
  
  A load of the same value will fail with
    1223: Value will not fit in a FLOAT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of all released versions on certain platforms such as  *
  * Solaris, AIX, MacOS                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IDS allows the underflow of a float value during update and  *
  * unload operations but not during insert and load operations. *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * The fix is to allow underflow by default during insert,      *
  * load, dbimport operations.                                   *
  * For those customers who do not want this behavior change,    *
  * they can revert back to the old behavior by using the        *
  * onconfig variable (IGNORE_UNDERFLOW, default value = 1) on   *
  * the server side and the environment variable                 *
  * (IGNORE_UNDERFLOW, default value = 1) on the client side.    *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

• http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp
  For download information, go to:
  http://www.ibm.com/support/fixcentral
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• RB15 PSY

     UP