IZ01116: POSSIBLE SEGMENT FAULT WHEN LOAD WITH CLOB DATA AND CODEPAGE CONVERSION FROM MULTIBYTE SOURCE CP TO MULTIBYTE TARGET CP.

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• While attempting to codepage convert data, the Load utility may
  encounter a boundary scenario where the last byte of lob data
  residing in the read buffer is actually a partial byte of a
  multibyte character. Load handles this boundary scenario
  incorrectly and may result in a trap/seg-fault/instance crash.
  Often the callstack of the offending process is not available.
  
  A symptom which has been found can be described as follow:
  When load an ixf data file with CLOB data, db2 load will ended
  with error SQL1224N, which means instance has already crashed.
  The trap/dump file of the db2 load process could not be found.
  Only its parent db2agent process could be found.
  The db2diag.log shows these:
  
  2007-06-27-01.23.37.133119-240 I3934A486          LEVEL: Warning
  PID     : 24215                TID  : 1           PROC :
  db2lfrm0
  INSTANCE: dbguest3             NODE : 000         DB   : TEST1
  APPHDL  : 0-7                  APPID:
  *LOCAL.dbguest3.070627051908
  FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg,
  probe:0
  DATA #1 : String, 130 bytes
  LOADID: 24139.2007-06-27-01.23.36.581839.0 (2;2)
  Starting LOAD phase at 06/27/2007 01:23:37.106373. Table
  DBGUEST3.T_WFR_PROCDEF
  
  2007-06-27-01.23.40.136852-240 E4421A1331         LEVEL: Severe
  PID     : 24139                TID  : 1           PROC :
  db2agent (TEST1)
  INSTANCE: dbguest3             NODE : 000         DB   : TEST1
  APPHDL  : 0-7                  APPID:
  *LOCAL.dbguest3.070627051908
  FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler,
  probe:50
  DATA #1 : <preformatted>
  Detected the death of an EDU with process id 24215
  The signal number that terminated this process was 5
  Look for trap files (t24215.*) in the dump directory
  CALLSTCK:
    [0] 0xC000000003559760
  _ZN14sqeAppServices20ForceAllApplicationsEP18sqle_master_app_cbi
  ii + 0x1320
    [1] 0x00000000000000AF _user_sendsig:[***_Kernel_Gateway_***]
  + 0x0
    [2] 0xC000000000313230 sigprocmask + 0x30
    [3] 0xC0000000000C0B90 _pthread_callback_np + 0x1850
    [4] 0xC0000000000D1120 pthread_sigmask + 0x60
    [5] 0xC000000003B807D0
  _Z16sqlorqueInternalP13sqlo_que_descP12SQLO_MSG_HDRii + 0x4F0
    [6] 0xC000000003C13600 sqlorque2 + 0x130
    [7] 0xC0000000045C5580
  _Z10sqlulReadQP8sqlucacbP13SqluQueueInfoP12SQLO_MSG_HDRjiPP11Sql
  uEduInfoPiP5sqlca + 0x100
    [8] 0xC0000000048C3830
  _Z8sqlrlbotP20sqle_agent_privatecbP10sqledbdescs + 0x14A0
    [9] 0xC00000000494CF10
  _Z9sqluvloadPhS_P8SQLP_LSNP7sqlubmhPP15sqlu_media_listS6_P8SQLD_
  TCBhP26sqluCLoadRequestDescriptorP8sqluvlcbP5sqlcaPi + 0x1690
  

Local fix

• Use the Import utility.
  

Problem summary

• Users affected:
  V8, V91 and V95 on all platforms.
  
  Problem Description:
  Possible segment fault when load with clob data and codepage
  conversion from multibyte source cp to multibyte target cp.
  

Problem conclusion

• First fixed in DB2 UDB Version 8, FixPak 16.
  

Temporary fix

• Use the Import utility.
  

Comments

APAR Information

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

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

  IZ11362 IZ11363

Fix information

• Fixed component name

  DB2 UDB ESE HP-

• Fixed component ID

  5765F4103

Applicable component levels

• R810 PSY

     UP

• R820 PSY

     UP

• R910 PSY

     UP

• R950 PSY

     UP