seniorpeon
Programmer
I am trying to drop a table in my database (so that I can rebuild it with no indexes and load a bunch of data into the table in a faster manner). The vendor of the accounting software that set up this informix database says:
...
There may be different
glg_gen_mstr tables owned by two different people.
...
you may have to drop them individually
because they are probably owned by somebody different.
When I use
DBACCESS
and do the following:
Drop
Table
glg_gen_mstr (table name)
I get:
214: Cannot remove file for table (bsi.glg_gen_mstr).
106: ISAM error: non-exclusive access.
(There are no other users on the box.)
Is this really an ownership issue?
If so, how do I change the ownership (other tables, that I am able to drop looks like this: 'bsidba'.ar_acct_mstr whereas the offending table looks like this: glg_gen_mstr)
I have spoken given this info to the vendor, but haven't heard back from them yet.
TIA
...
There may be different
glg_gen_mstr tables owned by two different people.
...
you may have to drop them individually
because they are probably owned by somebody different.
When I use
DBACCESS
and do the following:
Drop
Table
glg_gen_mstr (table name)
I get:
214: Cannot remove file for table (bsi.glg_gen_mstr).
106: ISAM error: non-exclusive access.
(There are no other users on the box.)
Is this really an ownership issue?
If so, how do I change the ownership (other tables, that I am able to drop looks like this: 'bsidba'.ar_acct_mstr whereas the offending table looks like this: glg_gen_mstr)
I have spoken given this info to the vendor, but haven't heard back from them yet.
TIA