(Optional) When the trace flag 4816 is enabled for the RAPCache, there are certain operations that should not be performed on the tables involved in the bulk transfers.
Disable the trace flag if you wish to perform these operations.
Prerequisites
The installation is complete.
Task
Trace flag 4816 is enabled for the RAPCache.
Do not perform the following operations on tables involved in the bulk transfers:
- drop table
- alter table
- create/drop index
- create/drop trigger
- reorg rebuild table
- update statistics
- delete statistics
- create default
- create constraint
- create computed column
- change system encryption password
- sp_recompile
- sp_bindefault/sp_unbindefault
- sp_bindmsg/sp_unbindmsg
- sp_bindrule/sp_unbindrule
- sp_cachestrategy
- sp_rename
- Change to /RAPCache/ASE-15_5/install/RUN_RAPCache file.
- Use a text editor to open the RUN_RAPCache file. Delete the line "-T4816".
As a consequence, you may see additional triggers of cache-based rules.
- Save and close the file.