run the command from ttisql
This will show you if Aging is on for a cache group.
You talked about a dynamic AWT cachegroup earlier in this discussion. This will have LRU Aging on by default. From the docs:
" LRU aging is defined by default on dynamic cache groups"
Cache Group CACHEADMIN.TESTCACHE:
Cache Group Type: Asynchronous Writethrough (Dynamic)
Aging: LRU on
Root Table: ORATT.TEST_REP
Table Type: Propagate
So what i need to modify here and hot to modify LRU on to Off.
If i modify to off mode then i will not miss any data.
< .8000000, .9000000, 1 >
how to find my current TimesTen database's space usage comparing with ttAgingLRUConfig()
You can turn aging on or off using an Alter Table statement on the underlying table for the cache group:
Alter Table ORATT.TEST_REP
set aging off;
This will stop rows being aged out. You probably only want to do this for your testing and to prove that the rows you described as vanishing, had actually been aged out.
run the ttIsql built-in procedure
for how the Permanent and Temporary partitions are being used. For how much space in being used by individual tables in 11.2.2, use the "ttComputeTabSizes" procedure, and then "tblsize <tablename>" .