IT27522: THE FUNCTION DELRANGE SOMETIMES FAILS TO DELETE ENTRIES / ELEMENTS

APAR status

• Closed as program error.

Error description

• Running the following SQL ...
  
  update meter_ts_tbl set
  para_values=DELRANGE(para_values,'2017-09-29
  00:00:00.00000'::datetime year to fraction(5),'2017-09-30
  00:00:00.00000'::datetime year to fraction(5)) where
  para_id=102211047;
  
  ... the following SQL was run before and after the update and it
  shows the same number ...
  
  select count(*), para_id from vt_meter_ts_tbl where
  date1>'2017-09-29 00:00:00' and date1<'2017-09-30 00:00:00'
  group by para_Id;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS 12.10.xC10 or older versions.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The function delrange sometimes fails to delete entries /    *
  * elements.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 12.10.xC11.
  

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