DB2 Enterprise Stage - Truncate Option
Posted: Thu May 07, 2009 9:05 pm
Hi All,
Does the 'Truncate' load method in DB2 enterprise stage, issue a 'delete from <table>' command behind the scenes (mean it is logged transaction)? Or does it do a non-logged delete?
If it does a logged delete, then is there a way to do a truncate of the table before loading it from DB2 enterprise stage?
Also, I tried to give the command alter table #db2_tgt_db#.#db2_tgt_table# activate not logged initially with empty table; in the 'Open Command' of the DB2 enterprise stage, but it errored out. Is it allowed to issue this statement in the open command?
thanks
Does the 'Truncate' load method in DB2 enterprise stage, issue a 'delete from <table>' command behind the scenes (mean it is logged transaction)? Or does it do a non-logged delete?
If it does a logged delete, then is there a way to do a truncate of the table before loading it from DB2 enterprise stage?
Also, I tried to give the command alter table #db2_tgt_db#.#db2_tgt_table# activate not logged initially with empty table; in the 'Open Command' of the DB2 enterprise stage, but it errored out. Is it allowed to issue this statement in the open command?
thanks