timesten修改PermSize

环境:

OS:Centos 7

DB:18.1.14

 

1.修改配置文件
vi sys.odbc.ini
PermSize=9192 ##这里的值根据情况设置

 

2.重新load
[instanceadmin@localhost ~]$ ttadmin -rampolicy manual sampledb ##设置为手工
[instanceadmin@localhost ~]$ ttadmin -ramunload sampledb
[instanceadmin@localhost ~]$ ttadmin -ramload sampledb

##重启ttDaemonAdmin不管用的
[instanceadmin@localhost conf]$ttDaemonAdmin -stop
[instanceadmin@localhost conf]$ttDaemonAdmin -start

 

3.查看设置是否生效
[instanceadmin@localhost ~]$ ttisql sampledb

Command> call ttconfiguration('permsize');
< PermSize, 9192 >
1 row found.

 

4.重新设置内存策略为always
[instanceadmin@localhost ~]$ ttadmin -rampolicy always sampledb

查看
[instanceadmin@localhost ~]$ ttadmin -query sampledb
RAM Residence Policy : always
Replication Agent Policy : manual
Replication Manually Started : False
Cache Agent Policy : manual
Cache Agent Manually Started : False
Database State : Open