Informix

 View Only
  • 1.  534 error occurs when executing set explain on

    Posted Wed July 01, 2020 04:33 AM
    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


  • 2.  RE: 534 error occurs when executing set explain on

    Posted Wed July 01, 2020 05:26 AM
    Edited by System Test Fri January 20, 2023 04:13 PM
    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


  • 3.  RE: 534 error occurs when executing set explain on

    Posted Wed July 01, 2020 08:08 AM
    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





  • 4.  RE: 534 error occurs when executing set explain on

    Posted Wed July 01, 2020 08:34 AM
    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
    ------------------------------



  • 5.  RE: 534 error occurs when executing set explain on

    Posted Wed July 01, 2020 08:40 AM
    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
    ------------------------------