|
|
|
Each FairCom DB data partition and index pair resides as an independent data set. Their purpose is for ease and speed of data management. They can easily be purged, archived, re-activated, and even rebuilt as individual data silos with a single operation. Administration is done through the FairCom DB PTADMIN API function.
SQL Administration
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')
