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
No comments:
Post a Comment