LI73896: SIGNAL 11 IN SQLV_HEX2HEXCHARS

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

• DB2 may trap in sqlv_hex2hexchars. Stack traceback may look
  like:
  
  <StackTrace>
  ---FUNC-ADDR---- ------FUNCTION + OFFSET------
  00002AC454480A61 ossDumpStackTrace + 0x007d
          (/opt/IBM/db2/V9.5/lib64/libdb2osse.so.1)
  00002AC45447C75E _ZN11OSSTrapFile4dumpEmiP7siginfoPv + 0x00aa
          (/opt/IBM/db2/V9.5/lib64/libdb2osse.so.1)
  00002AC45099CE20 sqlo_trce + 0x0342
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC4509D9B3F sqloEDUCodeTrapHandler + 0x0105
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC44E2DDE70 address: 0x00002AC44E2DDE70 ; dladdress:
  0x00002AC44E2D0000 ; offset in lib: 0x000000000000DE70 ;
          (/lib64/libpthread.so.0)
  00002AC4512C00FF sqlv_hex2hexchars + 0x0059
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC44FB5727D sqlnls_fill_error + 0x0119
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC44FB5BFD2 sqlnlscpRequestPkgInfo + 0x03d4
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC45155EB26 address: 0x00002AC45155EB26 ; dladdress:
  0x00002AC44E4EB000 ; offset in lib: 0x0000000003073B26 ;
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC45155BE79
  _Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP
  15db2UCCursorInfo + 0x0219
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC450B864AC _Z14sqlrr_execimmdP14db2UCinterface + 0x00b4
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC44FFD67C9
  _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject +
  0x00b5
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC44F5815A4
  _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
  Cinterface + 0x03e8
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC44F5818E9 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterface
  + 0x030d
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  00002AC44F57F520 address: 0x00002AC44F57F520 ; dladdress:
  0x00002AC44E4EB000 ; offset in lib: 0x0000000001094520 ;
          (/opt/IBM/db2/V9.5/lib64/libdb2e.so.1)
  
  or it may look like:
  
  0x09000000C5CE9F68 sqlv_hex2hexchars + 0x88
  0x09000000C5CE7DC0 sqlnls_fill_error + 0x280
  0x09000000C5F4C444 sqlnlscpRequestPkgInfo + 0x764
  0x09000000C5F35518
  sqlrr_rds_common_pre1__FP14db2UCinterfaceiT2Ui + 0x17D8
  0x09000000C5F376E8
  sqlrr_sql_request_pre__FP14db2UCinterfaceUiiP16db2UCprepareInfoP
  15db2UCCursorInfo + 0x6A8
  0x09000000C629C5A8 sqlrr_excsqlset__FP14db2UCinterface + 0x528
  0x090000000A3A7144
  sqljsParseExcSqlSetObjects__FP13sqljsDrdaAsCbP14db2UCinterface +
  0x344
  0x090000000A3A7E8C
  sqljs_ddm_excsqlset__FP14db2UCinterfaceP13sqljDDMObject + 0x16C
  
  The problem exists in DB2 v9.5 only
  
  
  Component: engn_nls
  Defect: WSDBU00373358
  

Local fix

• Local Fix / Work Around: Set APPHEAPSZ to a value instead of
                           AUTOMATIC.
  
  This may function as a work-around if the the db2diag.log
  contains "DIA8301C No memory available in the application heap"
  immediately prior to the crash.
  

Problem summary

• Users Affected:  All
  
  Problem Description. DB2 may trap in the sqlv_hex2hexchars
  function
  
  Problem Summary: DB2 may trap on the sqlv_hex2hexchars function.
  

Problem conclusion

• Problem first fixed in DB2 v9.5 FP4
  

Temporary fix

Comments

APAR Information

• 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 EXE LIN

• Fixed component ID

  5724E4904

Applicable component levels

• R950 PSY

     UP