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:

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s