Change Informix logging mode

On Informix error “transactions not supported”, we should check Informix logging mode:

SELECT is_logging, is_buff_log, is_ansi FROM sysdatabases WHERE name= ‘db_name’

If “is_logging” and “is_buff_log” are equals to 0, we have to change database logging mode.

  1. Change logging mode:
    • ondblog unbuf databasename
  2. Database level 0 backup:
    • ontape -s -L 0 -B databasename (we should have changed TAPEDEV variable from %INFORMIXDIR%/etc/%CONFIG% to any accesible directory.
  3. Set database online and allow multi-user:
    • onmode -m

References: