turn on transaction logging for DB in Informix 11.70x

Transaction Logging is turned off for database DB1


  • onmode -u #change to quiscent/single user mode and kill all attached session, this is important, with open sessions you can not change the logging mode
  • ontape -s -L 0 -B DB1 #use ontape -s to backup a Level 0 and turn on the Buffered Logging mode for database “DB1”
  • onmode -m #change from quiscent mode to multiuser mode/online mode

Now we are done.


  • onstat -g ses #Display the sessions
  • onmode -z <sessionid> #kill the sessions in informix