RE: [U2] UV migration
I had to restore over 120 copies from AIX backups to a PC, to create an EOM zip file for archiving. I managed to connect the RS6000 20 GB dat tape unit directly to the PC using a SCSI interface card and a driver I found on the NET. IBM said it was not possible but it worked just fine, guess they meant they'd never done it before. Maybe not the answer for you if you are only doing this once from a machine. The reason I mention it is having snap shots from various points in history can be very handy, especially if there was a lot of housekeeping. Andy -Original Message- From: Wong, Howard [mailto:[EMAIL PROTECTED] Sent: 15 March 2005 18:01 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UV migration Robert, Yeah, I was looking for the free PE too. But how to get the data from the UNIX box to a PC? Does this goes back to the extract problem? Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 11:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV migration Hi, Me again... Another thought occurred to me. You were saying this wasn't getting used all that often anymore. I take it this is just more or less for reference from time to time. Would it be feasible to move the data to a PC? You'd have limited access to it. I know you mentioned they weren't likely to put money out to upgrade to a new version of UV. And with the costs of UV licenses, I can't say that I'd blame them. BUT, there is a UniVerse Personal Edition that may be the trick for you. It doesn't come with support, but you can find support other places (contractors, VARs, etc. - I actually do a little of that in the healthcare field where I came from on the side as time permits). The UV Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 simultaneous connections to it. Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ The PE version has been temporarily removed from the site, but it is possible to get a hold of them. I might still have a CD around, or may be able to get it. I'm dealing with UD more at the moment. Does this sound like something that may be of use? Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 9:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe plea
Re: [U2] UV migration
Sorry, I work for lawyers were "throw money at it" is S.O.P. Getting the data out of the old system and onto "brand X" database system does not require either a new UniVerse license or an install of PE. It would however go much easier with an install of a consultant type who could quickly show the folks what is in the system, where it's stored and the quickest and cheapest way to get it out of there. I guess the moral of this story is you ask a broad question, you get lots of broad answers. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV migration - Maybe [OT]
PE is **not** licensed for **ANY** commercial use, even temporary, stop-gap, limited, minor, etc. etc. etc. The only thing you can use PE for in a commercial environment is development (on the idea more seats will ultimately be sold) or Personal (again, prior logic, the more you know it, the more you love it)... Porting is not either of those things. And the license doesn't say 'or commercial purposes for 3 months or less' (I don't think!!) We're not being mean or trying to extract another dollar from anyone by stating the facts. IBM has their rules on how these things work. It's the agreement we all entered into when we accepted the license to use the database. This customer can use their current environment perpetually with no additional costs, ever, but it seems they need to move to another platform - and for that, there is a fee to be paid to someone - namely, IBM and the new hardware and O/S vendors! If they are just moving data, they could buy a ONE or TWO SEATS in the workgroup license for probably way under $1000 - it's not going to break their budget - heck, I bet it's less than the consultant will charge for doing the research! We have to be careful on the Personal Editions - they are not OURS to distribute (having a CD or copy of the download does NOT make you an Authorized Distribution Point!) or decide what they are 'supposed' to be used for. Those are legal issues covered in the User License. IBM decides what terms they want to offer - we don't. However, if we are not careful, PE versions may go away or become impossible to get without blood typing!! The most any of us can ever LEGALLY do is provide the URL to the PE versions (when they are back up and running!). I hope IBM makes gazillions of dollars off U2, because if they do, we'll make a LOT more! I don't think any of the policies or pricing I've seen thus far are that bad or unfair. This client has had years of use of the database for the one time, up front costs. It appears they are not under maintenance and have not kicked anything into the coffers for a while. And, IMHO, asking a customer, who after years of no maintenance needs to migrate to another platform, to cough up under $1k is not 'throwing money' at the issue. I suspect the data is worth a magintude more than IBM would ever ask them to pay! And that the consultant(s) involved will get far more than IBM will out of the deal. But the client gets the joy of continued access to the data - priceless. DW - snippage Come on people... I'm a software developer. I don't exactly go around suggesting people steal software. They need a temporary solution to get the data out. "Throw money at it" is rarely a good idea and for a temporary need almost never. Robert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV migration
Apparently I didn't get my point across as intended... BUT (and a big hairy one at that)... the OP has already stated: "Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc." Sounds to me like they've already made up their minds to convert away from UV. So where exactly is the problem? They have already said they want to extract the data. We aren't talking about running a production system on it. Maybe my mentioning that support is limited for PE caused this. I was simply pointing out there's another option, but that they would have limited resources, from IBM anyway, if they ran into problems. And let's see... (Pretending to be Mr IBM Lawyer) Hmm, here's a place that already owns a valid albeit older UV license, but wants to use our current UV PE to extract the data. They aren't running production on it, just working out how to extract the data. And they are even considering moving the data into OUR DB2 database... Do we sue them??? And if so, for what? Using a product we give away to extract data from one of our licensed databases, and perhaps move it into another one of our licensed databases? The only valid argument I saw against it so far is the comment about large datasets. And I did mention that briefly (too briefly apparently) with "Would it be feasible to move the data to a PC?" We don't know anything about this database in terms of size or much else for that matter. Only they can determine the answers to what is the appropriate route for them to take. They're looking for options. I gave them one. Come on people... I'm a software developer. I don't exactly go around suggesting people steal software. They need a temporary solution to get the data out. "Throw money at it" is rarely a good idea and for a temporary need almost never. Robert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV migration
Getting the data from unix to a pc running windows or linux can be done any number of ways. The basic receipe is copy, fnuxi, resize, recompile, run. You can use nfs, ftp, tape, rsync, samba shares, etc to get the data from one machine to another. The fnuxi part is a UniVerse command to convert the data format from one machine type and version to another. Using a 1-2 user developers license for UniVerse 10 and a pc running windows or linux would probably be the most cost effective solution if general lookup is all you want to do. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV migration
Robert, Yeah, I was looking for the free PE too. But how to get the data from the UNIX box to a PC? Does this goes back to the extract problem? Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 11:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV migration Hi, Me again... Another thought occurred to me. You were saying this wasn't getting used all that often anymore. I take it this is just more or less for reference from time to time. Would it be feasible to move the data to a PC? You'd have limited access to it. I know you mentioned they weren't likely to put money out to upgrade to a new version of UV. And with the costs of UV licenses, I can't say that I'd blame them. BUT, there is a UniVerse Personal Edition that may be the trick for you. It doesn't come with support, but you can find support other places (contractors, VARs, etc. - I actually do a little of that in the healthcare field where I came from on the side as time permits). The UV Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 simultaneous connections to it. Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ The PE version has been temporarily removed from the site, but it is possible to get a hold of them. I might still have a CD around, or may be able to get it. I'm dealing with UD more at the moment. Does this sound like something that may be of use? Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 9:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV migration
In addition to piqueing the interest of the IBM lawyers, using the PE addition in this manner may lead to an issue with large datasets. The PE edition just won't do large files. It's meant as a demo, tire kick tool. On Tue, 15 Mar 2005 11:35:34 -0500, Key Ally <[EMAIL PROTECTED]> wrote: > Robert, > PE is not for use in commercial ventures except for prototyping. > >- Chuck "We Abuse It, We'll Loose It" Barouch > > > [EMAIL PROTECTED] wrote: > > >Hi, > > > >Me again... Another thought occurred to me. You were saying this wasn't > >getting used all that often anymore. I take it this is just more or less > >for reference from time to time. Would it be feasible to move the data > >to a PC? You'd have limited access to it. I know you mentioned they > >weren't likely to put money out to upgrade to a new version of UV. And > >with the costs of UV licenses, I can't say that I'd blame them. BUT, > >there is a UniVerse Personal Edition that may be the trick for you. It > >doesn't come with support, but you can find support other places > >(contractors, VARs, etc. - I actually do a little of that in the > >healthcare field where I came from on the side as time permits). The UV > >Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 > >simultaneous connections to it. > > > >Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ > > > >The PE version has been temporarily removed from the site, but it is > >possible to get a hold of them. I might still have a CD around, or may > >be able to get it. I'm dealing with UD more at the moment. > >Does this sound like something that may be of use? > >Robert > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV migration
Robert, PE is not for use in commercial ventures except for prototyping. - Chuck "We Abuse It, We'll Loose It" Barouch [EMAIL PROTECTED] wrote: Hi, Me again... Another thought occurred to me. You were saying this wasn't getting used all that often anymore. I take it this is just more or less for reference from time to time. Would it be feasible to move the data to a PC? You'd have limited access to it. I know you mentioned they weren't likely to put money out to upgrade to a new version of UV. And with the costs of UV licenses, I can't say that I'd blame them. BUT, there is a UniVerse Personal Edition that may be the trick for you. It doesn't come with support, but you can find support other places (contractors, VARs, etc. - I actually do a little of that in the healthcare field where I came from on the side as time permits). The UV Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 simultaneous connections to it. Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ The PE version has been temporarily removed from the site, but it is possible to get a hold of them. I might still have a CD around, or may be able to get it. I'm dealing with UD more at the moment. Does this sound like something that may be of use? Robert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV migration
Hi, Me again... Another thought occurred to me. You were saying this wasn't getting used all that often anymore. I take it this is just more or less for reference from time to time. Would it be feasible to move the data to a PC? You'd have limited access to it. I know you mentioned they weren't likely to put money out to upgrade to a new version of UV. And with the costs of UV licenses, I can't say that I'd blame them. BUT, there is a UniVerse Personal Edition that may be the trick for you. It doesn't come with support, but you can find support other places (contractors, VARs, etc. - I actually do a little of that in the healthcare field where I came from on the side as time permits). The UV Personal Edition runs on a RedHat Linux and Windows. I think it allows 2 simultaneous connections to it. Link to IBM's UV site: http://www-306.ibm.com/software/data/u2/universe/ The PE version has been temporarily removed from the site, but it is possible to get a hold of them. I might still have a CD around, or may be able to get it. I'm dealing with UD more at the moment. Does this sound like something that may be of use? Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: Tuesday, March 15, 2005 9:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
