Informix database migration on HP-UX
Rather than rebuilding an Informix database on the new HP-UX server, it possible to migrate the existing installation from the old server. The database resides on raw disks with transparent volumes that are not visible in /etc/fstab, or via bdf or df -k.
To view the database volumes on the old server:
Once there, you can view the size of the volumes, which will need to be re-created on the new server:
vxprint -rth (volume_name)
On the new server create a disk group using VxVM or LVM. Then create database volumes using parameters shown by vxprint from the previous step. Do not create any file systems.
On the old server go to /dev/vx/rdsk/dgxxx/(volume_name) and note permissions and ownership for each directory level. Replicate these settings on the new server.
Use the dd command to copy each volume from the old server to the new server. You will need to add hostname and IP of the old server to the ~/.rhosts file on the new server to allow remsh operations under root account.
/usr/bin/dd if=/dev/vx/rdsk/dgxxx/(volume_name) bs=64k | remsh (newserver) -l root /usr/bin/dd of=/dev/vx/rdsk/dgxxx/(volume_name) bs=64k
Have the DBAs verify database integrity.