IT22102: ASSERT FAILURE WHEN INSERTING INTO EXTERNAL TABLES AND PDQ IS SET

APAR status

• Closed as program error.

Error description

• You'll get different Assert Failures like:
  
  Linux:
  
  11:12:53  Stack for thread: 155 xlcnv_1.0
  
   base: 0x00000000476c4000
    len:   102400
     pc: 0x00000000013e7ba9
    tos: 0x0000000044a190b0
  state: running
     vp: 1
  
  (oninit) afstack
  (oninit) mt_ex_throw_sig
  (oninit) afsig_handler
  (Linux) <signal frame>
  (oninit) xchg_next
  (oninit) xlc_next
  (oninit) producer_thread
  (oninit) startup
  
  or
  
  11:12:52  Stack for thread: 150 sqlexec
  
   base: 0x00000000475e5000
    len:   102400
     pc: 0x00000000013e7ba9
    tos: 0x00000000477db0b0
  state: running
     vp: 11
  
  (oninit) afstack
  (oninit) mt_ex_throw_sig
  (oninit) afsig_handler
  (Linux) <signal frame>
  (oninit) mt_shm_free_pool
  (oninit) destroy_session
  (oninit) sq_exit
  (oninit) sqmain
  (oninit) spawn_thread
  (oninit) th_init_initgls
  (oninit) startup
  
  
  HP:
  
  13:48:06  Stack for thread: 9767 xlread_2.0
  
   base: 0xc00000016c292000
    len:   1052672
     pc: 0x0000000000000000
    tos: 0xc0000001186915c0
  state: running
     vp: 15
  
  (ormix1210FC9/bin/oninit)afstack
  (ormix1210FC9/bin/oninit)mt_ex_throw_sig
  (ormix1210FC9/bin/oninit)afsig_handler
  (ormix1210FC9/bin/oninit)producer_thread
  (ormix1210FC9/bin/oninit)startup
  (ormix1210FC9/bin/oninit)_FPU_STATUS
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * informix user with access external table with PDQ            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC10                     *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC10
  

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels

• RA10 PSY

     UP