×
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.
We too started journalling due to HA replication. I fought to get it
started long before then but it was postponed until we had to.
We are also doing "journal scraping" until we can do temporal tables. In
our case we retain our receivers for 80 days. Consequently the size taken
up by our journals is HUGE. 2.3TB huge. About 4 times the size of our
biggest file library
% of Size in
Library Owner Disk 1000 bytes
#MXJRN MIMIXOWN 41.23 2367006642.2
ERPLXF SSA 9.66 554522578.9
Why yes there is such an SQL service. It is called DISPLAY_JOURNAL. The
trick is getting the column ENTRY_DATA mapped against an external data
structure of the original table. At this time we aren't using it. Instead
they are using more RLA oriented techniques which involved DSPJRN to an
outfile. Did I mention that doing this DSPJRN scraping method often
pushes our disk over threshold? And we've no slouch of a system.
Auxiliary storage:
System ASP . . . . . . : 5741 G
% system ASP used . . : 82.6227
Rob Berendt
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.
midrange.com
