RE: NEED HELP : Informix and replacement of an SSA disk exercise
Posted in 2000
Remember to record all your softlinks to raw devices. If you used
hardlinks, you might have to create softlinks to the new IBM CE hardlinks.
Old and new names must be exactly the same {full path name} and same size
or bigger.
e.g.: you had a hardlink /dev/rdsk/c1t8d0s4 that is not there anymore with
the IBM CE but now have
eg /dev/rdsk/c9t1d0s0
You will have to create a softlink: ln -s /dev/rdsk/c9t1d0s0
/dev/rdsk/c1t8d0s4
It is always a good idea to use softlinks to your raw devices.
eg. /usr/informix/data/c0d0s1 -> /dev/rdsk/c?t?d?s? or
eg. /usr/informix/disks/c0d0s1 -> /dev/rdsk/c?t?d?s? or
eg. /usr/informix/...... -> /dev/rdsk/c?t?d?s?
Much easier to migrate to new systems.
---------------------------------------------------------
So if you can read all the data on SSA {Don't think you will be able to in
this case, backup failed}
Install IBM CE {disk pack or whatever it is}
Create similar devices on IBM
dd data from SSA to IBM
Change Informix softlinks from SSA to IBM raw devices
oninit
Always good to have backups
-----Original Message-----
From: Ameerul@mesiniaga.com.my [SMTP:Ameerul@mesiniaga.com.my]
Sent: Thursday, June 08, 2000 9:07 AM
To: informix-list@iiug.org
Subject: NEED HELP : Informix and replacement of an SSA disk exercise
Hi everyone.
Need help in this exercise. I have a RS6000 G40 with Aix 4.3.2 with
Informix IDS7.31UC4, ISQL 7.20
and 4GL RDS 7.20. The informix main directory is in the main disk (non SSA)
and the database dbspace
contains lots of chunks where some chunks of the same dbspaces are in this
SSA and the rest in other
disks.
This SSA disk has a degradation problem and need to be replace. It will be
done by an IBM CE. That
is why we had problem doing ontape -s backup giving the error :
"Archive failed-ISAM error. An error has occured during archive backup"
In the end, in the error report (errpt) for aix, it is a SSA disk failure.
We tried dbexport and it was ok. We not sure how the dbimport would be.
The question is that worries me is that what should be done on the Informix
portion during this SSA
disk replacement exercie??
I was panning on this :
- dbexport the database using dbexport dbname -ss
- system backup on the OS
- capture the informix details - onconfig, sqlhosts, onstat -d, databases,
log files,
- IBM CE will migrate the disk contents & we test the informix and
application
- If there is problem, need to recreate the engine, dbpaces, chunks, logs
etc
- reinitialize informix
- dbimport database
If anyone has better suggestions, please help me here. Thank you very much.