RE: BLOB data and mirroring

Thanks, Jack! The files are not stored on the IFS, but only as Blob data in the database. Further investigation has led us to believe that we should be able to mirror the data to our supporting servers through a remote journal and we are working on coding and testing that right now.

Chris


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jack Kingsley
Sent: Thursday, July 22, 2021 3:24 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: BLOB data and mirroring

Chris, are you storing these in the IFS. What OS version, possibly you could use db2-mirror.

https://www.itechsol.com/an-explanation-of-ibm-i-7-4-db2-mirror-for-i/

On Mon, Jul 19, 2021 at 2:00 PM Chris Wright <Chris.Wright@xxxxxxxxxxxxxxx>
wrote:

Hi,



We have recently started storing PDF file as BLOB objects in an
iSeries database table. Writing to and reading from these tables is
instant and works perfectly using a java application and the JT400 toolbox.



However, we now have the requirement of being able to mirror this data
to other production systems and I'm pretty sure that our current model
of using a data queue is not going to be suitable for this type of
data. Am I right? And if so, what are our options?



Regards


Chris Wright
Senior Analyst/Programmer
CrossCheck, Inc.

707.665.2100, ext. 1114
chris.wright@xxxxxxxxxxxxxxx<mailto:chris.wright@xxxxxxxxxxxxxxx>
www.cross-check.com
<../../../../ChrisW/Application%20Data/Microsoft/Signatures/
www.cross-check.com>


Notice of Confidentiality: This e-mail, and any attachments thereto,
is intended only for use by the addressee(s) named herein and may
contain legally privileged and/or confidential information. If you are
not the intended recipient of this e-mail, you are hereby notified
that any dissemination, distribution or copying of this e-mail, and
any attachments thereto, is strictly prohibited. If you have received
this e-mail in error, please immediately notify me by e-mail (by
replying to this message) or telephone (noted above) and permanently
delete the original and any copy of any e-mail and any printout
thereof. Thank you for your cooperation with respect to this matter.

qPlease consider the impact to the environment before you print this
email


--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com