Recently we have low performance in a informix instance and think the main trouble is some store procedures that have some lock waits. This script will help you to catch those sessions: _ERRLOG=error.log _OUTLOG=output.log _TMPTMP=ivan.txt while true do dbaccess sysmaster – ${_ERRLOG}>> 2>&1