--In Oracle Instance , there was 3 rows;
ttisql
connect dsn_a ;
call ttcachestart() ;
select * from testtable;
--return 0 rows;
--restart oracle instance and restart TT cachegroup
call ttcachestop() ;
call ttcachestart();
select * from testtable;
--return 0 rows;
--check odbc
vi /var/TimesTen/sys.odbc.ini
--rebuilt TT cachegroup
call ttcachestart()
drop cache group ETUser.IPS_sysconfig;
create readonly cache group ETUser.IPS_sysconfig
autorefresh interval 5 seconds from ETUser.sysconfig(
seqID numeric(13,0) not null primary key,
section VARCHAR(32) not null,
key VARCHAR(32) not null,
value VARCHAR(256),
reserve0 numeric,
reserve1 VARCHAR(256) );
load cache group ETUser.IPS_sysconfig commit every 20 rows;
--when execuse first statment echo a warning
--and second statment echo 3 warnings
--and last statment echo a error that is :Unable to connect to the Cache Agent for /var/TimesTen/tt60/OracleCache/Policy; check agent status
--because of this error, I used this statment :
ttisql -f IPS_cachegroup.sql ET_policy
--data checking is ok