Re: Help: Can't Find bcheck in V6.0
In article: <44ahi7$dud@raffles.technet.sg> bcsis@technet.sg (BCSIS) writes:
>
> A few days ago, somebody has posted an article which said that the
> following command can unlock a locked table safely:
>
> bcheck -y <TABLE>
>
> However, when we tried to execute the command under our HP9000 S800
> machine with Informix On-line v6.0 installed, it returns "bcheck: not
> found".
>
> Could someone on the net answer some of my questions below:
>
> 1. Exactly what functions does bcheck perform?
It checks Standard Engine indexes and can repair them if corrupted
(allegedly!)
> 2. Does it comes with Informix? If yes, then which version?
Yes, but not with OnLine - you get a tbcheck/oncheck with OnLine.
> 3. If bcheck does not come with Informix, then how can I get one?
If you're trying to force a lock to drop, kill the front-end. If all
else fails, bring the database down using onmonitor (even just to Quiescent mode).
Do not *EVER* kill an oninit process.
HTH,
--
Cheers,
+---------------------------------------------------------------------------+
| Spokey the Wheeler |
+---------------------------------------------------------------------------+
INCLUDE "Disclaimer.4gh" -- my opinions are
INCLUDE "FlamesToDevNull.4gh" -- tells flamers where to go
INCLUDE "BillyBoyDasAufregendAndereKondom.4gh" -- header file for this class