Data Transfers

Monitor active and completed transfers and active rules using the Transfers and Transfer History subtabs.

Applications store derived data in the RAPCache. The derived data (for example, calculation results) is stored in lookup tables that are separate from the market data tables. To preserve historical records, transfer derived data to the RAPStore.

Transfer rules determine when derived and market data is transferred. Administrators create multiple transfer rules to specialize derived data management. There are two types of transfer rule: scheduled and cache-full.

• Scheduled (time-interval-based) rules transfer data according to set time intervals. Customize your schedule by selecting a time-interval variable. For example, you can create a rule that states: Every 30 minutes, on minute 15, every Tuesday and Thursday, transfer all data in table X. The time intervals available for scheduled rules are 1 minute, 5 minutes, 10 minutes, 15 minutes, 30 minutes, and 1 hour.
• Cache-full (memory-threshold-based) rules transfer data when a memory threshold is reached. The threshold is expressed as a percentage of the available Adaptive Server Enterprise cache. For example, you can create a rule that states: When the cache is 80% full, transfer all data in table X.

All rule types are administered from the Transfer Rules subtab. Only administrators can create, edit, or delete rules.

• Viewing Transfers
  Monitor active transfers and rules using the Transfers subtab.
• Viewing Transfer History
  Use the Transfer History subtab to view and clean up transfer history for all rules.