Fixes are available
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
Instance crash with signal #11 in function sqlrxa2f(). This function is used for converting an ascii string value into a float datatype. Due to a timing issue where the locale settings have changed during execution of this function, it is possible that it may crash with signal #11. The following is an example stack traceback where this problem was seen, however any signal #11 stack traceback with sqlrxa2f() at the top as the calling function is a possible match to this problem: <StackTrace> -------Frame------ ------Function + Offset------ 0x09000000030E96C8 sqlrxa2f + 0xEC 0x0900000003B2E42C isXmlStringSpecialValue__FPUcUiPQ2_17xmlDataDescriptor9DataFlag s + 0x234 0x090000000467311C xmlvConvXmlStrToXmlBasicNumeric__FP6xmlvCBP10sqlz_valueT2Us + 0x360 0x090000000466AA04 xmlvCastFunc__F15SqlzXmlTypeCodeT1P6xmlvCBP10sqlz_valueT4Us + 0x6D4 0x09000000034374CC xmlvXmlCompareFunc__FP6xmlvCBP10sqlz_valueT215SqlzXmlTypeCodeT4 iPi + 0x678 0x0900000004698298 sqlriXmlGeneralComparison__FP8sqlrr_cb + 0x91C 0x0900000003D19E64 evalPredicate__14xmlnvXpathNodeFP14XmlnvAutomatonP8sqlrr_cbRbb + 0x84 0x0900000003D18940 m_checkConditions__14XmlnvAutomatonFP19XmlnvWorkArrayEntryiUiT3 PbRbT6 + 0x3C4 0x0900000003D17F34 m_closeMatchedEntry__14XmlnvAutomatonFiRiPb + 0x1CC 0x0900000003D101D0 endNode__14XmlnvAutomatonFPb + 0x238 0x0900000003D10834 m_exitSubtree__14XmlnvNavigatorFRbRQ2_14XmlnvNavigator12Navigat eFlag + 0x1E0 0x0900000003D056E0 m_traverse__14XmlnvNavigatorFb + 0x2160 0x0900000003D02278 getTuple__14XmlnvNavigatorFRbP8sqlrr_cb + 0xAC 0x0900000003D1CC30 m_repositionBindings__21XmlnvTupleConstructorFUiPb + 0x29C 0x0900000003D0EB0C m_findMatchingBindings__21XmlnvTupleConstructorFbPb + 0xAC 0x0900000003D08EAC m_getTupleBeforeWhere__21XmlnvTupleConstructorFRb + 0xADC 0x0900000003D031E0 getTuple__21XmlnvTupleConstructorFRb + 0x184 0x0900000003D0229C getTuple__14XmlnvNavigatorFRbP8sqlrr_cb + 0xD0 0x0900000003D2C04C sqlriXMLScan__FP8sqlrr_cb + 0x3C0 0x09000000026872E8 sqlriNljnPiped__FP8sqlrr_cb - 0x7C 0x090000000268A440 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x708 0x09000000026C48E4 sqlrr_process_fetch_request__FP14db2UCinterface + 0x150 0x09000000026BA390 sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x5D4 0x09000000027FC5EC sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x968 0x09000000027FBB3C sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterf ace + 0x4 0x09000000026BCB80 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 0x09000000026BE13C @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x160 0x0900000002554E88 @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 0x0900000002554BAC @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 0x0900000002554940 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x13C 0x0900000002557D8C RunEDU__8sqeAgentFv + 0x140 0x09000000025581D8 EDUDriver__9sqzEDUObjFv + 0x94 0x09000000025DD928 sqloEDUEntry + 0x228 </StackTrace> This APAR will close the timing window and prevent this problem from happening.
Local fix
Not available
Problem summary
Error desciption: Instance crash with signal #11 in function sqlrxa2f(). This function is used for converting an ascii string value into a float datatype. Due to a timing issue where the locale settings have changed during execution of this function, it is possible that it may crash with signal #11. The following is an example stack traceback where this problem was seen, however any signal #11 stack traceback with sqlrxa2f() at the top as the calling function is a possible match to this problem: <StackTrace> -------Frame------ ------Function + Offset------ 0x09000000030E96C8 sqlrxa2f + 0xEC 0x0900000003B2E42C isXmlStringSpecialValue__FPUcUiPQ2_17xmlDataDescriptor9DataFlag s + 0x234 0x090000000467311C xmlvConvXmlStrToXmlBasicNumeric__FP6xmlvCBP10sqlz_valueT2Us + 0x360 0x090000000466AA04 xmlvCastFunc__F15SqlzXmlTypeCodeT1P6xmlvCBP10sqlz_valueT4Us + 0x6D4 0x09000000034374CC xmlvXmlCompareFunc__FP6xmlvCBP10sqlz_valueT215SqlzXmlTypeCodeT4 iPi + 0x678 0x0900000004698298 sqlriXmlGeneralComparison__FP8sqlrr_cb + 0x91C 0x0900000003D19E64 evalPredicate__14xmlnvXpathNodeFP14XmlnvAutomatonP8sqlrr_cbRbb + 0x84 0x0900000003D18940 m_checkConditions__14XmlnvAutomatonFP19XmlnvWorkArrayEntryiUiT3 PbRbT6 + 0x3C4 0x0900000003D17F34 m_closeMatchedEntry__14XmlnvAutomatonFiRiPb + 0x1CC 0x0900000003D101D0 endNode__14XmlnvAutomatonFPb + 0x238 0x0900000003D10834 m_exitSubtree__14XmlnvNavigatorFRbRQ2_14XmlnvNavigator12Navigat eFlag + 0x1E0 0x0900000003D056E0 m_traverse__14XmlnvNavigatorFb + 0x2160 0x0900000003D02278 getTuple__14XmlnvNavigatorFRbP8sqlrr_cb + 0xAC 0x0900000003D1CC30 m_repositionBindings__21XmlnvTupleConstructorFUiPb + 0x29C 0x0900000003D0EB0C m_findMatchingBindings__21XmlnvTupleConstructorFbPb + 0xAC 0x0900000003D08EAC m_getTupleBeforeWhere__21XmlnvTupleConstructorFRb + 0xADC 0x0900000003D031E0 getTuple__21XmlnvTupleConstructorFRb + 0x184 0x0900000003D0229C getTuple__14XmlnvNavigatorFRbP8sqlrr_cb + 0xD0 0x0900000003D2C04C sqlriXMLScan__FP8sqlrr_cb + 0x3C0 0x09000000026872E8 sqlriNljnPiped__FP8sqlrr_cb - 0x7C 0x090000000268A440 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x708 0x09000000026C48E4 sqlrr_process_fetch_request__FP14db2UCinterface + 0x150 0x09000000026BA390 sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x5D4 0x09000000027FC5EC sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0x968 0x09000000027FBB3C sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterf ace + 0x4 0x09000000026BCB80 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 0x09000000026BE13C @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x160 0x0900000002554E88 @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 0x0900000002554BAC @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 0x0900000002554940 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x13C 0x0900000002557D8C RunEDU__8sqeAgentFv + 0x140 0x09000000025581D8 EDUDriver__9sqzEDUObjFv + 0x94 0x09000000025DD928 sqloEDUEntry + 0x228 </StackTrace> This APAR will close the timing window and prevent this problem from happening.
Problem conclusion
Problem was first fixed in DB2 UDB Version 9.5 Fix Pak 4
Temporary fix
Comments
APAR Information
APAR number
IZ38792
Reported component name
DB2 UDB WSE AIX
Reported component ID
5765F3500
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-11-27
Closed date
2009-03-18
Last modified date
2009-03-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 UDB WSE AIX
Fixed component ID
5765F3500
Applicable component levels
R950 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950"}]
Document Information
Modified date:
03 October 2021