FairCom Database Engine Partitioned Files

Managing Partitioned Files

Partitioned File Administration Utility

A partitioned file administration utility, ctpartadmin, is available to script partitioned file administrative actions. It provides all the operations of the API.

• Add new partition
• Delete existing partition
• Archive existing partition
• Activate archived parition
• Set partition number low limit
• Return partition status
• Rebuild partition
• Get active low partition number
• Get active high parition number

Partitioned File Functions in SQL

FairCom DB SQL includes built-in procedures to administer partitions directly from your SQL application. The fc_ptadmin_num() procedure provides access to many basic administration functions.

call fc_ptadmin_num('admin', 'custmast', 'archive', 123)

To identify current lowest and highest active partition numbers, the built-in SQL procedure fc_get_partbounds() returns this information.

call fc_get_partbounds('admin', 'custmast')

Partitioned File API Function

The Partition Administration function, PartitionAdmin(), allows on-the-fly adjustment to the partitions associated with a given host file. This includes the capability to:

• Add, remove, or archive partition(s)
• Modify lower limit of the raw partition number
• Modify limit on the number of partitions
• Reuse the raw partition number of a purged member
• Activate archived member(s)
• Return a member file status

For additional information on PartitionAdmin(), see PartitionAdmin.