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 number
IC72114
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-10-21
Closed date
2011-09-27
Last modified date
2011-09-27
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
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
27 September 2011