Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to delete all rows from a target table

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.

Not what you were looking for? View more on this topic or Ask a question