Re: Change LOGGING on table

Posted in 2008

Jeroen Keppens — Mon, 25 Aug 2008 11:51:47 +0200 — source: Usenet: comp.databases.informix

This of course should be "database without logging" Sorry Jeroen On 25 Aug 2008, at 11:42, Jeroen Keppens wrote: > Hi, > > we currently have a table created without logging. This should be > changed to "WITH LOG". > > Is there a way to do this without recreating the DB? > > Tnx > Jeroen > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Jeroen Keppens

Neil Truby — Mon, 25 Aug 2008 11:34:33 +0100 — source: Usenet: comp.databases.informix

"Jeroen Keppens" <jeroen.keppens@nmv.be> wrote in message news:mailman.1569.1219657915.20610.informix-list@iiug.org... > This of course should be "database without logging" > > Sorry > Jeroen > > On 25 Aug 2008, at 11:42, Jeroen Keppens wrote: > >> Hi, >> >> we currently have a table created without logging. This should be >> changed to "WITH LOG". >> >> Is there a way to do this without recreating the DB? Yes, run a backup. A "false"one will do. eg: ontape -s -L 0 -U <database_name> -t STDIO > /dev/null