Informix

 View Only
  • 1.  Get session ID of file in $PSORT_DBTEMP

    Posted Thu March 02, 2023 03:03 AM

    Can someone remind me?!



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------


  • 2.  RE: Get session ID of file in $PSORT_DBTEMP

    IBM Champion
    Posted Thu March 02, 2023 06:58 AM

    Doug:

    Sort file: srt0010527_001 belongs to the session with sqlexec thread # 527

    Ordinal  sqlexec   Ordinal

    Sort #   Thread #   File #

    ----------   --------   ----------

    srt  001    0527    _001

    Art



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



  • 3.  RE: Get session ID of file in $PSORT_DBTEMP

    Posted Thu March 02, 2023 07:11 AM

    Thanks, Art. I restarted an instance this week that had left a pair of huge files behind. Removing them didn't release space as they were still open as shown by "lsof". Next time, I'll see if the session is still running. If so, I'll terminate it with "onmode -z". If not, I'll have something better to raise a support case with "onstat -a" output.



    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------