Forgot your password?
Document Actions
How to truncate a table
to delete all data from one table in the DB2 remotely
You have two commands:
db2 alter table table_name activate not logged initially with empty table
or
db2 load from /dev/null of del replace into <table_name> nonrecoverable
or remotely:
db2 load client from /dev/null of del replace into <table_name> nonrecoverable
db2 "select tabschema,tabname from syscat.tables where status = 'C' order by tabschema, tabname"
db2 set integrity for <tabname> immediate checked
Hacker Rangers - Gamification for CyberSecurity