If you want to find out what release of uniVerse you are on and can get to the TCL level (the command level usually a > symbol) type in using all caps: ED VOC RELLEVEL then type in P with a return to print the lines you will something like the following, you type in Q to quit then release level is on the second line: >ED VOC RELLEVEL 5 lines long.
----: P 0001: X 0002: 9.6.2.3 0003: REALITY 0004: REALITY.FORMAT 0005: 9.6.2.3 Bottom at line 5. ----: Q Jerry ----- Original Message ----- From: "Wong, Howard" <[EMAIL PROTECTED]> To: <u2-users@listserver.u2ug.org>; <[EMAIL PROTECTED]> Sent: Tuesday, March 15, 2005 11:52 AM Subject: RE: [U2] RE: Andrew, Thanks for your suggestion. I'll forward it to the team for considering adding to the list of possible solutions. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -----Original Message----- From: Andrew Lakeland [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 12:03 PM To: u2-users@listserver.u2ug.org; '[EMAIL PROTECTED]' Subject: RE: [U2] RE: A few years back I did an archive system for someone, I restored their AIX database straight onto a PC from Tape and then saved the database onto DVD as a zip file. I did this for various end of months, they then unzipped which every file they needed back from the DVD to the hard disk and the system was back to which every point they needed. It was a lot cheaper than migrating and they simply have a 4 user license on a PC. Also remember which ever option you choose you will need to know the database. Migrating can be very labour intensive which would probably incur most costs. As you need to know the database which ever route you take, I'd suggest you document it and get someone to do your extractions when and IF you need them. You can also get someone to setup an ODBC link to your universe database so your could build your own reports from EXCEL, for example. Once the files are setup for access they are automatically flattened and appear in an MSquiry as list of files and fields. Regards Andy -----Original Message----- From: Wong, Howard [mailto:[EMAIL PROTECTED] Sent: 15 March 2005 17:09 To: '[EMAIL PROTECTED]'; u2-users@listserver.u2ug.org Subject: [U2] RE: Hi David, Your feed back is much appreciated. The old app was on an AIX box (v 4.3). We were migrating to AIX 5.0, but at the time it was suggested that the app could be migrated from AIX 4.3 to AIX 5.0. So a new app written in Progress replaced it. There was nothing wrong with the app. We do not know why newer version of UniVerse (if it was available) was not used for the migration instead. The AIX 4.3 box will be replaced either by a new AIX box or new Solaris box, the latter being our new institution-wide standard. The old app and DB was kept around because we still inquire on the older data from time to time. So we don't need full blown app development but just need to extract the data for inquiry purpose. BTW, we have no idea which version of UniVerse was used to develop the old app. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 15, 2005 10:27 AM To: u2-users@listserver.u2ug.org Cc: Wong, Howard Subject: RE: HW> Am I on the right track? Can someone tell me if: HW> 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? Yes .. back several years this was true HW> 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark HW> UniVerse DB? Yes .. this is also true HW> 3) If (2) is correct, then is there any tool or utilities that can either HW> (a) extract the structure and content of the database and perhaps migrate HW> them to another DBMS (Unix or Windows), There are those of us (like myself and my associates) to do data migration from/to MV/Sql and we have *some* tools which make the conversion easier. The real problem is understanding your current *structure*. Although there are *tools* which can help with this it does take time to analyse. Moving from the MV world (uniVerse) to the relational world is not simple but doable .. the real work, as I mentioned is the analysis. Without good documentation on your system this will take some time. I would have to ask (not trying to sell either way), other than having an old box that needs to be replaced .. are there any other reasons for moving away from MV. Does the application do all you need it to do. Are the connectivity problems with other applications? OR are you simply looking for an 'updated' system. HW> or (b) let us understand the structure and content of the DB? Once again, there are no specific tools that I know of for this process. Those of us in the business have our own tools to do this type of thing. Possibly a better understanding of where you are trying to get to would help us give a better answer. DSig David Tod Sigafoos SigsSolutions, Inc. > -------- Original Message -------- > Subject: > From: "Wong, Howard" <[EMAIL PROTECTED]> > Date: Tue, March 15, 2005 6:45 am > To: "'u2-users@listserver.u2ug.org'" <u2-users@listserver.u2ug.org> > > 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/ ------- 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/
