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. You can use either of these types of archive and deletion:

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, as shown below. 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).

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