Bulk delete from table using db2 connector?
Posted: Wed Nov 21, 2012 1:07 pm
Hi,
I have one table with 70 Million recs. I need to make fresh load into the table using a file have 72 Million recs.
So I created a job; Seq_file--->Transformer--->db2_connector
In db2_connector I tried with:
Write Mode- Insert & Table Action-Truncate - This caused by DB transaction log full while deleting the data from table.
I tried one more with Before routine:
db2 "connect to DBNAME user USERNAME using Pwd"; db2 "load from /dev/null of del replace into TABLE_NAME NONRECOVERABLE"
and made the db2 connector as Write mode - Insert & table action - Append.
In this case, the first query executed successfully but for the second one I got "SQL1024N A database connection does not exist. SQLSTATE=08003"
Anyother way where I can achieve this?
I have one table with 70 Million recs. I need to make fresh load into the table using a file have 72 Million recs.
So I created a job; Seq_file--->Transformer--->db2_connector
In db2_connector I tried with:
Write Mode- Insert & Table Action-Truncate - This caused by DB transaction log full while deleting the data from table.
I tried one more with Before routine:
db2 "connect to DBNAME user USERNAME using Pwd"; db2 "load from /dev/null of del replace into TABLE_NAME NONRECOVERABLE"
and made the db2 connector as Write mode - Insert & table action - Append.
In this case, the first query executed successfully but for the second one I got "SQL1024N A database connection does not exist. SQLSTATE=08003"
Anyother way where I can achieve this?