Re: non exclusive access
Scott Black wrote:
>
> Has any one else run across this problem?
Yes, years ago with version 4.10.
>
> If I run something like the following
>
> set lock mode to wait;> begin work;
> lock table table1 in exclusive mode;
>
> alter table table1
> or
> create trigger on table1
> or
> create index on table1>
> commit work;
>
> I get:
> 242: Could not open database table (informix.table1).
> 106: ISAM error: non-exclusive access.
Hi,
does this problem occur only with table "table1" or with every table ?
If it's only "table1", unload the table, drop and restore the table
and try it again.
Bye
Stefan