Amazium bvba, your online partner
Change logging on database
  • Share post with Twitter
  • Share post with StumbleUpon
  • Share post with Delicious
  • Share post with Digg
  • Share post with Technorati
  • Share post with Blinklist
2008-08-31 13:34

Change logging on database

database logging, informix

When you want to connect from one database to the other, you have to make sure that both databases have the same log settings. When creating a database you can choose to do so with log, with buffered log or without log.

(perform at your own risk, we're not responsible for possible problems)

To change to "UNBUFFERED LOG" you simply take a fake backup:

ontape -s -L 0 -U -t STDIO > /dev/null

More info about managing transaction logging can be found on the IBM Informix Dynamic Server Information Center.

It's as simple as that.

Add a Comment

Your email is never published or shared. Required fields are marked*