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/.......