Common timensten maintenance operations and timensten Maintenance

Common timensten maintenance operations and timensten Maintenance

**************************************** ********************************* * ************ --- 1. keep it in the memory ttAdmin-ramPolicy always ttwind --- 2. load the application to the memory ttAdmin-ramPolicy inUse ttwind --- 3. manually load the ttAdmin-ramPolicy manual-ramLoad ttwind --- 4. manually uninstall ttAdmin-ramPolicy manual-ramUnload ttwind --- 5. after the last connection is disconnected for 300 seconds, the memory will be detached (history is DSN name) ttAdmin-ramPolicy inUse-ramGrace 300 History --- 6. enable and disable cache agentC Ommand> call ttcachestart; Command> call ttcachestop; or ttAdmin-cacheStart ttwindttAdmin-cacheStop ttwind or ttAdmin-cachePolicy always ttwindttAdmin-cachePolicy manual ttwind ********************** **************************************** ******************************* * ************************************ 1 check the historical records of the last eight checkpoints of the checkpoint. Call ttCkptHistory; 2. view the checkpoint configuration. Call ttCkptConfig; <600, 32, 0> 1 row found. call ttCkptConfig (values, 0, 50); 3. Reset TEMP_IN_USE_HIGH_WATERcall ttMonitorHighWaterReset (); 4. View tt configurations. Call ttConfiguration; 5. If the cache proxy policy is manual, ttCacheStart starts the cache proxy. Call ttCacheStart6. if the cache proxy policy is manual, ttCacheStop stops the cache proxy call ttCacheStop 7. return the following information related to each connection in the specified Active Data Storage: call ttDataStoreStatus; 8. return the local host name of the current data storage call ttHostNameGet 9. set the default local host name of the current data storage to call ttHostNameSet 10. sets the lock level granularity for subsequent transactions started by the connection. The new lock level does not affect the current transaction processing call ttLockLevel11. set the lock timeout interval (in seconds) for the current transaction and subsequent transaction processing in the connection) ttLockWait *************************************** * ****************************** 3. alter cachegroup ************************************** * ******************************* alter cache group [Owner.] groupName set autorefresh state {ON | OFF | PAUSED} alter cache group [Owner.] groupName set autorefresh mode {INCREMENTAL | FULL} alter cache group [Owner.] groupName set autorefresh interval IntervalValue {MINUTE [S] | SECOND [S] | MILLISECOND [S]} ---- rerefresh data alter cache group cacheuser. cachetblorders set autorefresh state paused; refresh cache group cacheuser. cachetblorders commit every 50000 rows; alter cache group cacheuser. cachetblorders set autorefresh state on;