delete database

sourceuno · Post by **sourceuno** » Mon Jun 04, 2001 2:04 pm

I'm trying to delete files in my database directory, but it won't let me since the system files are locked. Is there a way to unlock these files?

bart · Post by **bart** » Mon Jun 04, 2001 2:08 pm

You should not be manually deleting files in a Texis DB. Use "drop table" and "drop index" instead. Doing otherwise will corrupt the contents of the SYSTEM tables.

sourceuno · Post by **sourceuno** » Mon Jun 04, 2001 2:12 pm

I'm just trying to clean out some disk space and need to delete those files. I tried using "drop table" but those tables are no longer there.

Post by **John** » Mon Jun 04, 2001 2:51 pm

Under NT you can not remove files that are in use by another process. The files are either in use by your application, or you have recently used the database and a database monitor is still running. The database monitor will exit once the database has not been used for a few minutes.

iclbloom · Post by **iclbloom** » Thu Nov 08, 2001 1:23 pm

So what is the recommend procedure for "blowing away" a database?

Does monitor run for a default of 60sec after tables are removed or no activity?

When monitor stops then the system files/tables can be deleted?

Thanks
Leon Bloom

Post by **John** » Thu Nov 08, 2001 1:55 pm

The database monitor examines the database every 60 seconds. If there has been no activity for 2 minutes, or under Unix if the system tables have been deleted, it will quit. Under Windows the database monitor needs to quit before you can remove the system tables. Running "rmlocks -f <database>" will forcibly destroy all locks on the database, and stop the database monitor.

iclbloom · Post by **iclbloom** » Mon Dec 03, 2001 2:56 pm

Is rmlocks available on the NT platform? I don't see it in the morph3 directory?

Thanks
Leon Bloom

sourceuno · Post by **sourceuno** » Fri Jan 25, 2002 10:48 am

I don't see it either in my morph3 directory? Is there an NT equivalent?

Post by **John** » Fri Jan 25, 2002 11:00 am

The rmlocks program is not currently in NT distributions, as the original form was not needed with NT. You can however use the <sqlcp rmlocks> function in Vortex.