To truncate DB2 Table

DB2 Truncate is not as straight forward as Oracle Truncate. If in Oracle you can use “truncate table “…  You may use the below command to truncate table in db2.

alter table schema.table_name activate not logged initially with empty table