hi

when we try to reorganise our customised table we are getting error message table locked is there any way to unlock this table in baan

Regards,
Vaishali

When all user who have used the table, logs out the table lock gets removed. In rare cases u may need to restart Baan to remove such table locks.

So ideal situation would be to ask all probable users of table to log out of Baan and preferably not use Baan till such activity is over.

Even though error 113 reads like "table is locked", but I found, that sometimes this error message is actually misleading.

If your database does not respond fast enough, the database drivers of Baan (at least the one for oracle) sometimes comes back with "Table is locked", because the driver gave up waiting assuming a lock is in place.

Try to restart your database (not Baan). If the error still occurs, then the table is definitely not locked.

Regards

Markus

this is customised table for uploading data to baan.we are using reorgnise table for this.we are using this session midnight when no user logged in to system.
Even if all the users logs out the table not get removed from baan unless i restart baan as well as informix.I have checked for baan standard tables it gets removed after sometime.but i don't know why for this customised table,locking problem is there.We are doing this actiivity from last six months but previously table not getting locked from last few days only this table gets locked.Is there any way to remove lock ????

Regards,
Vaishali

This can happen when the users' Baan connection is terminated abnormally for all tables used by him/her.

Further at times u urself use the same table when u check in GTM unknowingly. In such case u need to get out of Baan and get in again.

If nothing else works (ensure users are really logged off and so on), you can build a script that runs before that reorg happens to check for that particular table lock and kill the user locking it and clear the lock or, if all locks can be removed, set in a job to remove all existing locks before the reorg.