Richard:
Your basic instincts are correct, backing up one object is going to be
faster, but only marginally, particularly if you use Asynchronous bring.
Keep in mind assuming you save the directory subtree, the directory
structure is saved first, then the objects below it. Asynch bring will
pre-fetch the smaller files into memory so the tape is moving almost as fast
as it can. The effect of saving multiple objects is then mitigated vs. the
single large file.
Either way the IFS is not going to compete with Unix or Windows file serving
from a pure speed perspective. Where backup/recovery, management of the
system, cost of acquisition, etc. are taken into account IBM i can win that
argument almost every time, except where the application needs extremely
fast access to IFS objects. Larry's point is a good one. TCO is far lower
with IBM i than a mix of systems, and the headaches that entails.
--
Jim Oberholtzer
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Richard Schoen
Sent: Wednesday, September 26, 2018 1:01 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Large volume file move
So backup up an ISO image would speed backup times because it gets the
entire disk blob from the IFS.
Isn't an unmounted UDFS also the equivalent of a disk blob (think the old
Windows File Server IOP) so backup of that would be similar to backing up a
disk blob ?
I would think the main benefit being that the tape can stream at full speed
because it's backing one large object rather than a bunch of individual
objects.
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 11:16:26 -0500
from: "Jim Oberholtzer" <midrangel@xxxxxxxxxxxxxxxxx>
subject: RE: Large volume file move
An ISO is merely a file on the file system no different than any other file,
except for the contents.
An iASP is really a UDFS and is "mounted" when the backing device is varied
on.
You can back up the UDFS directly but then there is no file level recovery.
Most folks will just back up the iASP along with the balance of the IFS. In
this case that would be foolish. I would have a tape that I initially
backed up the iASP with, then build incremental saves of only new objects on
the same tape. BRMS would do this nicely for you. Then recovery of a
single object would be simple. Clearly the save would be very fast as well.
Remember, to access the iASP IFS file system you only have to use the iASP
name in the path, so a directory Agile, with file Source would be addressed
like: /myiaspname/agile/source. (Assuming the iASP is varied on and
available)
--
Jim Oberholtzer
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Richard Schoen
Sent: Wednesday, September 26, 2018 10:30 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Large volume file move
Hey Jim,
Do you know if an iASP would be considered a disk blob similar to the way a
disk based ISO image is ?
If that's the case, then backing it up should be better than backing up
individual small IFS files.
Nobody seems to be able to answer this question for me.
Thanks
Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com
------------------------------
message: 7
date: Wed, 26 Sep 2018 10:15:50 -0500
from: "Jim Oberholtzer" <midrangel@xxxxxxxxxxxxxxxxx>
subject: RE: Large volume file move
Then you need to rethink the process. Sure that's absolutely safest,
however how long will it take? What is the chance of issues with only
adding new? Down time is getting harder to get, and if the backup/restore
fails for some reason and it has to restart you've just bought a whole bunch
more down time.
I used to think image catalogs were not worth the time, now I can't imagine
working without them. I used to think PuTTY and SSH were for Unix, now I'm
on IBM i more than half the time with SSH via PuTTY. When Mike Pavlak
started the whole PHP thing on IBM I many years ago, I never thought open
source languages would ever catch on, clearly I was wrong about that. The
point is: "We've always done it that way" is one of the poorest excuses in
business and you partner has to start thinking about your needs not the
safest, easiest way to do it. Oh and by the way, that also adds lots of
billable hours to the process, as an added bonus to the partner.
--
Jim Oberholtzer
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Justin Taylor
Sent: Wednesday, September 26, 2018 7:57 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Large volume file move
In the past, our BP has always done another full restore for the actual
cut-over.
--
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
------------------------------
message: 4
date: Wed, 26 Sep 2018 12:25:20 -0400
from: dlclark@xxxxxxxxxxxxxxxx
subject: Re: Problem with creating a file with a different field name
"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 09/26/2018
12:04:04 PM:
Before I forget - we are on V7r3
When I use STRSQl with the following command Select Cust# as
Customer_nbr from File01 where FieldB = 'SOMEVALUE'
Data is displayed, with the column heading Customer_Nbr
When I run the same query AFTER pressing F13, choose 1. Change session
attributes Change SELECT output to 3 (for File) and define a file name
The file is created, with the field Customer_Nbr
However, when I change the query to the following Create or replace
table qtemp.allcusts (Select Cust# as Customer_nbr from File01 where
FieldB = 'SOMEVALUE') With data I get the error Token CUSTOMER_NBR was
not valid. Valid tokens: ( ROW IDENTITY TRANS And the cursor is under
the C of Customer_nbr
Anyone any idea what I am doing wrong?
I could be incorrect, but I don't think it is supported to rename
the columns of a subquery from within the subquery itself.
Sincerely,
Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300
Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331
****************************************************************************
*****************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or proprietary
information. If you have received this message in error, please immediately
notify the sender and delete and destroy the message and all copies. All
unauthorized direct or indirect use or disclosure of this message is
strictly prohibited. No right to confidentiality or privilege is waived or
lost by any error in transmission.
****************************************************************************
*****************
------------------------------
message: 5
date: Wed, 26 Sep 2018 12:43:07 -0400
from: "Art Tostaine, Jr." <atostaine@xxxxxxxxx>
subject: Overlay rotation problems
I am creating an overlay from an image that was provided by a customer.
The image canvas size is 8.35 X 7" I am using 8 1/2 x 14 page size, and am
placing the overlay offset at 7" down.
When I print the overlay to the AFP driver and try to print it on my page,
it's rotated 90 degrees. I'm not using any page rotation on the spool file.
I do this all the time but I'm stumped. Any ideas? Thanks
--
Art Tostaine
------------------------------
message: 6
date: Wed, 26 Sep 2018 13:55:42 -0300
from: Roberto Jos? Etcheverry Romero <yggdrasil.raiker@xxxxxxxxx>
subject: Re: P9 config questions
Diego, I've tried to have VIOS as a guest for vscsi and it's never worked,
the GUI doesn't let you set VIOS as a vscsi client, only server. Maybe the
enhanced gui does? I haven't tried it again.
Jim, the problem lies in that the network install is really a NIM install,
that uses an ethernet adapter local to the LPAR an therefore doesn't go over
the FSP link between HMC and POWER machine.
Best Regards,
Roberto
On Wed, Sep 26, 2018 at 1:06 PM, Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:
This is completely different than StorWise. If you follow IBM
instructions in building the USB device, it works well.
How can a network issue come into play when the HMC has a solid
Ethernet cable from the HMC port to the HMC? Now if you are running
that connection over a LAN and it's not in its own completely
different network than any other traffic, then we have some other
items to discuss regarding security and a host of other things.
--
Jim Oberholtzer
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Diego E. KESSELMAN
Sent: Wednesday, September 26, 2018 10:27 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: P9 config questions
You can install 1 VIOS from HMC (image repository), and then create
the other as gest to the 1st VIOS, but you must be quite sure this works.
Any small network issue and you are in big trouble.
With a DVD drive you can ask your H&E to insert the media and that's it.
Haven't tried with USB thumb drive, but I don't feel comfortable using
them.
I still remember first Storwize with SPECIAL usb pen drives, and HMCs
with STEC pen drives...
Regards
Diego E. KESSELMAN
On 26/09/2018 06:17, Rob Berendt wrote:
Roberto,
If they outsource recovery, upgrades, etc, that's one thing. But if
you're visiting COMMON US and they have a disaster and need to do a
bare metal restore they may wish they had a DVD on site. But
perhaps your firm has staff to cover...
Rob Berendt
--
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
--
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
------------------------------
Subject: Digest Footer
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest 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
------------------------------
End of MIDRANGE-L Digest, Vol 17, Issue 1763
********************************************
--
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
midrange.com
