Trading Networks 10.3 | Administering and Monitoring B2B Transactions | Trading Networks Administrator's Guide | Archiving and Deleting Documents | About Archiving and Deleting Documents
 
About Archiving and Deleting Documents
You can archive documents in the Trading Networks production database. Trading Networks archives documents by moving them from production tables to archive tables. You can also delete documents from the production tables, the archive tables, or both.
The following table describes the types of archival and deletion you can use:
Type
Description
Basic
Trading Networks archives or deletes documents after a specified number of days. When Trading Networks archives a document, it copies the document from the production tables to the archive tables and then removes the document and references to the document from the production tables. When Trading Networks deletes a document, it removes all associated document information from both the production and archive tables.
Extended
Trading Networks archives or deletes documents based on criteria you specify, such as the document ID, sender, receiver, and system status (for example, DONE, RESUBMITTED, or ABORTED). You can choose to archive only selected data in documents. You can choose to delete documents from the production tables, the archive tables, or both. You can also set the batchSize, which is the maximum number of documents that can be archived or deleted in a batch.
Stored Procedure
Trading Networks archives or deletes documents using the stored procedure archive script. Using this mechanism of archiving, the archive table uses the same schemas that are used in the production table. When Trading Networks deletes a document, it removes all the associated document information from both, the production and the archive tables.
The archive tables mirror the production tables. Data in the archive tables is identical to the data in the production tables. You can access archived documents from My webMethods; for example, you can view archived documents on the Transactions, Tasks, or Activity Log pages. You can work with archived data just like you do with production data (for example, you can resubmit or reprocess transactions, and stop and restart tasks).
The following table describes the how the archive table mirror the production table:
Production Table
Archive Table
BizDoc
ARCHIVE_BizDoc
BizDocContent
ARCHIVE_BizDocContent
BizDocAttribute
ARCHIVE_BizDocAttribute
BizDocArrayAttribute
ARCHIVE_BizDocArrayAttribute
BizDocRelationship
ARCHIVE_BizDocRelationship
DeliveryJob
ARCHIVE_DeliveryJob
ActivityLog
ARCHIVE_ActivityLog
BizDocUniqueKeys
ARCHIVE_BizDocUniqueKeys
EDITracking
ARCHIVE_EDITracking
Note:
If Trading Networks repeatedly deletes data from an Oracle database, the database tables might become skewed. To resolve this issue, regenerate the statistics of the table.