RE: Large volume file move

Actually I'm working with a customer now to replace the storage of the PDF in the IFS and store it as a blob object in DB2 as a column in the invoice file.
--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Raul Jager
Sent: Wednesday, September 26, 2018 4:17 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Large volume file move

Will it be better to store a lot of files as blob in a table?. They will count as one object, and I think back up will be faster. But I have no experience, I am just asking.

On 9/26/18 2:55 PM, Richard Schoen wrote:

OK, I think I got it.

He would definitely need to do lots of scenario testing before replacing his current method of using Windows for IFS document storage.

Especially due to the object permissions and backup/recovery potential issues.

I still vote for leaving the IFS objects on the Windows server being backed up with backup exec, however it's not my shop.

FWIW: One way to speed up overall small file backup on a Windows server as well is to create a Virtual Hard Drive (VHD) similar to the iASP.

Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

------------------------------

message: 3
date: Wed, 26 Sep 2018 13:41:25 -0500
from: "Jim Oberholtzer" <midrangel@xxxxxxxxxxxxxxxxx>
subject: RE: Large volume file move

It would be one object, however as I pointed out the advantage of
backing that up as one object is all but eliminated with Asynchronous Bring.

The other disadvantage would be in order to back up the UDFS, you
would have to bring down the iASP for the duration of the save. Not terribly useful.


I addressed speed of backup in an earlier post where you get a primary
backup, then only add incremental backups of new objects appended to
the same tape.

On a monthly or quarterly basis resave the entire iASP and start over
to maintain audit controls .

--
Jim Oberholtzer
Agile Technology Architects

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
-- Verificado por Anti-Virus Corporativo Symantec --
--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD