方法一:TRUNCATE
TRUNCATE TABLE tabname IMMEDIATE
删除表内行
可 立即/延迟 释放存储
可 忽略/限定 DELETE触发器
可设定自增序列策略
Syntax
.-TABLE-. .-DROP STORAGE--. >>-TRUNCATE--+-------+--table-name--+---------------+-----------> '-REUSE STORAGE-' .-IGNORE DELETE TRIGGERS--------. >--+-------------------------------+----------------------------> '-RESTRICT WHEN DELETE TRIGGERS-' .-CONTINUE IDENTITY-. >--+-------------------+--IMMEDIATE----------------------------><
方法二:ALTER TABLE
ALTER TABLE tablename ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE
清空表数据,不记录日志
具体参见:http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0000888.html
方法三:IMPORT
IMPORT FROM anyemptyfile OF DEL/IXF REPLACE INTO tablename
方法四:LOAD
LOAD FROM anyemptyfile OF DEL REPLACE INTO schema.tabname NONRECOVERABLE
不建议使用,容易引起表空间或者表状态异常