RE: alter table/exclusive access
No.
'Alter table' (even in-place alter table) changes the version
of a table, and this make all cursors, pre-optimized (prepared)
SQL's and stored procedure SQL plans (for procedures accessing
that table) invalid.
Usually, user sessions get '710' error
This is one of major problems with supporting Informix in 24x7 environment.
------------------------------------------
Alexey Sonkin
Senior Database Administrator
> -----Original Message-----
> From: Bill Hamilton [mailto:laidback@finsco.com]
> Sent: Wednesday, January 21, 2004 2:35 PM
> To: informix-list
> Subject: alter table/exclusive access
>
> Sometimes I just need to add a new column to a table
> and would like to get it done in the daytime,
> but IDS wants the table exclusive.
>
> I've tried
> SET LOCK MODE TO WAIT;> LOCK TABLE x IN EXLUSIVE MODE;
> ALTER TABLE ADD ........> to no avail.
>
> Is there not anyway to get IDS to "alter" without blowing away users?
> sending to informix-list
sending to informix-list