Create, edit, and delete transfer rules, view transfer rule details, manually run transfer rules, and enable incremental transfers in RAPCache tables from the Transfer Rules subtab.
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.
