Re: Restoring to a different server

Elena, I'm not familiar with Informix on Solaris, but I do know that on our platform, and possibly all, you must be sure that you have an Informix instance already configured with the same chunks, dbspaces, etc on your other machine before you can do the restore. In other words, you have to have initialized shared memory to look exactly like the other system before you try to do the restore. If you don't want them to be the same, then you need to unload the original database (onunload) and then load it to the second machine. Other Informix experts can correct me if I'm wrong. In article <O%d25.1603$Qf6.60944@nuq-read.news.verio.net>, "Elena" <ekorol@styleclick.com> wrote: > Informix masters, > I am kind of a new to the Informix world. > Hope that someone will help me with the following problem: > > We are trying to restore to a separate machine to get some lost > transactions, on a Solaris 7 and Solaris 8. I restored a complete source > informix directory containing data and config. files into a new machine. > Changed entries in sqlhosts, ONCONFIG file, paths, reset environment > variables to the same parameters as on the source machine. When I try to > start informix server - I am getting a following error: > + [ -x /dh0/db/informix92/bin/oninit ] > + echo SQL Server starting...\\c > SQL Server starting...+ /usr/bin/ulimit -n 30000 > + /dh0/db/informix92/bin/oninit > oninit: Fatal error in shared memory creation.... > > Here are parameters from my onconfig file for shared memory: > LOCKS 100000 # Maximum number of locks > BUFFERS 150000 # Maximum number of shared buffers > NUMAIOVPS 2 # Number of IO vps > PHYSBUFF 32 # Physical log buffer size (Kbytes) > LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX 25 # Maximum number of logical log files > CLEANERS 2 # Number of buffer cleaner processes > SHMBASE 0xa000000 # Shared memory base address > SHMVIRTSIZE 200000 # initial virtual shared memorysegment size > SHMADD 16284 # Size of new shared memory segments > (Kbytes) > SHMTOTAL 750000 # Total shared memory (Kbytes). 0=>unlimited > CKPTINTVL 300 # Check point interval (in sec)> > Please help... > Sincerely, > Elena. > > ekorol@styleclick.com > > Sent via Deja.com http://www.deja.com/ Before you buy.