Re: Locked Files

In article <2t920j$j81@rzcom.stadt-mh.de>, Dirch Scheer (scheer@AMT10H01.stadt-mh.de) writes: >I have tried tbmode -z very often, but there were never an effect. So it was >my last chance to kill the user with the kill command. If I cancel a user >in this way I must always look if the database is still online or if I have >shut them down. My informix support says to this problem, that the only >secure way to kill a user is the following > > Take the Online-sytem offline > Kill the user > Startup the Online-system > >But how should I do this when 30 users are working hard with the database? > >Are there better hints to kill a user??? > >Dirch > We experience the same problem, but we also cannot take the Online-system offline because 40 other users are working on it. So we just kill that one user. Last week the result was that a few tables got damaged and we where not able to repair them with tbcheck, so we had to use a backup tape. My only solution at this time is wait till everybody is gone home and take the database offline to avoid getting it damaged. Eelco Uniware Computer Systems BV PO Box. 37132 The Netherlands