An administrator can specify the time window for archiving activity instance data in the primary import database. You use the OnlineWindowTimeUnit and OnlineWindowTimeLength properties in the BAM_Metadata_Activities table in the BAMPrimaryImport database.
If business users have deployed multiple activities, you can specify a different time window for each activity. For information about deploying activities, see "Defining a Business Activity" in Information Workers Users Guide.
The following table describes the values you can use for OnlineWindowTimeUnit and OnlineWindowTimeLength.
|
Property
|
Value
|
|---|
|
OnlineWindowTimeUnit
|
This property can be: month, day, hour, or minute. The default value of this property is month.
|
|
OnlineWindowTimeLength
|
This property must be an integer. The default value of this property is 6.
|
BAM moves data out of the BAM primary import database by partition, when the partition is older than the online window (current time - OnlineWindowTimeLength of OnlineWindowTimeUnit). For example, for OnlineWindowTimeLength = 5 and OnlineWindowTimeUnit = day, partitions older than 5 days are removed.
BAM moves archived activity instance data into the BAM archiving database. You specify the BAM archiving database during BizTalk BAM Configuration. For information about BizTalk BAM configuration, see BAM Configuration Schema.
BAM will not archive activity instance data if you have not run the BAM cube update Data Transformation Services (DTS) package, which processes the instance data into the activity cube.
For information about running the BAM data maintenance DTS package, see BAM DTS Packages.
See Also