IC88560: WHEN CALLING A DATABLADE FROM WITHIN A TRIGGER, THE DATABLADE STORES THE VALUES FOR THE ROWS IN THE CMD POOL, WHICH LEADS TO A

APAR status

• Closed as program error.

Error description

• When defining an update trigger for a row like the following:
  
  update trigger
  execute procedure insert
  
  where insert is a datablade using the values from the update to
  insert into a new table the datablade is writing the values into
  the command trigger.
  
  If then an update is run, which is using all the rows in the
  table, the CMD pool for this statement will grow, as all values
  are kept in there until the update statement is complete.
  
  The datablade is using the default memory duration, which should
  be "per Routine", changing the default
  memory duration does not help.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * those using sapi functions mi_trigger_get_old_row() and      *
  * mi_trigger_get_new_row()                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IDS-11.50.xC10 and modify datablade code to use    *
  * mi_set_row_desc_duration()                                   *
  ****************************************************************
  

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 PSN

     UP