Re: Alter Table fails
In article <351A9163.C16BA627@ws6a37.gud.siemens.co.at>, Hr.Pfeiffer
<pfei@ws6a37.gud.siemens.co.at> writes
>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.
>
Disable logging,
cheange TAPEDEV in $ONCONFIG to /dev/null
run
ontape -s -N <dbname>
and do a level 0 archive.
Then alter the tables.
Then
ontape -s -U <dbname>
or ontape -s -B <dbname>
for buffered or unbuffered logging and do a level 0 archive.
Chnage TAPEDEV in $ONCONFIG back and lastly do a new level 0 archive
for safty's sake.
>--
>==================================================================
>Arnold Pfeiffer SIEMENS PSE KB311
>~~~~~~~~~~~~~~~ Gudrunstrasse 11
> A-1101 Wien
>email: pfei@ws6a37.gud.siemens.co.at Tel.: +43-1-1707 -45913
>==================================================================
>
>
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care