Get session ID of file in $PSORT_DBTEMP

Posted in 2023

Doug Lawry — source: IBM Community (ConnectedCommunity.org) Informix forum

Can someone remind me?! ------------------------------ Doug Lawry Oninit Consulting ------------------------------

↪ replying to Doug Lawry

Art Kagel — source: IBM Community (ConnectedCommunity.org) Informix forum

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

↪ replying to Art Kagel

Doug Lawry — source: IBM Community (ConnectedCommunity.org) Informix forum

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