Robert,

First, always Commit between each step. I don't recommend mixing
database schema changes ALTER/DROP and data changes (UPDATE) in the same
transaction -- bad form to my mind.

How long are you waiting for? It is any longer than your original
insert? How much?

Your step 5 - the Update - may seem to be a simple statement but the
engine needs to clean up the older versions of the records (garbage
collection) which probably explains your "pause".

Next, what version of IB are you using? I would suspect 5.6. With 6.0
or Firebird, the garbage collection is processed by another thread so
you would be getting control back sooner -- although the server would
still be executing (in a low priority thread) in the background.

By the way, what OS are you running? just curious.


Sean

> -----Original Message-----
> From: Robert F. Tulloch [mailto:tultalk@...]
> Sent: Saturday, February 10, 2001 12:06 AM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] GDB Size
>
>
> Hi:
>
> Thanks for information. Any ideas on this?
>
> Same table:
>
> ALLZIP with fields:
>
> CITY VARCHAR(50)
> STATE CHAR(2)
> ZIP CHAR(6)
>
> I want to change CITY to varchar(30).
>
> 1. Create new field UCITY VARCHAR(30). Ok
>
> 2. UPDATE ALLZIP
> SET UCITY = CITY Ok
>
> Commit
>
> 3. UPDATE ALLZIP
> DROP CITY Ok
>
> 4. ALTER TABLE ALLZIP
> ADD CITY VARCHAR(30) Ok
>
> 5. UPDATE ALLZIP
> SET CITY = UCITY Horror!!!!!!!!!!!!!!!
>
> I have restored from backup and tried this TEN times and it
> fails every time. Right
> now, my cursor is jerking across screen because IBServer is
> using 99% cpu and has been
> doing so on the simple update in step 5.
>
> What is worse is you can't stop it. I open server manager
> and click Stop, it changes
> to Start and task manager still shows IBServer at 99% and you
> can't stop it in task
> manager: "access denied". After two tries doing something
> with IBConsole, that quits
> responding until you restart machine. I have also run chkdsk
> twice thinking maybe it
> was file corruption.
>
> So, something is really hosed up here. I will reinstall 332
> and if it happens again,
> I will reinstall an earlier version and test it.
>
> I cannot believe that you can get into a screwed up
> situation like this doing a
> simple thing like I was doing and IBConsole/IBServer provides
> no graceful exit.
>
> Any insight appreciated.
>
>
> Best regards
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-~>
> eGroups is now Yahoo! Groups
> Click here for more details
> http://click.egroups.com/1/11231/0/_/_/_/981783361/
> --------------------------------------------------------------
> -------_->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>