Join / Log in
Hi Sandip, the solution is: set AUTOLOCATE greater as the default 0. e.g. AUTOLOCATE=1 . This will bring you back to the same performance as before.BUT: Please note, that AUTOLOCATE have many site effects during creating tables/indizes AND during Fragment extensions at runtime.We ( leolo IT) working hard with Informix advanced support at TS004062092. The behavior of AUTOLOCATE is not deep enough tested from the R&D team. Means, we run in some funny auto creation of new table partitions (nobody fin the reason until, yet).
At summary: your performance issue will fixed, but please note the unstable behavior of the AUTOLOCATE > 0 setting. Maybe you set this in your session local to push this special batch job.
Be care, Henri