Hi,

Truncating data from a table having millions of rows is taking long time
( It took apprx. 5 hrs to delete all the rows in that table).

I have used the command "load from /dev/null". Any valid suggestions are
appreciated.

Thanks,
Jayaprakash.

DB2 & UDB email list listserv db2-l LazyDBA home page