-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
midrange-l-request@xxxxxxxxxxxx
Sent: Monday, October 29, 2007 4:37 PM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 6, Issue 2194

Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more
specific than "Re: Contents of MIDRANGE-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove
all text unrelated to your reply and change the subject line
so it is meaningful.

Today's Topics:

1. Re: SAVLIB tape copy and/or converting tape backup to SAVF
(rob@xxxxxxxxx)
2. Re: Virtual Tape (rob@xxxxxxxxx)
3. RE: Virtual Tape (Bruce Barrett)
4. RE: Virtual Tape (Bruce Barrett)
5. Re: SAVLIB tape copy and/or converting tape backup to SAVF
(CRPence)
6. Re: SAVLIB tape copy and/or converting tape backup to SAVF
(Dave McKenzie)
7. Can UPDATE statement do something like this... (Dave Odom)


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

message: 1
date: Mon, 29 Oct 2007 17:12:16 -0400
from: rob@xxxxxxxxx
subject: Re: SAVLIB tape copy and/or converting tape backup to SAVF

David,

It's not the Nova Exchange. It's never a save file on the
tape. If you do a SAVLIB to tape then you have to do a
RSTLIB to get it back from the tape. Unless, you did a
SAVLIB, and one of those things in the library was a save
file. Then what you might be trying to do is a RSTOBJ of
just that save file saved with SAVLIB.

What error are you getting with RSTLIB and/or RSTOBJ?

I do not think that you can do a CPYFRMTAP from a tape file
to an existing save file unless that save file was copied to
the tape with CPYTOTAP, or your pretty talented and figured
out how to use RPG or something to read objects and write it
to tape in the same byte structure as a save file.
But in general, the format of a file on tape created with
SAVLIB is not going to match the format of a save file.

If it is that mangled and is that vital, you could try either
reading the file directly from a HLL like RPG or try various
incantations of CPYFRMTAP to some sort of file layout. Then
read that file with some HLL and write out to the object you desire.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"David C. Shea" <dshea@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/29/2007 03:54 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
SAVLIB tape copy and/or converting tape backup to SAVF






A friend of mine has a savlib backup tape that he converted
from one media
type to SLR5 using a PC tape copying gizmo called
NovaExchange. I can see
that the library is there, but something is different about
the tape such
that the AS400 doesn't think it's a save file.

I have tried a few things like doing a CPYFRMTAP as a tape
file to see if
I could mangle the thing into a SAVF. I can DSPPFM the
copied file and
see things that LOOK like a savf might, but no dice.

The tape is ebcdic. The block size is 32768. The record
length of the
converted tape is not 0 as it should be, but 32768.

A 'save file' has a record length of 528...

I'm just scratching the surface here. Has anyone ever
offloaded a savlib
backup and mangled it into a save file?



****************************************************
Go...FASTER! Without an Upgrade!
ARCTOOLS/400(tm) and ReorgWizard(tm)
www.arctools.com
DCSoftware,Inc.
Ph: 508.435.8243 x200
Fax:508.435.4498
Current versions: ARCTOOLS v7.1.1, ReorgWizard v3.1.5, JDE
Module v3, BPCS
Module v1
*****************************************************


--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




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

message: 2
date: Mon, 29 Oct 2007 17:15:18 -0400
from: rob@xxxxxxxxx
subject: Re: Virtual Tape

Having used virtual optical I didn't find virtual tape all that hard.
We've got some pretty kicking tape drives so virtual tape was
actually
slower for us.

Not sure if you can use a SAN. Shouldn't be that hard to try
though. Try
mounting an IFS directory to that SAN and then configuring
that directory
to the virtual tape.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Al Barsa <barsa@xxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/29/2007 05:05 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: Virtual Tape







Virtual tape is a bitch to learn, and it may or may not improve
performance. (Likely it will if going to an inactive IASP.)

The is a TAA Tool.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com




"Bruce Barrett"
<bruce.barrett@pm
igroup.com>
To

Sent by: "Midrange Systems Technical
midrange-l-bounce Discussion"
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>

cc


10/29/2007 04:57
Subject

PM Virtual Tape


Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






Has anyone started using this alternative? I have a few
questions about
the amount of storage this takes up, can the files be sent to a SAN?


