Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > IBM DB2 > Re: Row and Sta...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 11 Topic 8868 of 9234
Post > Topic >>

Re: Row and Statement based Trigger Question

by "walker.l2" <walker.l2@[EMAIL PROTECTED] > May 9, 2008 at 05:13 AM

> If I enable journaling on the
> archive table would that make it safer?
>
Yes.

> Would there be a performance [penalty]
>
I don't believe so. If I remember correctly, the OS will cache the
inserts until a COMMIT is issued.

> and disk space penalty?
>
Yes. Journalling does require some disk space.

> What I would really like would be for the delete to run for a while,
> and then be able to interrupt the delete, with the corresponding
> inserts completing. Then I could restart the delete another time.
>
You could do this by making the delete a programmed housekeeping /
archive process, rather than relying on a trigger.
Are you likely to be doing bulk (multi-million row) deletes? That
suggests that your delete / housekeeping / archive process is perhaps
not very well designed. (Of course, it might not be avoidable in your
case, but to me this is a bad sign.)
 




 11 Posts in Topic:
Row and Statement based Trigger Question
JohnO <johno1234@[EMAI  2008-05-08 16:45:18 
Re: Row and Statement based Trigger Question
JohnO <johno1234@[EMAI  2008-05-08 16:49:31 
Re: Row and Statement based Trigger Question
Serge Rielau <srielau@  2008-05-08 21:04:49 
Re: Row and Statement based Trigger Question
JohnO <johno1234@[EMAI  2008-05-08 18:42:39 
Re: Row and Statement based Trigger Question
"walker.l2" <  2008-05-09 05:13:46 
Re: Row and Statement based Trigger Question
JohnO <johno1234@[EMAI  2008-05-10 15:51:59 
Re: Row and Statement based Trigger Question
Serge Rielau <srielau@  2008-05-10 22:36:42 
Re: Row and Statement based Trigger Question
JohnO <johno1234@[EMAI  2008-05-11 13:34:37 
Re: Row and Statement based Trigger Question
"walker.l2" <  2008-05-12 02:20:20 
Re: Row and Statement based Trigger Question
JohnO <johno1234@[EMAI  2008-05-12 18:33:43 
Re: Row and Statement based Trigger Question
"walker.l2" <  2008-05-14 01:47:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Aug 29 18:17:11 CDT 2008.