Skip to Content
0
Sep 08, 2008 at 08:33 PM

How to delete all rows from a target table

180 Views

How can I delete all the rows from the target table without filling up the db2 logs? I tried checking the box on the target table that says to delete all rows, but our db2 logs end up getting blown out.

Is there another way to empty the table/delete all rows without logging?

Thanks.