22 June,2012 by Jack Vamvas
I was reviewing some DB2 DBA scripts and noticed the usage of the old-school TRUNCATE method.
ALTER TABLE schema.table_name activate not logged initially with empty table
Since DB2 9.7 – there is now the TRUNCATE TABLE command.
TRUNCATE TABLE WHLOGS IGNORE DELETE TRIGGERS DROP STORAGE IMMEDIATE