|
|
|
Each c-treeACE 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 c-treeACE PTADMIN API function.
SQL Administration
c-treeACE 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')
