Robert,

By the way, please don't cross-post.

Most of the active community member subscribe to the Mers list, the
IB-Support list and to the newsgroups.

So a single post will get a response -- Cross-posting just wastes
bandwidth.


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
>
>
>