7.31 to 10X

Hi, Old OS Sun 8X ANCIENT IDS 7.31UD4 OLDER SUN SYSTEM HP Jukeboxes hardwired to the SUN. Instance size 1033 2 GB chunks on a SAN with mirroring to another SAN and 4912 512 MB optical disks with images. New OS Sun 10 IDS 10X SUN 490’s 15 TB SAN Does anyone know if it is possible to shutdown the 7.31 and move the backup to the new boxes and bring the instance up in 10X without the optical drives? Then backup the instance without the optical drives in 10X. Shutdown the instance and point the links to the new SAN.

I'm sure someone else can confirm but I don't think you're going to restore a 7.3 backup using 10. You could *try*: - loading 7.3 on the new box - make the $ONCONFIGs the same - create all the necessary links to appear as the same device names as the old system - restore from tape - upgrade from 7.3 to 10 Bob Roussey Unix / Informix Administration Spirit Airlines Robert.Roussey@SpiritAir.com -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SAMUEL JAKABOWSKI Sent: Thursday, June 14, 2007 8:45 PM To: ids@iiug.org Subject: 7.31 to 10X [9363] Hi, Old OS Sun 8X ANCIENT IDS 7.31UD4 OLDER SUN SYSTEM HP Jukeboxes hardwired to the SUN. Instance size 1033 2 GB chunks on a SAN with mirroring to another SAN and 4912 512 MB optical disks with images. New OS Sun 10 IDS 10X SUN 490's 15 TB SAN Does anyone know if it is possible to shutdown the 7.31 and move the backup to the new boxes and bring the instance up in 10X without the optical drives? Then backup the instance without the optical drives in 10X. Shutdown the instance and point the links to the new SAN. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks for the suggestion. We are unable to backup this instance up. Do not have a tape drive on either the old or new systems. Tivoli failed do to a table that has data in a data space and the byte field on an optical disk that was on the shelf. We know that we can insert into the 10X from 7.31 using dbaccess. The problem is the speed needed to accoplish this. The 7.31 is a 24X7 site.

You can also move the data several other ways: 1) Export/import using dbexport & dbimport 2) Use hploader to export the data to a pipe read by another copy of hploader writing to the IDS 10 table directly. 3) My dbexport/dbimport replacement utilities in the myexport package which can use hploader to export and import (fully compatible with dbexport & dbimport) through files much faster. (Myexport requires the following other packages: utils2_ak (for myschema), sqlcmd (v72.05 or later), and myonpload (an easy scriptable commandline interface to hploader). Art S. Kagel ----- Original Message ----- From: Samuel Jakabowski <ids@iiug.org> At: 6/15 9:24:11 Thanks for the suggestion. We are unable to backup this instance up. Do not have a tape drive on either the old or new systems. Tivoli failed do to a table that has data in a data space and the byte field on an optical disk that was on the shelf. We know that we can insert into the 10X from 7.31 using dbaccess. The problem is the speed needed to accoplish this. The 7.31 is a 24X7 site. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks Art, Tried dbexport ran into the 2GB OS limit and encountered errors with the tables that have columns that point to the optical sub-system and the images are not there. We have iages on 4912 optical disks with 2 jukeboxes that hold 20 disks each. Pulling the optical images is the issue.

Another option would be a custom written application to copy the data directly. You could start with the code for my dbcopy utility. It's never been updated for SmartBLOBs but it handles TEXT and BYTE blob columns. Unless you just want to migrate the optical platters to the new machines and just load up the in-record data including the locator data without copying the optical data at all. There should be a way to do that, but I can't think it through right now, contact IBM support for help with this. FYI, IBM is thinking of dropping read-only optical platter support sometime in the future, so it may be better to migrate that data to rewritable storage anyway. Art S. Kagel ----- Original Message ----- From: Samuel Jakabowski <ids@iiug.org> At: 6/15 10:06:36 Thanks Art, Tried dbexport ran into the 2GB OS limit and encountered errors with the tables that have columns that point to the optical sub-system and the images are not there. We have iages on 4912 optical disks with 2 jukeboxes that hold 20 disks each. Pulling the optical images is the issue. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

How about setting the TAPEDEV to a symbolic link to a disk file. Then moving that file to another machine then restoring it to the database of choice. I guess the 7.3 engine. Note I am now using a 10 version of Workgroups Edition and never ran a 7 version so this just a concept. that would have worked in 9 or 10. SAMUEL JAKABOWSKI wrote: > Thanks for the suggestion. We are unable to backup this instance up. Do not > have a tape drive on either the old or new systems. Tivoli failed do to a > table that has data in a data space and the byte field on an optical disk that > was on the shelf. > > We know that we can insert into the 10X from 7.31 using dbaccess. The problem > is the speed needed to accoplish this. The 7.31 is a 24X7 site. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --

We had planned on keeping the images as a byte in 10X and slowly move them to smart blobs as we test each progam before bringing this new system on line. We know that we can pull the images that are currently in the jukeboxes. So our thinking is to create another table in a new instance to hold the images and load them there from the platters and try dbexport of them.

Give a try to using my dbcopy utility to move the data directly between the instances. It's very fast copying between different servers as long as the network is fast and you can run many copies of dbcopy with good throughput scaling until you swamp the network. That will let you partition the data running separate dbcopy instances for ranges of rows. I've run up to 20 copies copying between databases on the same 32CPU box. I don't think you'll be able to run that many productively over the network, but it you have a GB channel set up, you should be able to get 5-10 going. Art S. Kagel ----- Original Message ----- From: Samuel Jakabowski <ids@iiug.org> At: 6/15 10:46:52 We had planned on keeping the images as a byte in 10X and slowly move them to smart blobs as we test each progam before bringing this new system on line. We know that we can pull the images that are currently in the jukeboxes. So our thinking is to create another table in a new instance to hold the images and load them there from the platters and try dbexport of them. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Thanks Art. Will give it a try and let you.