"Knut Stolze" <stolze@de.ibm.com> wrote in message news:doge0g$1ho$1@lc03.rz.uni-jena.de...
> bikkaran@in.ibm.com wrote:
>
>> I have a table that contains 15lakh records.....
>> I want delete that table....and insert fresh set of record.
>>
>> when I run the command ...db2 "delete from schema.tabname"
>> it hangs .......the system it seems hangs...
>
> No, it doesn't hang. It just takes a lot of time to delete every single
> record. (How many records are "15 lakh"?)

15 lakh = 1.5 million