Hi

I had created a database mistakenly without log. And now as the transaction log is required for all the operations, I am trying to modify the database with log. I found the command as START DATABASE in Informix Unleashed. But on trying to execute the command with several permutations and combinations I get the same "syntax error" message. Please let me know the solution.

Thanks in advance.

See command ondblog.

You could also use the "ontape" command to set a database for either buffered (ontape -s -B db_name) or unbuffered (ontape -s -U db_name)transaction logging.