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
