installing informix

[MichelleButler]

I currently have an old rs6000 and I would like to transfer all the data and informix directory to a new rs6000. I haved managed to tar all the data, such as database and all the 4gl coding, but my only concern is that I can not get the informix to work. Such as isql, r4gl. Does anybody know what is wrong or can anybody direct me in the correct direction for setting up informix correctly?

many thanks

michelle

 

[vpshriyan]

hi,

Database porting across another server can be accomplished by using export and import utility. Steps involved:

1. Install relevant Informix products in target server (rs6000). Make sure that the database server instance is running. Set TAPEDEV and LTAPEDEV config parameters to /dev/null at this juncture so that the import activities are not logged. You can set these to actual device at future, once everything seems to be ok.

2. From the source server Issue: dbexport <databasename> -ss -t <tape device> -b <block size> -s <tape size>. This will dump the entire content of the database to a tape. Alternately if you have sufficient disk space you can dump the contents to a directory which will be faster; by issuing command: dbexport <databasename> -ss -o <directoryname>. Take a tar copy of the directory and extract the contents into target server.

3. Take a listing of allocated spaces in the source server by onstat -d command and create spaces and relevant chunks in the target server. Keep the chunk size almost similar.

4. Issue dbimport to gather the data from the dump files. If the source if tape issue: dbimport <database> -t <tape device> -b <block size> -s <tape size>. If the source is a directory issue: dbimport <database> -i <source directory>

5. To activate the log machanisms issue: ontape -s -B <database name> for buffered log database mode. ( ontape -- for full help )

6. Introduce/create old users into the target servers at OS level.

7. Copy all the application sources (4gl,per,msg,sql etc.) into target server using tar. Re-compile all the sources and generate runnable versions.

Phew ... Thats it. Should work. Good Luck.

Regards,
Shriyan

 

[olded]

Michelle:

If you didn't use the tar &quot;p&quot; option, restore files to their original modes, you could have an owner/group problem or a file permission problem. For example, on my Solaris 7, box isql has the following permissions:

-rwxr-xr-x 5 informix informix 1660848 Jul 7 1999 isql

Yours probably are similiar.

Regards,


Ed

 

[ompi]

hi,

I have an "Informix Dynamic Server Version 7.31.UC4" on sgi IRIX (unix) installation. Job was to copy a db (fm32) to another dbspace (fmeudbs) on another name (fmeu32). I've made an onunload copy with the "onunload -t ./fm32_regi fm32" command. So, I have a file named fm32_regi which contains the data of the db fm32. When I try to load it to the newly created dbspace fmeudbs with the command "onload -t ./fm32_regi -d fmeudbs fmeu32", it seems to work (db is created, space on the dbspace decreasing), but after some hours the new dbspace becomes empty again. There are no error messages in the online.log, on the console...

???

thanx