IC66549: SERVER ABENDS IN DRDA_PUT_LOB_CHK IF A SMART BLOB FOR STATEMENT S1 IS READ AFTER FETCHING ROWS FOR ANOTHER STATEMENT S2

APAR status

• Closed as program error.

Error description

• If a  statement S1 on a table with smart blob column is prepared
  and executed and this smart blob value is retrieved using read
  after preparing and executing another statement S2, an assert
  fail is seen and the server crashes.
  
  Here is a typical stack:
  
  Exception happened at address=0x0073c021
  Exception is EXCEPTION_ACCESS_VIOLATION (code 0xc0000005)
  Attempt to read location 0x1c
  Register Contents:
      EAX=0x1cb762e8  ESI=0x1cb76018  EFLAGS=0x00010297
      EBX=0x1cb76890  EDI=0x1cb762d0     EIP=0x0073c021
      ECX=0x00000001  ESP=0x1be7994c
      EDX=0x00000000  EBP=0x1be7994c
  Call Stack for thread #57 - drdaexec
  0x0073C021 (oninit)_drda_put_lob_chk (0x1CB762E8, 0x00100000,
  0x1BE79964, 0x1CB76018) ebp=0x1BE7994C
  0x007C3386 (oninit)_ifx_getnextchunk (0x1CB76890, 0x1CB76018,
  0x1CB76018, 0x00000014) ebp=0x1BE79968
  0x007D357C (oninit)_sqljcReceive (0x1CB76890, 0x1BE799D0,
  0x00213700, 0x1CB76890) ebp=0x1BE79990
  0x007DAE4B (oninit)_sqljcReceive (0x1CB76018, 0x1BFD78C0,
  0x1CB76890, 0x1CB76758) ebp=0x1BE799B0
  0x007DB431 (oninit)_sqljsParse (0x1CB76018, 0x1CB76890,
  0x00E4CA2B, 0x00213700) ebp=0x1BE799E4
  0x007C44CE (oninit)_do_drdamain (0x1BDFF608, 0x00000220,
  0x00CF360A, 0x002136F0) ebp=0x1BE79A30
  0x00445C3F (oninit)_drdamain (0x00000000, 0x6C9EEF60,
  0x00000000, 0x00000000) ebp=0x1BE79FB8
  0x00CBC152 (oninit)_startup (0x00000000, 0x00001000, 0x1BE7A698,
  0x1BE7A078) ebp=0x1BE79FF8
  Frame Pointer is NULL!
  Unable to continue stack trace back
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * users of IDS 11.10 and above                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Fetching lob data (large size) from the resultset after      *
  * another query is executed leads to server SEGV.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * upgrade to IDS 11.50.xC7 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in 11.50.xC7
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP