Product Documentation

FairCom Database Engine Partitioned Files

Previous Topic

Next Topic

Can We Operate on a Single Member File Independently?

Partitioned Files and FILESETs are composed of a group of individual files. Some c-tree operations can be performed on the individual files in certain situations.

Partitioned Files

Partitioned Files allow data with a defined range of values for the partition key to be rapidly purged or archived (instead of having to delete record-by-record each record within this range). This administration is done through the FairCom DB PTADMIN API function or the fc_ptadmin_num() SQL stored procedure.

Individual member files can be purged and archived using these functions.

The member files of a Partitioned File cannot be opened by accessing them directly.

FILESETs

FILESETs are composed of individual files, which are standard c-tree files. As such, the member files can be accessed individually, and standard c-tree operations can be performed on them, when they are not part of a FILESET.

It is important that the individual files are not changed while they are being used as members of a FILESET.

TOCIndex