Delete 5000k records in a table

[CLK]

Hello PUG :
I need to erase almost 5000k records in a table, but it takes too much time , almost 12 hours. and I cann't give the luxury to leave the system too much inactive time :no: .
Can somebody give me some suggestion or procedure to optimize this process.
I already used the -i parameter, other best idea to increment faster the delete process ???
regards
C.L.K.

 

[ranger101]

if you're clearing the entire table then ...

try removing the table from the database via data dictionary

maybe this way leaves out all the work associated with deleting a single record

i.e. updating indexes, writing to the bi file etc.

afterwards you can load back the data definitions



hth ... please tell me if it works