Serge Rielau wrote:

> 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...
>>
>> Is their a better way out to delete the data..

> ALTER TABLE T ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
> COMMIT;

Now that is a cool way to do the truncation. ;-)

--
Knut Stolze
DB2 Information Integration Development
IBM Germany