PLEASE HELP ME ... I AM IN DEEP TROUBLE ...
Shahid Mehmood, on SCO OpenServer 5.0 with Informix OWS 7.2, got error 242 / ISAM 106 (non-exclusive access) when altering table bcopy, even after LOCK TABLE and an engine restart. One poster advised unloading the data, dropping or renaming the table and recreating it with the new schema, then reloading. Bob asked about HDR and suggested update statistics. No confirmed fix.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
PLEASE HELP ME ... I AM IN DEEP TROUBLE ...
OS: SCO OPEN SERVER 5.0
OWS: INFORMIX OWS 7.2
When I try to alter a table, i get following error:
the query:
ALTER TABLE bcopy>ADD (vendorcode CHAR(5) BEFORE
edition )
the error:
242: Could not open database table (libdba.bcopy).
106: ISAM error: non-exclusive access.
Please note that nobody is using this table, or
connected to this table. Can any one help me.
I had already tried to LOCK TABLE ... and then ALTER
... but of no use. I had also used "onmode -k" and
then "oninit" but of no use.
Thanks in advance
Shahid Mehmood
Software Designer II
Information Systems Department
The Aga Khan University
Karachi
Official:Y
=====
Shahid Mehmood
Software Designer
Information Systems Department
The Aga Khan University,
Karachi, Pakistan
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
On Thu, 18 May 2000 23:34:50 -0700 (PDT), Shahid Mehmood
<theixdba@yahoo.com> wrote:
>
>PLEASE HELP ME ... I AM IN DEEP TROUBLE ...
>
>OS: SCO OPEN SERVER 5.0
>OWS: INFORMIX OWS 7.2
>
>When I try to alter a table, i get following error:
>
>the query:
>ALTER TABLE bcopy>ADD (vendorcode CHAR(5) BEFORE
>edition )>
>the error:
> 242: Could not open database table (libdba.bcopy).
> 106: ISAM error: non-exclusive access.>
>Please note that nobody is using this table, or
>connected to this table. Can any one help me.
>
>I had already tried to LOCK TABLE ... and then ALTER
>... but of no use. I had also used "onmode -k" and
>then "oninit" but of no use.
>
>
>Thanks in advance
>
>Shahid Mehmood
>Software Designer II
>Information Systems Department
>The Aga Khan University
>Karachi
>Official:Y
>
>
>=====
>Shahid Mehmood
>Software Designer
>Information Systems Department
>The Aga Khan University,
>Karachi, Pakistan
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
I think that nobody can help you, so the best thing you can do is:
make schema of bcopy table
unload to tmp.unl
select list_of_all_columns_before_edition,
" ",edition,lixt_of_all_columns_after_edition from bcopy
drop table bcopy
or (better)drop all indexes on bcopy table and rename table bcopy to bcopy.bad
edit schema file
recreate table bcopy (without indexes) from new schema
load from tmp.unl insert into bcopy
recreate indexes on table bcopy
On Thu, 18 May 2000 23:34:50 -0700 (PDT), Shahid Mehmood
<theixdba@yahoo.com> wrote:
>
>PLEASE HELP ME ... I AM IN DEEP TROUBLE ...
>
>OS: SCO OPEN SERVER 5.0
>OWS: INFORMIX OWS 7.2
>
>When I try to alter a table, i get following error:
>
>the query:
>ALTER TABLE bcopy>ADD (vendorcode CHAR(5) BEFORE
>edition )>
>the error:
> 242: Could not open database table (libdba.bcopy).
> 106: ISAM error: non-exclusive access.>
>Please note that nobody is using this table, or
>connected to this table. Can any one help me.
>
>I had already tried to LOCK TABLE ... and then ALTER
>... but of no use. I had also used "onmode -k" and
>then "oninit" but of no use.
>
>
>Thanks in advance
>
>Shahid Mehmood
>Software Designer II
>Information Systems Department
>The Aga Khan University
>Karachi
>Official:Y
>
>
>=====
>Shahid Mehmood
>Software Designer
>Information Systems Department
>The Aga Khan University,
>Karachi, Pakistan
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
I notice that you have this problem for long time. I think that nobody
can help you, so the best what can you do is:
unload to tmp.unl
select ...," ",colname,... from
tabname
drop table tabname1
recreate table tabname1 with new schema (without indexes)
load from tmp.unl insert into tabname
recreate indexes
Is the instance replicated using HDR? Try running update statistics on the table first. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!