Re: [U2] Migrating OS
Hi Jeff, You need to byte-swap data as part of the migration process. For example, what's stored as (hex) 004E on the Solaris machine (unless it uses Intel chips) is stored as (hex) 4E00 on the Intel-chipped Linux machine. UniVerse, as someone else noted has a utility called fnuxi (also known as format.conv) for implementing byte swapping - like that poster I am not familiar enough with UD to advise on the equivalent utility for that product. Regards, Ray ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
You need to byte-swap data as part of the migration process. For example, what's stored as (hex) 004E on the Solaris machine (unless it uses Intel chips) is stored as (hex) 4E00 on the Intel-chipped Linux machine. UniVerse, as someone else noted has a utility called fnuxi (also known as format.conv) for implementing byte swapping - like that poster I am not familiar enough with UD to advise on the equivalent utility for that product. Thanks. To my knowledge, Unidata does not have fnuxi, but I know others have tackled this problem so it's solvable. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
On Unidata the byte conversion program are: In [ud install]\ud\bin convdata.exe - Data files convidx.exe - Indexes (you may be better off rebuilding indexes). convcode.exe - the compile code/object files just type the command with no arguments for their usage. Don Verhagen People 2.0 Global -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, November 20, 2009 7:23 PM To: Ray Wurlod Cc: U2 Users List Subject: Re: [U2] Migrating OS You need to byte-swap data as part of the migration process. For example, what's stored as (hex) 004E on the Solaris machine (unless it uses Intel chips) is stored as (hex) 4E00 on the Intel-chipped Linux machine. UniVerse, as someone else noted has a utility called fnuxi (also known as format.conv) for implementing byte swapping - like that poster I am not familiar enough with UD to advise on the equivalent utility for that product. Thanks. To my knowledge, Unidata does not have fnuxi, but I know others have tackled this problem so it's solvable. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
Thanks Don - I did already run all three and still encountered issues. Sent from my iPhone Jeff Butera jbut...@hampshire.edu On Nov 20, 2009, at 7:35 PM, Don u2-us...@southeast-florida.com wrote: On Unidata the byte conversion program are: In [ud install]\ud\bin convdata.exe - Data files convidx.exe - Indexes (you may be better off rebuilding indexes). convcode.exe - the compile code/object files just type the command with no arguments for their usage. Don Verhagen People 2.0 Global -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, November 20, 2009 7:23 PM To: Ray Wurlod Cc: U2 Users List Subject: Re: [U2] Migrating OS You need to byte-swap data as part of the migration process. For example, what's stored as (hex) 004E on the Solaris machine (unless it uses Intel chips) is stored as (hex) 4E00 on the Intel-chipped Linux machine. UniVerse, as someone else noted has a utility called fnuxi (also known as format.conv) for implementing byte swapping - like that poster I am not familiar enough with UD to advise on the equivalent utility for that product. Thanks. To my knowledge, Unidata does not have fnuxi, but I know others have tackled this problem so it's solvable. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
Jeff: 1) you haven't actually detailed the problems you encountered 2) you do need to move the files in a 'binary' mode 3) As you pointed out, Datatel has migrated many customers from Solaris to Linux. Perhaps you should re-direct your queries to your support provider (Datatel) - and just post the resolution here for reference. my two cents... Wally Terhune U2 Support Architect Rocket Software Tel: (720) 475-8055 Mobile: (303) 807-6222 wterh...@rocketsoftware.com u2supp...@rocketsoftware.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera [jbut...@hampshire.edu] Sent: Friday, November 20, 2009 6:02 PM To: Don Cc: U2 Users List Subject: Re: [U2] Migrating OS Thanks Don - I did already run all three and still encountered issues. Sent from my iPhone Jeff Butera jbut...@hampshire.edu On Nov 20, 2009, at 7:35 PM, Don u2-us...@southeast-florida.com wrote: On Unidata the byte conversion program are: In [ud install]\ud\bin convdata.exe - Data files convidx.exe - Indexes (you may be better off rebuilding indexes). convcode.exe - the compile code/object files just type the command with no arguments for their usage. Don Verhagen People 2.0 Global -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, November 20, 2009 7:23 PM To: Ray Wurlod Cc: U2 Users List Subject: Re: [U2] Migrating OS You need to byte-swap data as part of the migration process. For example, what's stored as (hex) 004E on the Solaris machine (unless it uses Intel chips) is stored as (hex) 4E00 on the Intel-chipped Linux machine. UniVerse, as someone else noted has a utility called fnuxi (also known as format.conv) for implementing byte swapping - like that poster I am not familiar enough with UD to advise on the equivalent utility for that product. Thanks. To my knowledge, Unidata does not have fnuxi, but I know others have tackled this problem so it's solvable. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
Wally wrote: 1) you haven't actually detailed the problems you encountered 2) you do need to move the files in a 'binary' mode 3) As you pointed out, Datatel has migrated many customers from Solaris to Linux. Perhaps you should re-direct your queries to your support provider (Datatel) - and just post the resolution here for reference. my two cents... Yes - I know Datatel has resources, but I don't need them - I got it to work. :) For transferring files previously, I tarred them, scped them, untarred them and then ran convdata. This time I just used scp to transfer them, ran convdata and happy day - no tarring involved. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
[snip] high byte order vs low byte order. [snip] It has been a really long time and my memory isn't what it was but, you may want to look at putting something like zip onto the machines and compiling (if your version doesn't have it already). Then just zip up your data and move it to the new system and unzip. The other thing that may work is to do a tar of everything. After you move the file to the new system, but, before you try to extract using tar, I think you may be able to do something like dd if=[name of input file] of=[name of output file] conv=swab You will need at least twice the disk space of the file free after you copy over the source (one for the temp build and one for the output file). I also seem to recall that one of these options doesn't work well with empty directories and in both cases, be careful of filenames that are the same except for casing. Eg. SAVEDLISTS and savedlists (was changed at some level because of this issue I believe). I hope this helps even though it's sketchy (wow - I wish I could pop in some extra flash memory or have a better index of what is buried inside ;-) If you get close with this info, you can contact me online or offline as more information on what happens may jar my memory some more. Best regards, Jim ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
Jeff: I don't believe UniData has any save/restore capability, so that method won't work. :-( Because of this, I think there is pretty good documentation in Administering UniData on Windows Platforms. You can also look at the UniAdmin manual, as these functions are discussed there. However, I have problems accessing these functions in my UniAdmin v1.3.7. I figure you've already been there but, just in case. :-) HTH, Bill Jeff Butera said the following on 11/18/2009 7:29 AM: So I've never had the pleasure of moving Unidata from one OS to another, but now do. We'll be moving from unidata 7.1.8 on Solaris 9 to Unidata 7.2.x on RedHat Enterprise. At this point I'm just playing but would like advice on preferred ways to migrate tables from Solaris to RedHat. I tried just moving them and running the usual convdata, convidx and convcode, but it's not happy about high byte order vs low byte order. At this point, I'm assuming it's going to have to be an account save/restore but I'm open to any advice having never gone down this road before. TIA, ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
There is an outstanding issue with convidx with a heavily overflowed index file. Fortunately you can delete the index before migrating and re-create and rebuild in on the new box. I don't know of any problems with convdata or convcode. Are you sure the technique you used to move your files kept them intact? For instance - if you used ftp and did not use binary mode, you would have problems. Of course the database on the source system would need to be paused or down - to be sure the files are in good state before moving them. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Wednesday, November 18, 2009 8:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] Migrating OS So I've never had the pleasure of moving Unidata from one OS to another, but now do. We'll be moving from unidata 7.1.8 on Solaris 9 to Unidata 7.2.x on RedHat Enterprise. At this point I'm just playing but would like advice on preferred ways to migrate tables from Solaris to RedHat. I tried just moving them and running the usual convdata, convidx and convcode, but it's not happy about high byte order vs low byte order. At this point, I'm assuming it's going to have to be an account save/restore but I'm open to any advice having never gone down this road before. TIA, -- Jeff Butera, Ph.D. Manager of ERP Systems, IT Hampshire College jbut...@hampshire.edu 413-559-5556 Maybe they're slow because they didn't get enough sleep last night. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
Are you sure the technique you used to move your files kept them intact? tarred them on Solaris Used scp to transfer to new host untarred on linux Of course the database on the source system would need to be paused or down - to be sure the files are in good state before moving them. This was a backup we have on disk, so I know they're not changing. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
I haven't been following this thread but it occurs to me to point out that Linux machine is probably running Intel chips with a different byte order to that used on the Solaris machine. If that point's already been made then please ignore this observation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
On Thu, 19 Nov 2009, Ray Wurlod wrote: I haven't been following this thread but it occurs to me to point out that Linux machine is probably running Intel chips with a different byte order to that used on the Solaris machine. If that point's already been made then please ignore this observation. Ray: I clearly understand your point, but I guess I'm not clear about the upshot to properly migrate data from Solaris to linux. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
I have moved a couple of installs of UniVerse from AIX and Windows to RH Linux. I have found that the easiest was to do this is to use UniAdmin to do an account save on the old system and then use UniAdmin on the new system to restore the account. I usually do the backup to a file and ftp the file to the new system using binary ftp. I have also moved UniVerse account by making a tar ball of the account directory and untaring the file on the target system, but after using tar, you need to use the funuxi command to correct the byte codes on the files. This method has worked with some problems on indexes and distributed files. Check out the UniAdmin tool on the Client CD. Use the latest version you can get your hands on of UniAdmin. Sorry that I haven't had any experience with migrating UniData, but I bet the problems are similar. Thanks Ken - this sounds reasonable. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users