Re: Convert 3490E Tapes to CD or DVD
In [EMAIL PROTECTED], on 03/24/2006 at 07:31 PM, Eric N. Bielefeld [EMAIL PROTECTED] said: We won't have a mainframe, or the 3490E tape drives we now have to read our data. Convert the tapes to AWS and store on CD or DVD. -- Shmuel (Seymour J.) Metz, SysProg and JOAT ISO position; see http://patriot.net/~shmuel/resume/brief.html We don't care. We don't have to care, we're Congress. (S877: The Shut up and Eat Your spam act of 2003) -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Field level security (was RE: Convert 3490E Tapes to CD or DVD
ADABAS does field level security, and has for years. But it is overhead. Later, Ray -- M. Ray Mullins Roseville, CA, USA http://www.catherdersoftware.com/ http://www.mrmullins.big-bear-city.ca.us/ http://www.the-bus-stops-here.org/ German is essentially a form of assembly language consisting entirely of far calls heavily accented with throaty guttural sounds. --ilvi -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Ed Gould Sent: Friday 24 March 2006 17:06 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD On Mar 24, 2006, at 4:26 PM, Eric Bielefeld wrote: I have not heard of any MF application that does field level security except for possibly DB2. This is not to say their isn't just that it is unusual, IMO. There may be some user code in CICS that selectively displays a field (or not) but that seems to be a transaction type security . There are just too many ways you can access a file that is one of the reasons why people need RACF (or other security package). -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
Eric, If you go for CD's/DVD's you better prepare yourself for long time conservation. I read a (German?) article last week or so about an investigation on the lifetime of CDs and DVDs. It seems to be even worse than rumours had it already, some lasted only a few years. You should ask guarantees from the company that produces your CDS/DVDs and plan for regular copyoperations for safety. Kees. Eric N. Bielefeld [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Don, I know that I have searched previously for companies to do this, but I didn't find anywhere near as many hits as I got when I entered your search arguments. Thanks - those are a lot better than the search arguments I used previously. I was hoping for someone who had already done this, and had companies that they would recommend. I'll definetly check this out some of these companies on Monday when I get back to work. Eric Bielefeld PH Mining Equipment - Original Message - From: Imbriale, Don [EMAIL PROTECTED] Newsgroups: bit.listserv.ibm-main To: IBM-MAIN@BAMA.UA.EDU Sent: Friday, March 24, 2006 4:49 PM Subject: Re: Convert 3490E Tapes to CD or DVD A search via Google for convert 3490e tape to cd yields thousands of hits. On the first page of 20 hits, there are at least a half a dozen companies that provide the service you are looking for. Even to the point of converting binary and packed decimal fields as needed. Note however that these do not seem to be inexpensive services. Don Imbriale On Fri, 24 Mar 2006 14:16:16 -0600, Eric Bielefeld Eric- [EMAIL PROTECTED] wrote: Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. All of our tapes are currently 3490-E model tapes. We are looking for a company who can read the data on a 3490E drive and convert it to ASCII and write it on a DVD or CD, or just FTP it to us. This would be on an as needed basis, and may or may not be a lot of data. You can reply to me or the group, or call me. Thanks, Eric Bielefeld Sr. Systems Programmer PH Mining Equipment 414-671-7849 Milwaukee, Wisconsin -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. ** -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
On Fri, 24 Mar 2006 14:16:16 -0600, Eric Bielefeld Eric- [EMAIL PROTECTED] wrote: Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. Eric, Check out the documentation (File 001) on the CBT tape. There are several programs that will convert a tape to AWS format files. You yourself can create these files and simply write them to CD or DVD or any other medium after transferring them to a PC. AWS is a standard format that is handled by Flex-ES, P/390 and Hercules. You could legally have a Hercules system running MVS 3.8 that you can use to access the data on these tapes, if only just to read and print it. DC -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Convert 3490E Tapes to CD or DVD
Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. All of our tapes are currently 3490-E model tapes. We are looking for a company who can read the data on a 3490E drive and convert it to ASCII and write it on a DVD or CD, or just FTP it to us. This would be on an as needed basis, and may or may not be a lot of data. You can reply to me or the group, or call me. Thanks, Eric Bielefeld Sr. Systems Programmer PH Mining Equipment 414-671-7849 Milwaukee, Wisconsin -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
-Original Message- From: IBM Mainframe Discussion List On Behalf Of Eric Bielefeld Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. All of our tapes are currently 3490-E model tapes. We are looking for a company who can read the data on a 3490E drive and convert it to ASCII and write it on a DVD or CD, or just FTP it to us. This would be on an as needed basis, and may or may not be a lot of data. You can reply to me or the group, or call me. Is there too much data to just FTP it to an ASCII host in-house, then save it whereever? -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
What will FTP do to any packed data in the datasets? -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Chase, John Sent: Friday, March 24, 2006 2:25 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD -Original Message- From: IBM Mainframe Discussion List On Behalf Of Eric Bielefeld Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. All of our tapes are currently 3490-E model tapes. We are looking for a company who can read the data on a 3490E drive and convert it to ASCII and write it on a DVD or CD, or just FTP it to us. This would be on an as needed basis, and may or may not be a lot of data. You can reply to me or the group, or call me. Is there too much data to just FTP it to an ASCII host in-house, then save it whereever? -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
-Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Eric Bielefeld Sent: Friday, March 24, 2006 2:16 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Convert 3490E Tapes to CD or DVD Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. All of our tapes are currently 3490-E model tapes. We are looking for a company who can read the data on a 3490E drive and convert it to ASCII and write it on a DVD or CD, or just FTP it to us. This would be on an as needed basis, and may or may not be a lot of data. You can reply to me or the group, or call me. Thanks, Eric Bielefeld Sr. Systems Programmer Eric, If it were my company, I would suggest buying a SCSI attached 3490E drive. You could then read the data yourself on almost any UNIX or PC system. No, I don't know the cost. As an aside, we addressed this possibility by getting an IBM TotalStorage tape subsystem with 3592J drives. Both the zSeries and distributed people use the same media. -- John McKown Senior Systems Programmer UICI Insurance Center Information Technology This message (including any attachments) contains confidential information intended for a specific individual and purpose, and its content is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this transmission, or taking any action based on it, is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
-Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Pommier, Rex R. Sent: Friday, March 24, 2006 2:29 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD What will FTP do to any packed data in the datasets? BINARY is a define required for Packed Decimal. Otherwise results are unpredictable when the data is used on the insert system here system. The same is true in the unlikely possibility of any floating point data (HFP or BFP, tho BFP would be easier to use.) -- John McKown Senior Systems Programmer UICI Insurance Center Information Technology This message (including any attachments) contains confidential information intended for a specific individual and purpose, and its content is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this transmission, or taking any action based on it, is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
Data could probably be FTP'd to us, depending on the sensitivity of the data. I have no idea how often we would need tapes converted. It might be 2 tapes over the next 5 years, no tapes, or 200 tapes. We have about 18,000 tapes in our tape library, however lots of them are scratch, test data, etc. I know I researched this before, and found a company that would sell us a 3490 E model desktop sized drive, and some software that you could program to convert all of the packed and binary fields to something that a PC or Unix box could read. I think that the whole package of tape drive and software was around $10,000. Personally, I think that would be the best bet, but I'm not sure they want to spend that much for something that might never be used. Eric Bielefeld Sr. Systems Programmer PH Mining Equipment 414-671-7849 Milwaukee, Wisconsin - Original Message - From: Chase, John [EMAIL PROTECTED] Date: Friday, March 24, 2006 2:24 pm Subject: Re: Convert 3490E Tapes to CD or DVD To: IBM-MAIN@BAMA.UA.EDU -Original Message- From: IBM Mainframe Discussion List On Behalf Of Eric Bielefeld Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. All of our tapes are currently 3490-E model tapes. We are looking for a company who can read the data on a 3490E drive and convert it to ASCII and write it on a DVD or CD, or just FTP it to us. This would be on an as needed basis, and may or may not be a lot of data. You can reply to me or the group, or call me. Is there too much data to just FTP it to an ASCII host in-house, then save it whereever? -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
-Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex R. What will FTP do to any packed data in the datasets? Standard answer: It depends. 1. If transferred as a plain ASCII transfer, packed decimal fields will get corrupted. 2. If transferred as a binary transfer, packed decimal fields are preserved (indeed, the whole file remains EBCDIC). Given Eric's description of the nature of the data, I'd probably do a binary transfer and worry about translating it to ASCII (with packed-decimal preservation/translation) when retrieving it on the ASCII machine. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
That was the point I was inferring, that Eric asked for something that would convert to ASCII. Such a conversion via FTP would corrupt the binary data. Not converting it would preserve the binary/packed decimal but wouldn't accomplish the ASCII conversion. Eric's post stating the possibility of getting a SCSI-attached 3490 tape and doing it in-house looks to me like the best solution because they would have access (hopefully) to the record layouts and so be able to preserve the data without corruption. Another option would be just hoping you don't need any of this data, and if so, find a service bureau (or a friendly z-based shop) that would contract to migrate data on an as-needed basis. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Chase, John Sent: Friday, March 24, 2006 2:36 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex R. What will FTP do to any packed data in the datasets? Standard answer: It depends. 1. If transferred as a plain ASCII transfer, packed decimal fields will get corrupted. 2. If transferred as a binary transfer, packed decimal fields are preserved (indeed, the whole file remains EBCDIC). Given Eric's description of the nature of the data, I'd probably do a binary transfer and worry about translating it to ASCII (with packed-decimal preservation/translation) when retrieving it on the ASCII machine. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
Rex and John, I thought of that fact, that packed data wouldn't get translated correctly. That's why I think the best solution would be to buy the tape drive and software, which would handle all of the data conversions. I guess I won't have to worry about it though. Eric Bielefeld Sr. Systems Programmer PH Mining Equipment 414-671-7849 Milwaukee, Wisconsin - Original Message - From: Pommier, Rex R. [EMAIL PROTECTED] Date: Friday, March 24, 2006 2:46 pm Subject: Re: Convert 3490E Tapes to CD or DVD To: IBM-MAIN@BAMA.UA.EDU That was the point I was inferring, that Eric asked for something that would convert to ASCII. Such a conversion via FTP would corrupt the binary data. Not converting it would preserve the binary/packed decimalbut wouldn't accomplish the ASCII conversion. Eric's post stating the possibility of getting a SCSI-attached 3490 tape and doing it in-house looks to me like the best solution because they would have access (hopefully) to the record layouts and so be able to preserve the data without corruption. Another option would be just hoping you don't need any of this data, and if so, find a service bureau (or a friendly z-based shop) that would contract to migrate data on an as-needed basis. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Chase, John Sent: Friday, March 24, 2006 2:36 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex R. What will FTP do to any packed data in the datasets? Standard answer: It depends. 1. If transferred as a plain ASCII transfer, packed decimal fields will get corrupted. 2. If transferred as a binary transfer, packed decimal fields are preserved (indeed, the whole file remains EBCDIC). Given Eric's description of the nature of the data, I'd probably do a binary transfer and worry about translating it to ASCII (with packed-decimal preservation/translation) when retrieving it on the ASCIImachine. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
-Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Eric Bielefeld Sent: Friday, March 24, 2006 2:52 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD Rex and John, I thought of that fact, that packed data wouldn't get translated correctly. That's why I think the best solution would be to buy the tape drive and software, which would handle all of the data conversions. I guess I won't have to worry about it though. Eric Bielefeld That was the attitude that I was getting last year, when there was a large push by the ex-CIO to convert all the zSeries applications to Windows via automated code conversion techniques. I knew if that happened, I would be gone and it would not be my problem. But I had plans to keep in contact with some people I know in the NOC. Assuming that they were not too afraid to talk, I expected to get a lot of good belly laughs. The new CIO appears to be platform agnostic. The biggest thing in his basket is to convert from in house written applications to C.O.T.S. (Commercial Off The Shelf) software. -- John McKown Senior Systems Programmer UICI Insurance Center Information Technology This message (including any attachments) contains confidential information intended for a specific individual and purpose, and its content is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this transmission, or taking any action based on it, is strictly prohibited. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
RES: Convert 3490E Tapes to CD or DVD
I did something similar in past using TCPIP Tools from Barnard Software to read 3490 tape cartridge and write down contents directly to xSeries hard disk. Then burn a data cd using Nero. I tested process inverted (read cd to hard disk, then read xSeries hard disk using Barnard Software to a 3490 tape cartridge and no problems arises. Since BSI software (www.bsiopti.com) uses some kind of compression, data in HD and CD is encrypted. -Mensagem original- De: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Em nome de Pommier, Rex R. Enviada em: sexta-feira, 24 de março de 2006 17:46 Para: IBM-MAIN@BAMA.UA.EDU Assunto: Re: Convert 3490E Tapes to CD or DVD That was the point I was inferring, that Eric asked for something that would convert to ASCII. Such a conversion via FTP would corrupt the binary data. Not converting it would preserve the binary/packed decimal but wouldn't accomplish the ASCII conversion. Eric's post stating the possibility of getting a SCSI-attached 3490 tape and doing it in-house looks to me like the best solution because they would have access (hopefully) to the record layouts and so be able to preserve the data without corruption. Another option would be just hoping you don't need any of this data, and if so, find a service bureau (or a friendly z-based shop) that would contract to migrate data on an as-needed basis. Rex -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Chase, John Sent: Friday, March 24, 2006 2:36 PM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD -Original Message- From: IBM Mainframe Discussion List On Behalf Of Pommier, Rex R. What will FTP do to any packed data in the datasets? Standard answer: It depends. 1. If transferred as a plain ASCII transfer, packed decimal fields will get corrupted. 2. If transferred as a binary transfer, packed decimal fields are preserved (indeed, the whole file remains EBCDIC). Given Eric's description of the nature of the data, I'd probably do a binary transfer and worry about translating it to ASCII (with packed-decimal preservation/translation) when retrieving it on the ASCII machine. -jc- -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: RES: Convert 3490E Tapes to CD or DVD
In a message dated 3/24/2006 3:14:25 P.M. Central Standard Time, [EMAIL PROTECTED] writes: read 3490 tape cartridge and write down contents directly to xSeries hard disk. Then burn a data cd using Nero. Didn't it get monotonous after the first few 100? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
You might be able to use SOX and auditor requirements to convince them that would be $10K well invested . Sometimes demonstrating that having the capability just in case is good enough to warrant the expenditure. Later, Ray -- M. Ray Mullins Roseville, CA, USA http://www.catherdersoftware.com/ http://www.mrmullins.big-bear-city.ca.us/ http://www.the-bus-stops-here.org/ German is essentially a form of assembly language consisting entirely of far calls heavily accented with throaty guttural sounds. --ilvi -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Eric Bielefeld Sent: Friday 24 March 2006 12:33 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD Data could probably be FTP'd to us, depending on the sensitivity of the data. I have no idea how often we would need tapes converted. It might be 2 tapes over the next 5 years, no tapes, or 200 tapes. We have about 18,000 tapes in our tape library, however lots of them are scratch, test data, etc. I know I researched this before, and found a company that would sell us a 3490 E model desktop sized drive, and some software that you could program to convert all of the packed and binary fields to something that a PC or Unix box could read. I think that the whole package of tape drive and software was around $10,000. Personally, I think that would be the best bet, but I'm not sure they want to spend that much for something that might never be used. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
Something else to think about...binary fields. Coincidentally, on the Software AG NATURAL discussion board, there's been a topic about migrating from BS2000/OSD to Unix and the various things to watch out for. One thing that came up was endian-ness. Depending on the software, it's possible that a fullword that is written on an IBM-compatible mainframe as X'12345678' would be written on an Intel x86 box as X'78563412' or, if written as 2 halfwords, X'34127856' (middle-endian). And you can have problems between *n*x boxen, as Sun's hardware is big-endian. (Not sure what the PowerPC is, but I think it's big-endian, too.) (Non-mainframe NATURAL has an ENDIAN parameter to tweak this behavior.) Later, Ray -- M. Ray Mullins Roseville, CA, USA http://www.catherdersoftware.com/ http://www.mrmullins.big-bear-city.ca.us/ http://www.the-bus-stops-here.org/ German is essentially a form of assembly language consisting entirely of far calls heavily accented with throaty guttural sounds. --ilvi -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Eric Bielefeld Sent: Friday 24 March 2006 12:52 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Convert 3490E Tapes to CD or DVD Rex and John, I thought of that fact, that packed data wouldn't get translated correctly. That's why I think the best solution would be to buy the tape drive and software, which would handle all of the data conversions. I guess I won't have to worry about it though. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
I'm pretty sure we don't encrypt any data. Much of our backups are compressed, and done with vendor products, however, I don't think that matters, as all of the data in all of the IMS and VSAM files has been converted. I think that only sequential disk or tape data would need to be converted. So far, no one has givin me any companies that do this sort of thing. Does anyone know of any? Of course, most of you hopefully have never had to deal with this sort of thing. Eric Bielefeld Sr. Systems Programmer PH Mining Equipment 414-671-7849 Milwaukee, Wisconsin - Original Message - From: Porowski, Ken [EMAIL PROTECTED] Date: Friday, March 24, 2006 3:39 pm Subject: Re: Convert 3490E Tapes to CD or DVD To: IBM-MAIN@BAMA.UA.EDU As others have mentioned, packed and binary fields could be fun. Also consider if you plan to replicate any encrypted data or data in a proprietary vendor format that may not be readable without the vendor package. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
In batch, you could: 1. Use DFSORT/ICETOOL to read the files, convert binary/packed fields to human-readable (don't forget the sign!), and write it to a temporary file which is passed to part 2 2. Use FTP with PUT '//DD:ddname' somefilename to write the temporary file to some FTP server. EBCDIC = ASCII will happen automagically. Depending upon how much space the file server has, you could potentially transfer all of the critical tape files first, and then burn CDs afterward. I'd use CA-1 or whatever tape management system you have, with some reporting tool to determine the sizes of the files to be moved, and also to weed out the ones which haven't been used in a long long time = we use SAS with the output of CA-1's TMSDATA utility for this kind of thing, but you can user other stuff. You may find that you have a lot of very small files, and in fact may be able to fit a lot of them on one CD. Another alternative would be to write the output of step 1 to USS diretories, then do an FTP 'Get' from them to the PC with the CD burner, but I assume management wouldn't want to allocate permanent space for the project? Tim Hare Senior Systems Programmer Florida Department of Transportation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
A search via Google for convert 3490e tape to cd yields thousands of hits. On the first page of 20 hits, there are at least a half a dozen companies that provide the service you are looking for. Even to the point of converting binary and packed decimal fields as needed. Note however that these do not seem to be inexpensive services. Don Imbriale On Fri, 24 Mar 2006 14:16:16 -0600, Eric Bielefeld Eric- [EMAIL PROTECTED] wrote: Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. All of our tapes are currently 3490-E model tapes. We are looking for a company who can read the data on a 3490E drive and convert it to ASCII and write it on a DVD or CD, or just FTP it to us. This would be on an as needed basis, and may or may not be a lot of data. You can reply to me or the group, or call me. Thanks, Eric Bielefeld Sr. Systems Programmer PH Mining Equipment 414-671-7849 Milwaukee, Wisconsin -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
In a message dated 3/24/2006 4:27:12 P.M. Central Standard Time, [EMAIL PROTECTED] writes: So far, no one has givin me any companies that do this sort of thing. Does anyone know of any? Of course, most of you hopefully have never had to deal with this sort of thing. The banks use FILETEK there's others. You might could do it on the cheap with used or short term lease. Maybe $250k would get you started. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
On Mar 24, 2006, at 4:26 PM, Eric Bielefeld wrote: I'm pretty sure we don't encrypt any data. Much of our backups are compressed, and done with vendor products, however, I don't think that matters, as all of the data in all of the IMS and VSAM files has been converted. I think that only sequential disk or tape data would need to be converted. So far, no one has givin me any companies that do this sort of thing. Does anyone know of any? Of course, most of you hopefully have never had to deal with this sort of thing. Eric, I have not heard of any MF application that does field level security except for possibly DB2. This is not to say their isn't just that it is unusual, IMO. There may be some user code in CICS that selectively displays a field (or not) but that seems to be a transaction type security . There are just too many ways you can access a file that is one of the reasons why people need RACF (or other security package). Way back in the early 70's I had to have a top secret clearance from the Army so I could help programmers debug their code. One of the dumps I had to look at had the number of toilet paper rolls that was in stock. I asked the programmer why that was top secret and he said the SOviets could figure out how many people the US had in Germany. I suggested to go through parking lots and count the green plates and you would have a better idea. There were other nonsensical issues, but you get the idea. Ed -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
Tim, I think you missed the start of this thread. Our mainframe and our entire Milwaukee datacenter is going away at the end of April. I am looking for a way to potentially convert tapes to a CD offsite - a business that would do that for us. Everything that we think we need we will convert ahead of time, but converting all tapes before we get rid of the mainframe would be very expensive, since we may need nothing, or just 1 or 2 tapes. We won't have a mainframe, or the 3490E tape drives we now have to read our data. Eric Bielefeld PH Mining Equipment - Original Message - From: Tim Hare [EMAIL PROTECTED] Newsgroups: bit.listserv.ibm-main To: IBM-MAIN@BAMA.UA.EDU Sent: Friday, March 24, 2006 4:32 PM Subject: Re: Convert 3490E Tapes to CD or DVD In batch, you could: 1. Use DFSORT/ICETOOL to read the files, convert binary/packed fields to human-readable (don't forget the sign!), and write it to a temporary file which is passed to part 2 2. Use FTP with PUT '//DD:ddname' somefilename to write the temporary file to some FTP server. EBCDIC = ASCII will happen automagically. Depending upon how much space the file server has, you could potentially transfer all of the critical tape files first, and then burn CDs afterward. I'd use CA-1 or whatever tape management system you have, with some reporting tool to determine the sizes of the files to be moved, and also to weed out the ones which haven't been used in a long long time = we use SAS with the output of CA-1's TMSDATA utility for this kind of thing, but you can user other stuff. You may find that you have a lot of very small files, and in fact may be able to fit a lot of them on one CD. Another alternative would be to write the output of step 1 to USS diretories, then do an FTP 'Get' from them to the PC with the CD burner, but I assume management wouldn't want to allocate permanent space for the project? Tim Hare Senior Systems Programmer Florida Department of Transportation -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
Don, I know that I have searched previously for companies to do this, but I didn't find anywhere near as many hits as I got when I entered your search arguments. Thanks - those are a lot better than the search arguments I used previously. I was hoping for someone who had already done this, and had companies that they would recommend. I'll definetly check this out some of these companies on Monday when I get back to work. Eric Bielefeld PH Mining Equipment - Original Message - From: Imbriale, Don [EMAIL PROTECTED] Newsgroups: bit.listserv.ibm-main To: IBM-MAIN@BAMA.UA.EDU Sent: Friday, March 24, 2006 4:49 PM Subject: Re: Convert 3490E Tapes to CD or DVD A search via Google for convert 3490e tape to cd yields thousands of hits. On the first page of 20 hits, there are at least a half a dozen companies that provide the service you are looking for. Even to the point of converting binary and packed decimal fields as needed. Note however that these do not seem to be inexpensive services. Don Imbriale On Fri, 24 Mar 2006 14:16:16 -0600, Eric Bielefeld Eric- [EMAIL PROTECTED] wrote: Does anyone know of any companies that can convert mainframe tapes to DVDs or CDs? As many of you know, our mainframe is going out the door at the end of April. All of the historical data and otherwise tape data will then in essence be unreadable by us. All of our tapes are currently 3490-E model tapes. We are looking for a company who can read the data on a 3490E drive and convert it to ASCII and write it on a DVD or CD, or just FTP it to us. This would be on an as needed basis, and may or may not be a lot of data. You can reply to me or the group, or call me. Thanks, Eric Bielefeld Sr. Systems Programmer PH Mining Equipment 414-671-7849 Milwaukee, Wisconsin -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
Ed, I'll look up FILETEK on Monday. $250,000 is not cheap though. Like I said in an earlier post, we can buy a desktop 3490E drive, software, and a connector to a PC for about $10,000. When I told our management about that, they thought it was too expensive. Eric Bielefeld PH Mining Equipment - Original Message - From: Ed Finnell [EMAIL PROTECTED] Newsgroups: bit.listserv.ibm-main To: IBM-MAIN@BAMA.UA.EDU Sent: Friday, March 24, 2006 4:57 PM Subject: Re: Convert 3490E Tapes to CD or DVD In a message dated 3/24/2006 4:27:12 P.M. Central Standard Time, [EMAIL PROTECTED] writes: So far, no one has givin me any companies that do this sort of thing. Does anyone know of any? Of course, most of you hopefully have never had to deal with this sort of thing. The banks use FILETEK there's others. You might could do it on the cheap with used or short term lease. Maybe $250k would get you started. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Convert 3490E Tapes to CD or DVD
In a message dated 3/24/2006 8:11:03 P.M. Central Standard Time, [EMAIL PROTECTED] writes: I'll look up FILETEK on Monday. $250,000 is not cheap though. Like I said in an earlier post, we can buy a desktop 3490E drive, software, and a connector to a PC for about $10,000. When I told our management about that, they thought it was too expensive. Yeah, one of those things. May not ever need one but what's the consequence of losing one? Lawsuit, SOX, regulators, stock holder's inquest. The current Naspa has a niece article on Datastage TX that could come in useful on a running system. I'm trying to envision what we're trying to save/copy. If it's program level data with Packed decimal and Floating point it's gonna have to be converted by something or someone. You'll have to know the format of every record of every file. Guess another option would be a FLEX-ES system in the closet with a dongle and a tape drive. Who would know? Think last time I looked _www.filenet.com_ (http://www.filenet.com) went with FILETEK but haven't kept up. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html