Whenever I load data by using DB2 LOAD utility I am forced to take backup. can this be avoid by anyway?

Thanks,

Yes, use the NONRECOVERABLE option. Cautiously... make sure you look over the docs to make sure you really want to do this, as implied it means you cannot recover that table data.

jono

I have the same problem, where can I find docs relate to nonrecoverable option? Can you jave me a sample contains db2 load with nonrecoverable option?

Thanks!
Lan

Look in Command Refference.

It's in the Command Reference.

LOAD FROM xxx.del of del insert into mytable NONRECOVERABLE

Again - be careful. If you ever get put in a position where you have to RESTORE, that table is toast if you used this option and go past the point in time of the LOAD.