Migrate 11.7 Informix database to an other server

Hi, I have a huge informix 11.7 database on a Windows 2008 r2 (more than 1.5 TB), I have installed an other empty database with the same driver and the same strutcure of chunks and dbsapce and also onconfig, I planify to replicate this database on the second server, I'm wondering if I take a copy of al chunks including rootdbs ,logdbs, tempsdbs and override the chunks on the second server, it will work or not, I use Tsm to copy the chunks from the first server and overide the chunks on the second server. for info, I have already try ontape but the file generated is huge and I did not have enough space.

If the Informix version and platform are the same, you can do a backup oun source and restore on target. Eventually if the downtime is an issue, you can create an HDR pair and the secondary server (your new server) will receive all the transactions from the source. Once the're in sync, stop the applications, make sure they're in sync, disconnect the primary and change the secondary into a standard server. Nearly no downtime. All your databases need to have logging for this to be an option. Regards On Fri, Dec 11, 2015 at 5:33 PM, CHALLENGER212 ABDERRAFI < abderrafi212@gmail.com> wrote: > Hi, I have a huge informix 11.7 database on a Windows 2008 r2 (more than > 1.5 > TB), I have installed an other empty database with the same driver and the > same strutcure of chunks and dbsapce and also onconfig, I planify to > replicate > this database on the second server, I'm wondering if I take a copy of al > chunks including rootdbs ,logdbs, tempsdbs and override the chunks on the > second server, it will work or not, I use Tsm to copy the chunks from the > first server and overide the chunks on the second server. > for info, I have already try ontape but the file generated is huge and I > did > not have enough space. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a113fe51e45b1d60526a2c758

I agree with my colleague that this sounds idea for HDR. = ; In addition there is a simple utilize which will automatically clone t= he data over the network called ifxclone. It can run several strea= ms in parallel to speed up the transfer. John F. Miller III S= TSM, Lead Architect [1]mil= ler3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) [2]-----ids-bounces@iiug.org wrote: -----= >To: [3]ids@iiu= g.org >From: "Fernando Nunes" >Sent by: [4]ids-bounces@iiug.org >D= ate: 12/11/2015 09:38AM >Subject: Re: Migrate 11.7 Informix database = to an other.... [36232] > >If the Informix version and platfor= m are the same, you can do a >backup oun >source and restore o= n target. >Eventually if the downtime is an issue, you can create an= HDR pair >and the >secondary server (your new server) will re= ceive all the transactions >from >the source. Once the're in s= ync, stop the applications, make sure >they're >in sync, disco= nnect the primary and change the secondary into a >standard >s= erver. Nearly no downtime. >All your databases need to have logging = for this to be an option. > >Regards > >On Fri, D= ec 11, 2015 at 5:33 PM, CHALLENGER212 ABDERRAFI < >[5]abderrafi212@gmail.com= > wrote: > >> Hi, I have a huge informix 11.7 database o= n a Windows 2008 r2 (more >than >> 1.5 >> TB), I = have installed an other empty database with the same driver >and the = >> same strutcure of chunks and dbsapce and also onconfig, I plan= ify >to >> replicate >> this database on the seco= nd server, I'm wondering if I take a copy >of al >> chunks = including rootdbs ,logdbs, tempsdbs and override the chunks >on the <= br>>> second server, it will work or not, I use Tsm to copy the chunk= s >from the >> first server and overide the chunks on the s= econd server. >> for info, I have already try ontape but the file= generated is huge >and I >> did >> not have enou= gh space. >> >> >> >> >*****= **************************************************************** >***= ******* >> Forum Note: Use "Reply" to post a response in the disc= ussion forum. > >> >> > >-- >F= ernando Nunes >Portugal > >[6]http://informix-technology.blo= gspot.com >My email works... but I don't check it frequently... = > >--001a113fe51e45b1d60526a2c758 > > >****= ***************************************************************** >**= ******** > Forum Note: Use "Reply" to post a response in the discus= sion forum. > > > References 1. 3D"mailto:miller3@us.ibm.com" 2. 3D"mailto:-= 3. 3D"mailto:ids@iiug.org" 4. 3D"mailto:ids-bounces@iiug.org" 5. 3D"mailto:abderrafi212@gmail.com" 6. =3D"http://informix-technology.blogspot.com"/

