Online ALTER table problems
Posted in 1994
Hello Informix Administrators!
I have a problem when trying to do the following command:
ALTER TABLE Geraet DROP CONSTRAINT Geraetfk13;
The message I then receive is :
242: Could not open database table (ar.organisation).
106: ISAM error: non-exclusive access
Also repeating the alter table command does not help me.
O.K. may be there is some access to the table "organisation" at this time.
My Question:
How can I find out which user and process holds the access (lock or whatever)
that disallows my ALTER TABLE ?
Is the reason a lock from a transaction or a open cursor or is both possible?
Thanks in advance
Achim
--
==========================================================================
/ Achim Reiners Software Engineering \\
| /M/A/I Deutschland GmbH |
| Softwarezentrum Koeln Phone: +49 221 956400-40 |
| Mathias-Brueggen-Str. 85 Fax: +49 221 956400-69 |
\\ 50829 Koeln E-Mail: ar@mai.de /
\\_________________________________________________________________________/