534 error occurs when executing set explain on
SangGyu Jeong's customer on 12.10.FC6WE got error 534 on SET EXPLAIN ON, even with a pre-created file and 777 permissions. Gaurav Kumar called it a known defect fixed in 12.10.FC13 and suggested onmode -Y. Art Kagel suspected the explain file could not be created. SangGyu said it ran as informix on the server and a restart may be needed. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All, My customer is using Informix 12.10.FC6WE and when they try set explain on statement they get 534 error. Below is a screenshot that reproduces the error. The set explain statement worked fine a few weeks ago. A customer has been checking query plans with InformixHQ recently, will calling ifx_explain or bson_explain affect this error? The customer tried to execute the set explain on statement in another path, created the file in advance with the touch command, or ran the set explain after accessing the database as the root user, but the same error occurred in 534. Setting file or directory permissions to 777 also doesn't help. From the APAR, I think the case below is similar. https://www.ibm.com/support/pages/apar/IT27606 The problem is that the cause of falling into this state is unclear. Is this an Informix defect or is there another cause? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------ #Informix
Yes its a known Informix defect and is fixed in 12.10.Fc13...
And can you also try dynamic sql plan using onmode -Y <sesid> 1 /tmp/sqexplain.out and see if that helps
Regards,
Gaurav
#Informix
Their problem is not setting explain on, it's creating the explain file. I'm guessing that they are running the command on a client box passing a file path that exists there but not on the server. When they try to use the default file (ie not run SET EXPLAIN FILE TO ...; first) they do not have permissible to write to their home directory on the server (if they even have a home defined there). Art
Hi Art, Thank you for answer. The set explain statements in the screenshot are executed by the informix user on the DB server. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------
Anyway, the set explain statement, and ifx_explain and bson_explain functions are not executed normally, so it seems that the Informix server will need to be restarted soon. Wouldn't that error occur after restarting the Informix server? ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------