Quick deletion of db2 data without writing logs IBM official documentation: Use the not logged initially parameter to reduce logging if an application creates and fills a worksheet Based on the master table, in addition, you do NOT worry about the recoverability of these worksheets (because you can easily re-CREATE them based on the master TABLE), you can specify the not logged initially parameter on the create table statement when creating a worksheet. This reduces log records and improves performance. The advantage of using the not logged initially parameter at www.2cto.com is that it does NOT record any changes (including insert, delete, update, or index creation) made to the table in the same work unit that creates the table ). This not only reduces the log record workload, but also improves application performance. You can also use the alter table statement with the not logged initially parameter for an existing TABLE to obtain the same result. 1. update command options using c off -- disable automatic submission 2. alter table tabname activate not logged initially -- set do NOT log or add attribute not logged initially 3 when creating a TABLE. delete from tabname -- delete data 4. commit -- manually submit 5. update command options using c on -- enable automatic submission