Note that from the point you issue that command and your next backup, the
table is exposed to the fact that it could never be recovered by a restore
tablespace. All actions on the table from then to a possible crash would be
in the logs but the activate not logged, when rolled forward through, would
make the table inaccessible and your only option would be to frop and
recreate.
Regards, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "Singh Rahul" <db2udbdba-ezmlmshield-x1834873.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, July 31, 2006 7:34 AM
Subject: RE: drop a large table


> 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.
>
>
>
>
>
> ---------------------------------------------------------------------
> 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