All rows can also be deleted by this alter command :

ALTER TABLE TABLE1 ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
COMMIT;

Rahul

-----Original Message-----
From: quigleyd [mailto:[Email address protected]
Sent: Tuesday, July 25, 2006 6:39 PM
To: Singh, Rahul
Subject: RE: drop a large table

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


it does the same thing as a truncate, db2 does not have a truncate command,
that command is what most folks use as a shortcut to a delete statement.




Quoting Singh Rahul [Email address protected]

> What is it doing? Is it same as truncate / delete table in oracle.
> Is truncate table supported in DB2?
>
> -----Original Message-----
> From: senthil1 [mailto:db2udbdba-ezmlmshield-x1416484.[Email address
> protected]
> Sent: Tuesday, July 25, 2006 6:58 PM
> To: LazyDBA Discussion
> Subject: Re: drop a large table
>
> IMPORT FROM /dev/null OF DEL REPLACE INTO schema.tablename;
>
> then drop the table
>
> Senthil S.
> Tata Consultancy Services Limited
> Mailto: senthil1.[Email address protected]
> Website: http://www.tcs.com
>
>
>
> "Rahul Yadav " <db2udbdba-ezmlmshield-x51117444.[Email address protected]
> 07/25/2006 06:43 PM
>
> To
> "LazyDBA Discussion" <[Email address protected]
> cc
>
> Subject
> drop a large table
>
>
>
>
>
>
> I want to drop a table it has some 2 lakh records and taking too much
> time,is there any way to do it fast??
>
> Best Regards,
>
> Rahul Yadav
> Software Engineer
> Daffodil Software Ltd.
> 2nd Floor,Vipul Orchid Plaza,
> Sun City,Sector 54,
> Gurgaon,India.
>
> Mobile:+91 9868679702
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
> ForwardSourceID:NT00014156
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>
>
>
> ---------------------------------------------------------------------
> 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
>


tr

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.




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