ja thats sounds like you get new disks with new names. It don't think that for example ontape -r will work if there are chunks with different names. There is a chance with dbexport, or onunload if the files less than 2GB in size.
Yes, You are right. I would like to make the following:
1_ Setup a New Informix engine in the new disks
2_ Create Tables
2_ Export data from the DB an impot to the new one.
3_ Make some tests
4_ Change "The servers names".
I know how to Creates Tables and tranfer the data , But I know nothing agout create new engine, database netither how to change the database names. I need to maintain the "Server Name " and DataBase Name due to the application that it is using the Informix, has "hardcoded" these settings.
with dbexport/dbimport you do not need to create tables, dbimport does ist, ist creates DB too. Just copy the file onconfig and change all dir/path and names. Save the old onconfig by another name, then oninit -i and create all environments belonging to that online engine. Dbimport and ready, sound easy, try it. That ist really a short informtion, maybe it will help. So i'm off duty now leaving to weekend .
You can also do this.........
Say your current database is Db_01 and the current dbspaces are
dbspace_01 and dbspace_02.
Do the following.......
1. Create the two(n-number of) dbspaces.
eg: dbs_01 & dbs_02.
2. Do dbschema -ss -d <Db_01> Db_01.sql
3. Vi Db_01.sql and run
:sed -e 's/dbspace_01/dbs_01/g'
:sed -e 's/dbspace_02/dbs_02/g'
save the file as Db_01_new.sql
4. echo " create database Db_01_new in dbs_01 " |dbaccess Db_01
5. set the TAPEDEV to /dev/null in the $ONCONFIG file.
6. Run ontape -s -L 0 -N Db_01 (Note the logging status prior to changing) and reset the TAPEDEV parameter to its original value.
7. Execute the following for each table in the Db_01 database.
echo "insert into Db_01_new:<table_01> select * from
Db_01:<table_01> " |dbaccess Db_01_new
8. Once all data is loaded, and audits done on the tables, do a level 0 backup.
9. echo "drop database Db_01; rename database Db_01_new to
Db_01" |dbaccess sysmaster
10. Run Update Statistics for the database and you are set to go.