IBM Support

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as duplicate of another APAR.

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

Problem conclusion

Temporary fix

Comments

  • This APAR is a duplicate of IT27522
    

APAR Information

  • APAR number

    IT22950

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED DUB

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-26

  • Closed date

    2019-09-23

  • Last modified date

    2019-10-08

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
08 October 2019