Oninit cdi / Archive
Talk to an expert →

trim error under heavy load (14.10.FC3WE)

Posted in 2020

Summary

Marc Demhartner saw SQLCODE -879 (22027 trim error) in SPLs under heavy load on 14.10.FC3WE with RHEL8, but not under light load, and nothing in the online log. Art Kagel said FC3 was rather buggy and advised upgrading to FC4W1 or FC5. Rainer von Bongartz, Tom Girsch and SangGyu Jeong confirmed FC5 was available for download. The cause was not identified.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Stored Procedures & SPL, Error Codes & Troubleshooting

Marc Demhartner — source: IBM Community (ConnectedCommunity.org) Informix forum

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 errorIf 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 ------------------------------ #Informix

↪ replying to Marc Demhartner
Art Kagel — source: IBM Community (ConnectedCommunity.org) Informix forum

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 ------------------------------

↪ replying to Art Kagel
Rainer von Bongartz — source: IBM Community (ConnectedCommunity.org) Informix forum

Hi Art, is FC5 already available ? I could not find it on the IBM MRS site Regards Rainer ------------------------------ Rainer von Bongartz ------------------------------

↪ replying to Rainer von Bongartz
Art Kagel — source: IBM Community (ConnectedCommunity.org) Informix forum

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 Shard Join enhancements InformixHQ enhancements ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

↪ replying to Rainer von Bongartz
TOM GIRSCH — source: IBM Community (ConnectedCommunity.org) Informix forum

I was able to download 14.10.FC5 via passport advantage today. ------------------------------ TOM GIRSCH ------------------------------

↪ replying to Marc Demhartner
SangGyu Jeong — source: IBM Community (ConnectedCommunity.org) Informix forum

I also got version 14.10.FC5 from the Software Access Catalog two days ago. :) ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------

Related threads

Glossary