【DB2】db2常用SQL语句集合

持续更新中

1.修改日志模式为不记录

alter table table_name  activate not logged initially;

2.清空表

alter table t1 activate not logged initially with empty table;

3.查询表数据记录数

select tabname,card from syscat.tables where tabschema = 'you table schema'