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 specify when derived and market data is transferred. Administrators create multiple transfer rules to specialize derived data management. There are two supported transfer rule types: scheduled and cache-full based rules.
- 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.
- 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.
- Cache-full and interval rules are both incremental transfer types. When a transfer is invoked, any updates or inserts to the table since last transfer are also sent. The table of derived data can continue to have inserts, updates, and deletes performed upon it while data is transferred. Enable a table for incremental transfer before defining a transfer rule for it.
All rule types are administered from the Transfer Rules subtab, and can be created, edited, or deleted only by administrators.
