table locked
This is a multi-part message in MIME format. ------=_NextPart_000_001B_01BF11BD.DC5DF720 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi , I=B4m having a table locked , but there are no running program = that locks that table=20 how I can see which table name is locked and also how can I unlock that = one . Thanks . Roque ------=_NextPart_000_001B_01BF11BD.DC5DF720 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT size=3D2>Hi , I=B4m having a table locked , but there are = no =20 running program that locks that table </FONT></DIV> <DIV><FONT size=3D2>how I can see which table name is locked and=20 also how can I unlock that one .</FONT></DIV> <DIV> </DIV> <DIV> </DIV> <DIV><FONT size=3D2>Thanks .</FONT></DIV> <DIV><FONT size=3D2>Roque</FONT></DIV></BODY></HTML> ------=_NextPart_000_001B_01BF11BD.DC5DF720--
If you're running 7.x, you could use this:
database sysmaster;
select * from syslocks
where tabname = "<table name>"
John Carlson
Informix DBA
WHSmith USA
António Roque wrote:
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_001B_01BF11BD.DC5DF720
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi , I=B4m having a table locked , but there are no running program =
> that locks that table=20
> how I can see which table name is locked and also how can I unlock that =
> one .
>
> Thanks .
> Roque
>
> ------=_NextPart_000_001B_01BF11BD.DC5DF720
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Diso-8859-1" =
> http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT size=3D2>Hi , I=B4m having a table locked , but there are =
> no =20
> running program that locks that table </FONT></DIV>
> <DIV><FONT size=3D2>how I can see which table name is locked and=20
> also how can I unlock that one .</FONT></DIV>
> <DIV> </DIV>
> <DIV> </DIV>
> <DIV><FONT size=3D2>Thanks .</FONT></DIV>
> <DIV><FONT size=3D2>Roque</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_001B_01BF11BD.DC5DF720--