神舟数据库日常维护

1.查看所有配置
SQL>show all;

 

2.查看具体某个参数
SQL> show max_connections;
name | setting
--------------------------+---------
MAX_CONNECTIONS | 200
MAX_CONNECTIONS_PER_USER | 0

SQL> show NAME_CASE_SENSITIVE;
name | setting
---------------------+---------
NAME_CASE_SENSITIVE | TRUE
(1 row)

修改配置参数
vi /opt/ShenTong/admin/HXL.conf

#SQL中表名和列名是否区分大小写，为FALSE时SQL里小写也可以匹配上数据库里大写的表名列名
NAME_CASE_SENSITIVE=false

重启
systemctl stop oscardb_HXLd.service
systemctl start oscardb_HXLd.service
systemctl status oscardb_HXLd.service

再次查看参数
[root@localhost bin]# ./isql -h localhost -p 2003 -d HXL sysdba
密码是:szoscar55

SQL> show NAME_CASE_SENSITIVE;
name | setting
---------------------+---------
NAME_CASE_SENSITIVE | FALSE
(1 row)
SQL>