What's the best practice for reindexing?

What's the best practice for reindexing?

Postby SteveLai » Tue Apr 18, 2006 2:07 pm

I use a Blank Record function instead of Delete/Pack in a multi-user environment, plus a ReUse Blank Record if one exists when creating new records. There is a need to Pack/Reindex from time to time, requiring exclusive access, but every now and again some files are locked, even when all the users have logged out. Suggestions/solutions appreciated ... many thanks in advance.
User avatar
SteveLai
 
Posts: 11
Joined: Tue Apr 18, 2006 11:43 am
Location: Scotland

Postby John » Wed Apr 19, 2006 7:57 am

It is my experience that in Novell networks sometimes the server keeps files locked, don´t know why. Rebooting the server always works in that case, but of course that´s not a decent solution! :-)
John
 
Posts: 67
Joined: Mon Dec 26, 2005 7:44 am
Location: The Netherlands

Releasing locked files

Postby SteveLai » Wed Apr 19, 2006 12:11 pm

Thank you for your response John. There is another, but equally not very practical, way to release locked files, i.e. close off open sessions on the server when logged in with administrator rights ... not a good solution to give to the client though. Surely somebody somewhere must have come across this situation and devised a more practical approach?
User avatar
SteveLai
 
Posts: 11
Joined: Tue Apr 18, 2006 11:43 am
Location: Scotland

Postby James Bott » Wed Apr 19, 2006 2:30 pm

On Novell there is a timeout period of around 10 minutes. Usually, the files will be unlocked automatically by the OS after that. I also found that if you log back in as the user that has them locked, then out again, the files get unlocked.

Of course, neither of these is good solution, but they are the only ones I found.

James
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 71 guests