INFORMIX 数据库空间物理日志，逻辑日志，数据库会话级的存储过程，数据表的分片

数据库监控的相关命令

#查看数据库的状态
onstat - 
#查看数据空间
onstat -d
#命令查看日志：
onstat -m
#查看逻辑日志和逻辑日志每个文件的大小
onstat -l
#关闭数据库
onmode -ky
清理共享内存
onclean -ky

查看checkpoint的命令

onstat -g ckp

日志相关操作命令

清空测试库的事务日志
ontape -s -N databasename -t /dev/null
 onspaces -c -d datadbs  -p /opt/gbase8t/dbs/datadbs -o 0 -s 10000000

### session级存储过程的创建基于database
```shell
数据库会话级参数的设置的存储过程
dbaccess testdb -
#testdb库下的session 生效参数，每次连接的时候 这两个参数生效
create procedure public.sysdbopen()
set lock mode to wait 2000;
set isolation to committed read retain update locks;
end procedure;

其它相关设置

当前会话设置隔离级别(能查询到正在执行的写入表的数据行数):set isolation to dirty read;
查看当前执行的sql：onstat -g sql 0 
查询ckp的点：onstat -g ckp
添加新的逻辑日志:onparams -a -d llog -s 1000000 -i
删除逻辑日志:onparams -d -l lognum -y


时间格式：
to_char(sysdate year to second,'YYYYMMDDHH24MISS')
to_char(now(),'YYYYMMDDHH24MISS') 
to_char(sysdate,'YYYYMMDDHH24MISS')

数据表表达式分片策略

数据表的分片:
create table testtb (
	DN CHAR(64) NOT NULL,
	name CHAR(64) NOT NULL,
	CODE CHAR(64) NOT NULL,
	PASSWORD CHAR(50) NOT NULL,
	PHONE  CHAR(11),
	TER_TYPE CHAR(1) NOT NULL,
	TER_FLAG CHAR(100) NOT NULL,
	STATUS CHAR(1) NOT NULL,
	EXPIRE_DATE CHAR(8) NOT  NULL,
	ID_TYPE CHAR(1) NOT NULL,
	APPLY_TIME CHAR(14) NOT NULL,
	UUID CHAR(32) NOT NULL) 
	fragment by expression
	mod(apply_time,10) = 0 in z1dbs1,
	mod(apply_time,10) = 1 in z1dbs2,
	mod(apply_time,10) = 2 in z1dbs3,
	mod(apply_time,10) = 3 in z1dbs4,
	mod(apply_time,10) = 4 in z1dbs5,
	mod(apply_time,10) = 5 in z1dbs6,
	mod(apply_time,10) = 6 in z1dbs7,
	mod(apply_time,10) = 7 in z1dbs8,
	mod(apply_time,10) = 8 in z1dbs9,
	mod(apply_time,10) = 9 in z1dbs10
	;

topic 分片策略

列表分片>表达式分片>轮转分片>不分片

查看表属性

dbaccess dbname -
#查看表的结构
info columns for tabname;
#查看对应表的索引
info indexes for tabname;
#查看表的分片
info fragments for tabname;