Re: Informix Table Logging
At 12:17 PM 7/26/99, Carlson@WHSmith wrote: >Unfortunately, what you request is not possible. As far as I know, >table-level logging is not possible in Informix. At least with IDS 2000 (aka Centaur, aka 9.20) you CAN turn off logging using the ALTER TABLE statement. This may also be available with 7.3x, but don't hold me to that. The feature is called "non-logging tables". Cheers, Dick > >John Carlson >Informix DBA >WHSmith USA > > >A McCallum wrote: >> >> I need to turn off logging for a table to do a dataload, unbuffered >> logging produces a long transaction, >> >> I know I can create an unlogged table within a logged database using >> "with no log" but how do I do this with an existing table and how do I >> change it back again after the load. >> >> Changing the status of the database in not an option as this load is >> during an online day. >> >> Using IDS 7.3 uc7 >> >> thankyou >> >> Sent via Deja.com http://www.deja.com/ >> Share what you know. Learn what you don't. > Dick Snoke dsnoke@informix.com Partner Engineering 770-395-2308 Informix Software 5 Concourse Parkway Suite 1500 Atlanta, Georgia 30328
In article <7nj87p$an3$1@news.xmission.com>, Dick Snoke <dsnoke@informix.com> wrote: >At least with IDS 2000 (aka Centaur, aka 9.20) you CAN turn off logging >using the ALTER TABLE statement. This may also be available with 7.3x, but >don't hold me to that. The feature is called "non-logging tables". IDS 7.31 advertises it, but I haven't had occasion to use it. Check the release notes on the Informix web site for details. >>A McCallum wrote: >>> >>> I need to turn off logging for a table to do a dataload, unbuffered >>> logging produces a long transaction, >>> >>> I know I can create an unlogged table within a logged database using >>> "with no log" but how do I do this with an existing table and how do I >>> change it back again after the load. ... >>> Using IDS 7.3 uc7 -- W. Jim Jordan, Nortel Networks, Stop 29CA3A08 | +1 613 763 1568 PO Box 3511 Stn C, Ottawa, ON K1Y 4H7 Canada | wjjordan@nortelnetworks.com Opinions expressed are not necessarily those of Nortel Networks. Inbound spam filtering is in place. Don't send what I won't see.