I had the same problem until I did the following:

"load from /dev/null of del replace into <table name> NONRECOVERABLE"

Regards

Mike D

-----Original Message-----
>From: DANIEL CALLAHAN <db2udbdba-ezmlmshield-x20202588.[Email address protected]
>Sent: Apr 24, 2006 6:29 AM
>To: LazyDBA Discussion <[Email address protected]
>Subject: Re: Truncating taking long time.
>
>
>
>
>
>If you are deleting all the rows in the table :
>
> 1) Drop the table
>
>If there is a small amount of rows that you want to keep:
>
> 1) export the small amount
> 2) drop the table
> 3) import the exported data
>
>Your way of importing with a null input is also valid.
>
>
>
>
>
> "Jayaprakash.Band
> aru "
> <db2udbdba-ezmlms To
> hield-x41344569.x "LazyDBA Discussion"
> [Email Address Removed] <[Email address protected]
> a.com> cc
>
> 04/24/2006 01:41 Subject
> AM Truncating taking long time.
>
>
>
>
>
>
>
>
>
>
>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.
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>website: http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>---------------------------------------------------------------------
>PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
>website: http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>


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