A very useful approach to clearing down data from tables. This will truncate a specific table, without it being logged. Use with caution!
ALTER TABLE schema.table_name activate not logged initially with empty table
Republished from http://www.dba-db2.com/.