Wednesday, 25 June 2014

How to insert, delete, update data without generate logs on DB2

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