B2B Integration : Trading Networks Administrator's Guide : Archiving and Deleting Documents : Using a Partitioned Database for Archival and Deletion
Using a Partitioned Database for Archival and Deletion
Apart from using the Basic and Extended methods for archival and deletion, you can partition your database for archiving and deleting data using the scripts that are located at Software AG_directory \common\db\scripts\oracle\tradingnetworks\65\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.
Copyright © 2016- 2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback