Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "Stardust/Knowledge Base/Infrastructure System Administration Maintenance/Archiving"

m
(Archiving or deleting Audit Trail Contents using the Sysconsole)
Line 5: Line 5:
 
When archiving big audit trails or complex, big process hierarchies pay special attention to the batchSize parameter. You may have to use a smaller batch size so the operation can be performed within the configured transaction timeout.<br>  
 
When archiving big audit trails or complex, big process hierarchies pay special attention to the batchSize parameter. You may have to use a smaller batch size so the operation can be performed within the configured transaction timeout.<br>  
  
Please refer to the sysconsole [https://infinity.sungard.com/documentation/ipp/6.0/topic/ag.carnot.docs.dev/html/handbooks/operation/commandline/ag-commandline-2.htm#archive documentation ]for details.<br>  
+
Please refer to the sysconsole [https://infinity.sungard.com/documentation/stardust/1.0/index.jsp?topic=/org.eclipse.stardust.docs.dev/html/handbooks/operation/commandline/ag-commandline-2.htm#archive documentation]for details.<br>
  
 
== Deleting Process Instances using SQL  ==
 
== Deleting Process Instances using SQL  ==

Revision as of 03:58, 7 June 2013

Archiving or deleting Audit Trail Contents using the Sysconsole

Regular archiving should be done periodically using the sysconsole command line tool. There is a 'nobackup' parameter that will delete the audit trail contents instead of archiving it to an archive schema.

When archiving big audit trails or complex, big process hierarchies pay special attention to the batchSize parameter. You may have to use a smaller batch size so the operation can be performed within the configured transaction timeout.

Please refer to the sysconsole documentationfor details.

Deleting Process Instances using SQL

If the audit trail has grown to a significant size and the old data should be delete and not archived, then SQL will do the job faster than the sysconsole archive command.

The required scripts can be downloaded from the maven repository (https://infinity.sungard.com/repository/).

Choose the artefact that matches your Stardust version.

<groupId>com.infinity.bpm</groupId>
 <artifactId>sql-templates</artifactId>
 <packaging>zip</packaging>
<version>x.x.x</version>

For example for version 6.0.4 dowload: https://infinity.sungard.com/repository/ipp-releases/com/infinity/bpm/sql-templates/6.0.4/sql-templates-6.0.4.zip

Then follow the instructions in the contained create-ipp_tools.sql file.

Back to the top