answer Frank Huemme

Frank Huemme writes: >After bringing up the the System, one programm dosn't work properly. >Ok,we dial in via Modem and try to update a table: > >update "tablexxx" ..... > >The errors: >246: Could not do an indexed read to get the next row >107: ISAM Error: record is locked> >Hmmm, >we unload the table in a ascii file , and then > >drop table tablexxx; >create table tablexxx>{ >...... > > >The error: >-314: Table ist currently in use> >so we had to shutdown the Online-System to fix. Is it possible to fix the >error without shuting down the system ? Yes, Sounds like you had an orphaned process that was holding resources on the database. Informix reccomends that when you have problems like this DO NOT put the database into quiesent mode. If you do this you will not be able to use tbmonitor and tbmode to identify and remove the orphaned process. But lets say you did, you can use the unix commands 'ipcs' and 'ipcrm' to verify the process is still in memory and remove it from memory. Hope this helps. Happy Holidays !! Brian MacWilliams USAMC SIMA CHAMBERSBURG, PA