Tuning a Delete in DB2

DB_N00b · #1 (**permalink**) 04-07-11, 03:34

Hello Guys,

Today I started a "delete from schema.example" and it takes hours ...
Is there a way of making this faster?

Thanks in advance!

sathyaram_s · #2 (**permalink**) 04-07-11, 03:36

9.7 - TRUNCATE command

pre-9.7
IMPORT FROM /dev/null of del replace into <tname>
ALTER TABLE <tname> NOT LOGGED INITIALLY WITH EMPTY TABLE

DB_N00b · #3 (**permalink**) 04-07-11, 03:43

Thanks Dude! :-)

nvk@vhv · #4 (**permalink**) 04-07-11, 07:23

Quote:

Originally Posted by sathyaram_s

...
pre-9.7
IMPORT FROM /dev/null of del replace into <tname>
ALTER TABLE <tname> NOT LOGGED INITIALLY WITH EMPTY TABLE

I'ld prefer the import command, because i does not cause trouble in case of a restore.

sathyaram_s · #5 (**permalink**) 04-07-11, 08:02

i agree with nvk@vhv and guess TRUNCATE's the same