Forgot your password?
Document Actions
How to insert, delete, update data without generate logs on DB2
using alter table <table_name> activate not logged initially
ON CLP:
db2 +c alter table <table_name> activate not logged initially
db2 +c delete from <table_name> where <column_name>='<value>'
OR
db2 +c insert into table <table_name> (select * from table_name)
OR
db2 +c update table_name set <column_name>='value' where <column_name>='value'
db2 commit
ON TOAD EDITOR OR ON THE OTHER EDITOR:
db2 alter table <table_name> activate not logged initially
db2 delete from <table_name> where <column_name>='<pattern>'
OR
db2 insert into table <table_name> (select * from table_name)
OR
db2 update table_name set <column_name>='value' where <column_name>='value'
db2 commit
Hacker Rangers - Gamification for CyberSecurity