Archiving or Deleting Audit Data Using Stored Procedures

Procedure

Description

Oracle:

DOCUMENT_ARCHIVE. START_DOCUMENTARCHIVE

SQL Server and DB2:

DOCUMENT_ARCHIVE_ START_DOCUMENTARCHIVE

In IS Core Audit Log, archives or deletes documents logged for webMethods Broker clients from the WMDOCUMENT table.

In Process Audit Log, archives and deletes document control data (such as resubmit actions) from the PRA_PROCESS_ACTION table.

Oracle:

PROCESS_ARCHIVE. START_PROCESSARCHIVE

SQL Server and DB2:

PROCESS_ARCHIVE_ START_PROCESSARCHIVE

In IS Core Audit Log, archives or deletes process-related service data from the tables:

WMSERVICEACTIVITYLOG and WMERROR

In Process Audit Log, archives or deletes process and control data (such as resubmit actions) from the tables:

PRA_PROCESS_CUSTOM

PRA_STEP_LOGGED_FIELD

PRA_STEP_LOOP_LOGGED_FIELD

PRA_PROCESS

PRA_PROCESS_ACTION

PRA_PROCESS_RECENT

PRA_PROCESS_STEP

PRA_STEP_TRANSITION

WMCUSTOMFIELDDEFINITION

WMPROCESSDEFINITION

WMPROCESSIMAGE

WMSTEPDEFINITION

WMSTEPTRANSITIONDEFINTION

Oracle:

SERVER_ARCHIVE. START_SERVERARCHIVE

SQL Server and DB2:

SERVER_ARCHIVE_ START_SERVERARCHIVE

In IS Core Audit Log, archives or deletes Integration Server data from the tables:

WMERROR, WMSESSION, WMTXIN, and WMTXOUT

Integration Server data consists of session and guaranteed delivery log entries, and error log entries that are not associated with logged processes, services, or documents (for example, errors that occur during startup or during the run of unlogged processes, services, activations, and documents).

Note:

Archiving Integration Server data archives only top-level errors. To archive lower-level errors associated with services or processes, you must first archive those services or processes.

Oracle:

SERVICE_ARCHIVE. START_SERVICEARCHIVE

SQL Server and DB2:

SERVICE_ARCHIVE_ START_SERVICEARCHIVE

In IS Core Audit Log, archives or deletes service log entries, input pipelines, error data, and user-defined messages from the following tables:

WMSERVICE

WMSERVICE_MIN_MAX

WMERRORTBL

WMSERVICEACTIVITYLOGTBL

WMSERVICEASSOCTBL

WMSERVICECUSTOMFLDSTBL

In Process Audit Log, archives or deletes service control data (such as resubmit actions) from the WMCONTROL table.

p_retaindays	String Number of days to keep the indicated type of data in the source database, ending with and including the current date. Suppose the current date is September 30, to archive or delete data for services that finished running more than 15 days ago (that is, before September 15), you would specify this parameter as 15. Supply either p_retaindays or p_retaindate. Do not supply both.
p_retaindate	Long Start date for the period to keep the indicated type of data in the source database. The period ends with and includes the current date. p_retaindate is in epoch time (milliseconds since midnight, 01/01/1970). Supply either p_retaindate or p_retaindays. Do not supply both.
p_action	String Indicates whether to archive or delete the indicated type of data from the source database.
	Set to...	To...
	ARCHIVE	Default. Copy the data from the source to the Archive database and delete the data in the source database.
	DELETE	Delete the data from the source database.
p_status	String Used by the PROCESSARCHIVE or SERVICEARCHIVE procedure, indicates which data to archive or delete based on the specified status. Process and service data with a status other than those specified is retained in the source database.
	Code	Archive or Delete data for...
	2	Processes or services with a Completed status.
	4	Processes or services with a Failed status.
	1024	Processes with a Stopped status.
	32768	Processes and services with a Resubmitted status.
	32776	Services with an Activity status.
p_batchsize	String Number of primary items and accompanying items to archive or delete at a time. To archive or delete 100 processes and accompanying services, activity logs, and errors at a time, choose a number that takes the size of each record and other performance factors into consideration. If the record size is large, consider reducing the batch size; if the record size is small, increasing the batch size may increase the speed of the archive or delete.
p_modelid	String array Used by the PROCESSARCHIVE procedure only. Complete model ID of the model for the process instance(s) you want to archive. Use a comma to separate multiple modelid string values. You can retrieve model IDs by invoking the pub.monitor.process.instance:getProcessList service and using the value returned in the processNames/PROCESSKEY output parameter. If null, all process models are archived.