当前会话设置隔离级别(能查询到正在执行的写入表的数据行数):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)=0in z1dbs1,
mod(apply_time,10)=1in z1dbs2,
mod(apply_time,10)=2in z1dbs3,
mod(apply_time,10)=3in z1dbs4,
mod(apply_time,10)=4in z1dbs5,
mod(apply_time,10)=5in z1dbs6,
mod(apply_time,10)=6in z1dbs7,
mod(apply_time,10)=7in z1dbs8,
mod(apply_time,10)=8in z1dbs9,
mod(apply_time,10)=9in z1dbs10
;
topic 分片策略
列表分片>表达式分片>轮转分片>不分片
查看表属性
dbaccess dbname -
#查看表的结构
info columns for tabname;#查看对应表的索引
info indexes for tabname;#查看表的分片
info fragments for tabname;