IC86670: AF IN COMP_UDR WHEN EXECUTING A PREPARED SQL STATEMENT THAT CONTAINS DATE DATA TYPE, MANY HOST VARIABLES AND SET STMT_CACHE TO 2

APAR status

• Closed as program error.

Error description

• Assert Failed in comp_udr() when you execute a prepared SQL
  statement with many host variables and the
  onconfig parameter STMT_CACHE set to 2.
  
  
  Stack of the Assert Failed:
  
  comp_udr
  comp_expr
  comp_and_or
  comp_expr
  comp_and_or
  comp_expr
  comp_case
  comp_expr
  compile_expression
  dogen3
  itcallbldquery
  itcallbldquery
  itbldroot
  qd_bldroot_on_cb_hierarchy
  qd_bldroot
  ssc_link
  parsecmd
  sqcmd
  sq_cmnd
  sq_prepare
  sqmain
  spawn_thread
  startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users that use statement cache and use host variables in     *
  * aggregate can see this issue.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.50.xC10                                     *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IDS-11.50.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

• RB50 PSY

     UP