× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



>RI always requires that parent row be written prior to child row.  
>If attempt to write the child first is processed, that will be 
>immediately followed with a rollback transaction. 

True. But the parent row was written before the child, it's just that
the child had been pushed to disk but the parent hadn't when they lost
power. So the inserts would have been ok, but since we lost data we'd
not have a child w/o a parent.

>I would not want to run without journaling or RI.

No argument from me there. 

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don Tully
Sent: Sunday, January 16, 2005 1:38 PM
To: Midrange Systems Technical Discussion
Subject: RE: Journaling for data recovery - Lost records.

All machines (and customers) of mine have used journaling since 1992.
All systems that I have built since 1995 have used RI on all non-work
files.  RI always requires that parent row be written prior to child
row.  If attempt to write the child first is processed, that will be
immediately followed with a rollback transaction.

Journaling can be very "expensive" if the application is poorly written.
By that, I mean retrieving of records for update-- requiring record
locking-- and updating with the same image or only change is to audit
time stamp.  The old update primary file program where only a very small
portion of the records actually needing to be updated. If those culprit
programs are corrected, journaling has a minimal impact.. maybe in 3 to
5% range.  At least that has been my experience.

Journaling also provides a gold mine for testing.  Rather than just
looking at some end results, examine the journal and see all of the
database updates.  One is often amazed at updates that would otherwise
surely go unnoticed until down the road and  some seemingly unrelated
data problem is noticed.

I would not want to run without journaling or RI.

Don Tully
Tully Consulting LLC

-----Original Message-----
Subject: Journaling for data recovery - Lost records.

...
On a related topic, what would have happened if we had declared RI
between the invoice detail and invoice detail-detail tables? Would we
now have a child row w/o a parent row?

I told the client that he should turn on journaling on all his files as
standard practice, but I got the old "Journaling is too expensive"
response. I know that has changed over the years, but does IBM have any
whitepapers to that effect?

-Walden

------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx <mailto:WaldenL@xxxxxxxxxxxxxxx>
http://www.TechSoftInc.com <http://www.techsoftinc.com/>

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.