环境:
OS:Centos 7
DB:18.1.14
1.查看当前的连接数
Command> call ttconfiguration('connections');
< Connections, 95 >
1 row found.
2.修改配置文件
vi sys.odbc.ini
connections=200
3.重启动ttDaemonAdmin
[instanceadmin@localhost conf]$ttDaemonAdmin -stop
[instanceadmin@localhost conf]$ttDaemonAdmin -start
查看
[instanceadmin@localhost ~]$ ttisql sampledb
Command> call ttconfiguration('connections');
< Connections, 95 >
1 row found.
发现不生效,下面重新加载
[instanceadmin@localhost ~]$ ttadmin -rampolicy manual sampledb
[instanceadmin@localhost ~]$ ttadmin -ramunload sampledb
[instanceadmin@localhost ~]$ ttadmin -ramload sampledb
[instanceadmin@localhost ~]$ ttadmin -rampolicy always sampledb
继续查看
Command> call ttconfiguration('connections');
< Connections, 200 >
1 row found.
看到已经生效
说明:
最开始直接修改参数重启,发现一直无法启动
TT14000: TimesTen daemon internal error: Could not send 'manage' request to subdaemon
后面修改kernel.sem就可以了.
Modify /etc/sysctl.conf to that value, so that after a reboot it uses this value again:
kernel.sem = 655 32000 100 128