Bruce Barrett
PMI Mortgage Insurance Co.
3003 Oak Road
Walnut Creek, CA 94597
925-658-6152
510-520-4263 Cell
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.


--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




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

message: 3
date: Mon, 29 Oct 2007 14:15:38 -0700
from: "Bruce Barrett" <bruce.barrett@xxxxxxxxxxxx>
subject: RE: Virtual Tape

I will check out TAA Tool.

Bruce Barrett
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Al Barsa
Sent: Monday, October 29, 2007 2:04 PM
To: Midrange Systems Technical Discussion
Subject: Re: Virtual Tape


Virtual tape is a bitch to learn, and it may or may not improve
performance. (Likely it will if going to an inactive IASP.)

The is a TAA Tool.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com





"Bruce Barrett"

<bruce.barrett@pm

igroup.com>
To
Sent by: "Midrange Systems Technical

midrange-l-bounce Discussion"

s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>


cc


10/29/2007 04:57
Subject
PM Virtual Tape





Please respond to

Midrange Systems

Technical

Discussion

<midrange-l@midra

nge.com>









Has anyone started using this alternative? I have a few
questions about
the amount of storage this takes up, can the files be sent to a SAN?


Bruce Barrett
PMI Mortgage Insurance Co.
3003 Oak Road
Walnut Creek, CA 94597
925-658-6152
510-520-4263 Cell
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.


--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




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

message: 4
date: Mon, 29 Oct 2007 14:19:00 -0700
from: "Bruce Barrett" <bruce.barrett@xxxxxxxxxxxx>
subject: RE: Virtual Tape

Thanks for the information.

Bruce Barrett
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, October 29, 2007 2:15 PM
To: Midrange Systems Technical Discussion
Subject: Re: Virtual Tape

Having used virtual optical I didn't find virtual tape all that hard.
We've got some pretty kicking tape drives so virtual tape was
actually
slower for us.

Not sure if you can use a SAN. Shouldn't be that hard to try though.
Try
mounting an IFS directory to that SAN and then configuring that
directory
to the virtual tape.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Al Barsa <barsa@xxxxxxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/29/2007 05:05 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: Virtual Tape







Virtual tape is a bitch to learn, and it may or may not improve
performance. (Likely it will if going to an inactive IASP.)

The is a TAA Tool.

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com




"Bruce Barrett"
<bruce.barrett@pm
igroup.com>
To

Sent by: "Midrange Systems Technical
midrange-l-bounce Discussion"
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>

cc


10/29/2007 04:57
Subject

PM Virtual Tape


Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






Has anyone started using this alternative? I have a few
questions about
the amount of storage this takes up, can the files be sent to a SAN?


Bruce Barrett
PMI Mortgage Insurance Co.
3003 Oak Road
Walnut Creek, CA 94597
925-658-6152
510-520-4263 Cell
bruce.barrett@xxxxxxxxxxxx

This e-mail is confidential and may be privileged. If you are not the
intended recipient, please destroy this message and notify the sender.


--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




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

message: 5
date: Mon, 29 Oct 2007 16:57:09 -0500
from: CRPence <crp@xxxxxxxxxxxxxxxxxxxx>
subject: Re: SAVLIB tape copy and/or converting tape backup to SAVF

Apologies if this is already understood, such that maybe I have
misunderstood the given. But.... A copied tape [to new media] of a
SAVLIB will remain a SAVLIB. A SAVLIB standard label file is
restored
from tape by a request to RSTLIB; that *SL file is not a /save file/.
The ability to "see that the library is there" would seem to
suggest a
DSPTAP request showed the label as the library name.? The DSPTAP
information should also indicate the command that was used to
create the
file on the tape was a SAVLIB. Has the request to perform a RSTLIB
actually been attempted?

Perhaps my confusion is that the words "save file"
referred both to
the file on tape and a *FILE object with attribute SAVF.? If
so, then
presumably the error was that a RSTLIB request indicates that
the media
was not a valid save format, rather than having indicated
that the media
was not a /save file/. In this case the /file/ on the media,
with the
library name as the /label/ must be a standard label file
with its data
written in the *SAVRST format. If the copy of the tape to alternate
media had copied the data records and changed the [block
and/or] record
length, but not also having reformatted the records to match the new
length, or the file is no longer *SL, then I believe that
would result
in such an error.

