Product Documentation

FairCom Database Engine Partitioned Files

Previous Topic

Next Topic

Can We Do a File Block on an Individual Member File?

In some situations it can be advantageous to block access to a data file by current users. For example, an administrator may desire to compact a data file if the file system is near capacity. Because the compact operation requires exclusive access to the data file and indices, the application would need to be shut down. FairCom provides methods of temporarily blocking access to individual files, which allow the file to be compacted without shutting down the entire application.

Partitioned Files

A file block cannot be applied to a single partition member. To add/remove a partition from a partitioned file, you need to file bock the partition host. The FairCom DB PTADMIN API function or the fc_ptadmin_num() SQL stored procedure is used to archive and purge member files.

FILESETs

The file block concept does not apply to FILESETs because the FILESET is created at runtime and destroyed when the file is closed. While the file set is in effect, it actually behaves like a partitioned file so the same behavior applies.

TOCIndex