DB2可用于清空大量数据表的not logged initially
create table tablename(id int, name char(20)) not logged initially;
对于创建表时设定了not logged initially的表而言,在命令行中,可以在交易中指定不记录日志:
alter table [tablename] activate not logged initially;
也可以考虑使用activate not logged initially清空表而不产生日志:
alter table [tablename] activate not logged initially with empty table;
commit;