Using a Partitioned Database for Archival and Deletion

Trading Networks 10.7 | Administering Trading Networks | Archiving and Deleting Documents | Using a Partitioned Database for Archival and Deletion

Apart from using the Basic and Extended methods for archival and deletion, You must install Trading Networks Database 10.7 Fix 1 so that you can partition your database for archiving and deleting data using the scripts that are located at

SoftwareAG_Directory\common\db\TradingNetworks\TradingNetworks\scripts\9.8.fix1-9.9\oracle\partition_support

Partitioning logically separates one set of data from another, thereby enhancing the process of archiving data from production tables to archive tables. For more information on partitioning your database for archival and deletion, see Partitioning Trading Networks Database.

Note:
For BizDocUniqueKeys, ARCHIVE_BizDocUniqueKeys, EDITracking, and ARCHIVE_EDITracking tables, Trading Networks supports only the Basic and Extended methods of archival. For deletion, use wm.tn.archive:purgeBizdocUniqueKeysData and wm.tn.archive:purgeEDITrackingData services respectively. For more information on these services, see webMethods Trading Networks Built-In Services Reference.