before DB2 v9.7, there is not truncate command like Oracle's Truncate.
On oracle, you can use "truncate table"
On DB2 v9.7,
you can use "db2 truncate table immediate"
On DB2 v9.5,
1. you can use "db2 alter table activate not logged initially with empty
table" to delete all rows.
2. user "db2 alter table activate not logged initially" to disable the log file, then delete rows.
alter table activate NOT LOGGED initially;
delete from table_name where .....;
3. db2 load from empty.del of del messages msg.out replace into