»Ø¸´: Re: how to empty table more fast

elibs

»Ø¸´: Re: how to empty table more fast
Hi,David:
Thank you for your kind help.
I am afraid that I maybe have made you misunderstood.What I mean is that
I don't want to take charge of the deletion of the table which it is the
batch programe 's job,for the program has issued the DELETE table1 in the
runtime that is dedicated to empty the whole table.I have analysed the
programe that most of its run time is spent on the DELETE sql.So I wonder
whether there are other ways to make the DELETE sql more faster?

Thank you

Larry


-----Original Message-----
·¢¼þÈË: Seibert, Dave <[login to unmask email]>
ÐÂÎÅ×é: bit.listserv.db2-l
ÊÕ¼þÈË: [login to unmask email] <[login to unmask email]>
ÈÕÆÚ: 2001Äê1ÔÂ5ÈÕ 23:27
Ö÷Ìâ: Re: how to empty table more fast


>Hi Larry,
>
>Under normal circumstances, the fastest way to delete all rows from a table
>is using the LOAD utility with an empty input dataset. It's late here and
>it's been awhile, but if I recall, if the tablespace is partitioned you
need
>to LOAD each partition with nothing.
>
>Check the Util manual.
>
>Good luck
>
>David Seibert
>Compuware Corporation File-AID Product Architect
>[login to unmask email]
>
>
>





elibs

»Ø¸´: Re: how to empty table more fast
(in response to elibs)
Hi,HTH:
My sql is simply DELETE FROM db1.table1.
Thanks
Larry
-----Original Message-----
·¢¼þÈË: Thomas E. Faglon <[login to unmask email]>
ÐÂÎÅ×é: bit.listserv.db2-l
ÊÕ¼þÈË: [login to unmask email] <[login to unmask email]>
ÈÕÆÚ: 2001Äê1ÔÂ6ÈÕ 18:35
Ö÷Ìâ: Re: how to empty table more fast


>
>
>Larry,
> How large is the table?
>I use the following sql to delete plan tables
>DELETE
>FROM &CREATOR.PLAN_TABLE ;
>very fast for 250,000 rows.
>What does your sql look like?
>HTH Tom F
>
>
>
>
>
>elibs <[login to unmask email]> on 01/05/2001 08:53:32 AM
>
>Please respond to DB2 Data Base Discussion List <[login to unmask email]>
>
>To: [login to unmask email]
>cc: (bcc: Thomas E. Faglon/Telcordia)
>Subject:



Thomas E. Faglon

Re: »Ø¸´: Re: how to empty table more fast
(in response to elibs)


Hi,
all your deletes are writing to the log , use one of the utility
methods mentioned before
load dummy replace no log.
Tom F




elibs <[login to unmask email]> on 01/05/2001 07:32:50 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Thomas E. Faglon/Telcordia)
Subject:

elibs

»Ø¸´: Re: how to empty table more fast
(in response to Thomas E. Faglon)
hi,John,
I agree with your advice.
My table is Segmented T/S with RI.since I really do not want to chage the
businese batch job,I will go and discuss with AP.
thank you and all others.
Sincerely
Larry

-----Original Message-----
·¢¼þÈË: John Hardy <[login to unmask email]>
ÐÂÎÅ×é: bit.listserv.db2-l
ÊÕ¼þÈË: [login to unmask email] <[login to unmask email]>
ÈÕÆÚ: 2001Äê1ÔÂ8ÈÕ 10:48
Ö÷Ìâ: Re: how to empty table more fast


>Larry,
>
>Now that we're all agreed that the Dummy Load Replace is a good thing,
>assuming DB2 for OS/390 (which is what I infer from your recent series of
>questions) : What kind of Tablespace is your table on?
>
>Segmented T/S: Your Mass Delete involves setting a flag on the Spacemap.
>This will not take 10 minutes! One big exception I can see: If you have an
>RI Relationship from another table dependant on columns in your table,
>then I am sure that this must result in the rows being deleted one at a
>time, even in a segmented T/S - Does anybody here know for sure about this
>one? - Of course, in this situation, the use of our super-duper Dummy Load
>Replace would set our hypothetical dependant RI table(s) to Check
>Pending.
>
>Partitioned T/S: Only a very odd requirement would require a need to
>regularly wipe out an entire Partitioned Tablespace.
>
>Simple T/S: Easy. Drop your tablespace and recreate it as Segmented right
>away.
>
>
>
>On Mon, 8 Jan 2001 17:12:25 +0200, Aratos Sicyon
><[login to unmask email]> wrote:
>
>>Please could everybody to try and pay attention. Now we all know, thanks
to
>>many many contributions, that you can empty a tablespace by loading empty
>>file. Please nobody tell us this again. Thank you!
>>
>>Dummy load the table - LOAD REPLACE with no input dataset...
>>
>>George
>>
>>
>>
>the
>>
>>
>>
>>_________________________________________________________________________
>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>>
>>
>>
>
>
>
>
>