turn on transaction logging for DB in Informix 11.70x

[Problem]
Transaction Logging is turned off for database DB1

[Procedure]

  • 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

[Conclusion]
Now we are done.

[Commands]

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

[References]
http://www-01.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.admin.doc/ids_admin_0671.htm?lang=en

Advertisements

About yingding wang
i am looking forward to innovation in IT and Robotics

Comments are closed.

%d bloggers like this: