Re: Alter Table fails

You can turn logging off using On-monitor or tbtape command. The Informix manual has the instructions. Remember what logging mode the database was in before turning off the logging mode. I prefer the tbtape option since this will allow the backup to happen before changing logging mode. As always a backup before messing with it is the best option. Hr.Pfeiffer wrote: > I have to change the structure of some tables of my database > (Renaming and adding columns). Therefore i tried to use the alter > table statement. I always failed due a long transaction (My high water > markers are 50 and 60) . The real problem is, that just i have few > diskspace (for dbspaces and logging) and the tables, which i want to > alter, contains quite a lot of data. Is there a way to use alter table > with no logging (which i do not really want to make!! But it seems to > me, that alter table just creates temorary tables and makes a lot of > inserts and deletes and loggs everything) or do i have to unload the > data, change the table structure and reload the data. > > Thank's for any ideas. > > -- > ================================================================== > Arnold Pfeiffer SIEMENS PSE KB311 > ~~~~~~~~~~~~~~~ Gudrunstrasse 11 > A-1101 Wien > email: pfei@ws6a37.gud.siemens.co.at Tel.: +43-1-1707 -45913 > ================================================================== > >