Regards, Chuck
--
All comments provided "as is" with no warranties of any kind
whatsoever and may not represent positions, strategies, nor
views of my
employer

David C. Shea wrote:
A friend of mine has a savlib backup tape that he converted
from one media type to SLR5 using a PC tape copying gizmo
called NovaExchange. I can see that the library is there,
but something is different about the tape such that the AS400
doesn't think it's a save file.

I have tried a few things like doing a CPYFRMTAP as a tape
file to see if I could mangle the thing into a SAVF. I can
DSPPFM the copied file and see things that LOOK like a savf
might, but no dice.

The tape is ebcdic. The block size is 32768. The record
length of the converted tape is not 0 as it should be, but 32768.

A 'save file' has a record length of 528...

I'm just scratching the surface here. Has anyone ever
offloaded a savlib backup and mangled it into a save file?



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

message: 6
date: Mon, 29 Oct 2007 16:31:07 -0700
from: Dave McKenzie <davemck@xxxxxxxxxxxxx>
subject: Re: SAVLIB tape copy and/or converting tape backup to SAVF

It would be hard to mangle it into a savf, because savf's
have checksums
in each 528-byte record (512 bytes data, 4 byte binary RRN,
and 12 byte
checksum). There are no checksums on tape, so you'd have to calculate
them yourself--which is not impossible (a REXX pgm to do it was once
posted in the MI400 list) but it's not trivial.

I think it would be easier to get the file into a physical file in the
format used by the DUPTAPIN TAATOOL, then use the DUPTAPOUT
TAATOOL (or
equivalent) to write that to tape in legitimate *SAVRST format. Then
you could restore normally.

DUPTAPIN copies the tape file into a physical file with a 32,762-byte
record length, which has a 2-byte binary block length,
followed by up to
32,760 bytes of the tape block data. The original TAATOOLs used PL/I
pgms to read and write the tape, but there are RPG IV replacements for
them here: (thanks Martin!)

http://dbg400.net/download/duptap.txt

(For a chuckle, they're also here:)

http://www.splash.it/computer/as400/AS400/DUPTAP.txt.htm

A couple of questions:

1. How big is the file? If it's small enough to email, you
could email
it to me and I'll try to extract the library. Though if it contains
proprietary data, you might not want to send it to a stranger :-)

2. Can you post what you see when you do DSPPFM on the copied physical
file using F10=Hex? Just the first screen or two.

--Dave

David C. Shea wrote:
A friend of mine has a savlib backup tape that he converted
from one media type to SLR5 using a PC tape copying gizmo
called NovaExchange. I can see that the library is there,
but something is different about the tape such that the AS400
doesn't think it's a save file.

I have tried a few things like doing a CPYFRMTAP as a tape
file to see if I could mangle the thing into a SAVF. I can
DSPPFM the copied file and see things that LOOK like a savf
might, but no dice.

The tape is ebcdic. The block size is 32768. The record
length of the converted tape is not 0 as it should be, but 32768.

A 'save file' has a record length of 528...

I'm just scratching the surface here. Has anyone ever
offloaded a savlib backup and mangled it into a save file?



****************************************************
Go...FASTER! Without an Upgrade!
ARCTOOLS/400(tm) and ReorgWizard(tm)
www.arctools.com
DCSoftware,Inc.
Ph: 508.435.8243 x200
Fax:508.435.4498
Current versions: ARCTOOLS v7.1.1, ReorgWizard v3.1.5, JDE
Module v3, BPCS Module v1
*****************************************************








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

message: 7
date: Mon, 29 Oct 2007 16:38:13 -0700
from: "Dave Odom" <Dave.Odom@xxxxxxxxxxxx>
subject: Can UPDATE statement do something like this...

I'd like to use the UPDATE statement to update a specific
character in a character string of a column of a table.
Something like:

UPDATE dodom.table1 set SUBSTRING(column5, 5,1) = 'B'
where column2 = 'CP'

Of course the above bombs on the paren after SUBSTRING;
expects token like =

If not possible, I'll create a program using REXX and SQL.

Thanks in advance,

Dave O


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

--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



End of MIDRANGE-L Digest, Vol 6, Issue 2194
*******************************************




This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].