Hi,I have no space to take ontape backup and pas single via stdio is possible but I dont know how to make rsh on windows, I want to know if What I'M doing will work.

Answers: 1 - Copying storage to initialize a secondary server: You can do this, but only if the copy us made under an external back up condition which is initiated on the source server with onmode -c block. While the server is blocked copy the chunks to the target server (or to an intermediate location), then unblock the source server with onmode -c unblock. Start the new server with "oninit -PHY" which is a physical only restart (no recovery). Then register the HDR relationship with onmode -d primary <secondary name> on the primary and onmode -d secondary <primary name>. Voila! This will only work if a) all databases are logged, and b) you have enough logical log space on the primary so that the logs will not wrap while you are copying the files and starting the new engine. 2 - You can use the new ifxclone utility to clone the primary to a new secondary. Under v11.70 you cannot create the new server as an HDR secondary, but rather as an RSS secondary, but once the new secondary is in sync with the primary you can promote it to a secondary by running the appropriate onmode -d commands as above. The advantage of this is that it does not require a third set of disk space for an intermediate copy of the chunks. It archives the primary to a pipe and restores the new secondary directly from that same pipe. Run ifxclone on the new secondary machine NOT on the primary (that's not well documented). You can even have ifxclone optionally clone the ONCONFIG file from the primary for you. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Dec 11, 2015 at 12:33 PM, CHALLENGER212 ABDERRAFI < abderrafi212@gmail.com> wrote: > Hi, I have a huge informix 11.7 database on a Windows 2008 r2 (more than > 1.5 > TB), I have installed an other empty database with the same driver and the > same strutcure of chunks and dbsapce and also onconfig, I planify to > replicate > this database on the second server, I'm wondering if I take a copy of al > chunks including rootdbs ,logdbs, tempsdbs and override the chunks on the > second server, it will work or not, I use Tsm to copy the chunks from the > first server and overide the chunks on the second server. > for info, I have already try ontape but the file generated is huge and I > did > not have enough space. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bd7571063f2b00526a3a2da

Hi, My database is nologing mode, I have shut down Informix on the first server and I'm trying this copy now to the second server in wich I have the same informix strutcure,you think this wil not work. I want no connexion between the two servers, just a copy of the fiorst. I have no space to do ontape , and rsh on widnows is not working, so only I want to make such as a clone by copiyng all chunks to the second server, you think this will not work ??

If the server is shutdown then the copy will be fine and you should be able to start the server on the other machine, yes. However, you mentioned "replicate". If by that you just mean copy the server and then have two completely independent servers that initially have the same data but from then on will be different, that's fine, but if you meant that you want to be able to keep the two servers in sync so that the new one always has the same data as the original, then that will only work if all of the databases on the servers are logged (either buffered, unbuffered, or ANSI mode but not UNLOGGED). Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Fri, Dec 11, 2015 at 2:27 PM, CHALLENGER212 ABDERRAFI < abderrafi212@gmail.com> wrote: > Hi, My database is nologing mode, I have shut down Informix on the first > server and I'm trying this copy now to the second server in wich I have the > same informix strutcure,you think this wil not work. > I want no connexion between the two servers, just a copy of the fiorst. > I have no space to do ontape , and rsh on widnows is not working, so only I > want to make such as a clone by copiyng all chunks to the second server, > you > think this will not work ?? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e013c68d6d19e930526a45f65

thanks for answering, and yes I want just to have a security copy for this huge database (>1 TB), no connexion or sync between the two servers are needed, for shuting down its no problem because the source is a huge yes but not so used by the users, I can bring it down in the Weekends and no problem for that, what I want is just a simple copy to the target server by overding all the chunks on the target wich has the same empty database strcuture. for info the two servers are not the same in terms of hardware neither of networking (not the same domain). so will my try work. If yes, I will do this procedure every month. Thanks a lot

You can use the external back technology to allow user to con= tinue to read the system, but prevent modifications. onmode -c b= lock copy data to other server onmode -c unblock John F. M= iller III STSM, Lead Architect [1]miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic S= erver (IDS) -----ids-bounces@iiug.org wrote= : ----- >To: [2]ids@iiug.org >From: "CHALLENGER212 ABDERRAFI" >Sent= by: [3]ids-bounce= s@iiug.org >Date: 12/11/2015 11:54AM >Subject: Re: Migrate = 11.7 Informix database to an other ser [36238] > >thanks for a= nswering, and yes I want just to have a security copy for >this &= gt;huge database (>1 TB), no connexion or sync between the two servers>are >needed, for shuting down its no problem because the sourc= e is a huge >yes but >not so used by the users, I can bring it= down in the Weekends and no >problem >for that, what I want i= s just a simple copy to the target server by >overding >all th= e chunks on the target wich has the same empty database >strcuture. <= br>>for info the two servers are not the same in terms of hardware &g= t;neither of >networking (not the same domain). >so will my t= ry work. >If yes, I will do this procedure every month. > = >Thanks a lot > > >**********************************= *********************************** >********** > Forum Note:= Use "Reply" to post a response in the discussion forum. > > > References 1. 3D"mailto:miller3@u= 2. 3D"mailto:ids@iiu= 3. 3D"mailto:ids-bounces@iiug.org"

I have no need to keep the database up,but I want to know if it would work, the simple copy of all chunks to an empty same structure database. thanks

The problem that you will run into is that if the source instance is not completely quiescent AND a successful checkpoint has not been done while quiescent AND only then the database chunks are copied AND the database is not active during this time.....Then it is possible that not all of the current pages are physically on disk. If all of the pages are not physically on disk when you perform the copy, then you will have problems when trying to bring up the target system. Some of those problems might occur during the start-up of the server, but some might not occur for some time after you started the instance. What you are proposing is rather risky. It would be much better to purchase enough additional storage devices to handle a backup and then restore on the new system. Madison Pruet Retired from IBM On Friday, December 11, 2015 3:41 PM, CHALLENGER212 ABDERRAFI <abderrafi212@gmail.com> wrote: Hi, My database is nologing mode, I have shut down Informix on the first server and I'm trying this copy now to the second server in wich I have the same informix strutcure,you think this wil not work. I want no connexion between the two servers, just a copy of the fiorst. I have no space to do ontape , and rsh on widnows is not working, so only I want to make such as a clone by copiyng all chunks to the second server, you think this will not work ?? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Ok, so How can I force a complete checkpoint before bringing down the database and copying the chunks. I can add that this database is not transactional and I can bring it down at any moment. regards

Using onmode -ky or -uy will perform a checkpoint and shutdown the server. The -k option forces sessions to exit -u waits for all sessions to quit on their own or times out. Art On Dec 13, 2015 18:32, "CHALLENGER212 ABDERRAFI" <abderrafi212@gmail.com> wrote: > Ok, so How can I force a complete checkpoint before bringing down the > database > and copying the chunks. > I can add that this database is not transactional and I can bring it down > at > any moment. > > regards > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113fe51eeeb8880526d07947

Easy to remember - onmode -yuck !! Regards, David. > On 14 December 2015 at 00:08 Art Kagel <art.kagel@gmail.com> wrote: > > > Using onmode -ky or -uy will perform a checkpoint and shutdown the server. > The -k option forces sessions to exit -u waits for all sessions to quit on > their own or times out. > > Art > On Dec 13, 2015 18:32, "CHALLENGER212 ABDERRAFI" <abderrafi212@gmail.com> > wrote: > > > Ok, so How can I force a complete checkpoint before bringing down the > > database > > and copying the chunks. > > I can add that this database is not transactional and I can bring it down > > at > > any moment. > > > > regards > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a113fe51eeeb8880526d07947 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >