Informix

nested-group-icon.png

DB2

Expand all | Collapse all

trim error under heavy load (14.10.FC3WE)

  • 1.  trim error under heavy load (14.10.FC3WE)

    Posted Mon December 14, 2020 05:23 AM
    Hello,

    we´re using RHEL8 64bit and 14.10.FC3WE - under heavy load running the same SPLs on different databases, we notice:

    DataError: SQLCODE -879 in EXECUTE:
    22027: Trim error

    If we run the same SPL under non heavy load, the error does not occure - with same data and same SPL.

    online log is empty, no error in informix.

    Any idea how we could pin down this?

    Thank you.

    ------------------------------
    Marc Demhartner
    ------------------------------


  • 2.  RE: trim error under heavy load (14.10.FC3WE)

    Posted Mon December 14, 2020 07:36 AM
    Note that v14.10FC3 was rather buggy. You should upgrade to .FC4W1 or, better, .FC5!

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: trim error under heavy load (14.10.FC3WE)

    Posted Mon December 14, 2020 08:03 AM
    Hi Art,
    is FC5 already available ?

    I could not find it on the IBM MRS site

    Regards
    Rainer

    ------------------------------
    Rainer von Bongartz
    ------------------------------



  • 4.  RE: trim error under heavy load (14.10.FC3WE)

    Posted Mon December 14, 2020 08:56 AM
    If v14.10.FC5 is not available yet, it should be very soon. It is mostly a bug fix release, but there are a couple of minor enhancements. The "What's New" pages have already been updated:

    What's new in IBM Informix version 14.10.xC5



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 5.  RE: trim error under heavy load (14.10.FC3WE)

    Posted Tue December 15, 2020 09:54 AM
    I was able to download 14.10.FC5 via passport advantage today.

    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 6.  RE: trim error under heavy load (14.10.FC3WE)

    Posted Wed December 16, 2020 01:26 AM
    I also got version 14.10.FC5 from the Software Access Catalog two days ago. :)

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------