instance copy

HI, A customer has about 6.6TB real user data, IDS version is 11.5 , and I want to copy the data to another testing instance, the customer can't use disk mirror technology. the two box has 10GB network adapter, Informix has below method, from your experience, which one is more quickly. 1) ontape with STDIO, 2) remote query 3) onbar/ISM backup to a NFS file system, and do restore in the target machine. and could anybody share the best practice doing the backup using onbar with ISM? thanks for your time.

Ontape or onbar would be the fastest of those you mention. Or you can use the ifxclone utility which would probably be fastest of all. 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, Jan 15, 2016 at 9:36 AM, CHUAN LU <luchuan@cn.ibm.com> wrote: > HI, > A customer has about 6.6TB real user data, IDS version is 11.5 , and I > want to > copy the data to another testing instance, the customer can't use disk > mirror > technology. the two box has 10GB network adapter, Informix has below > method, > from your experience, which one is more quickly. > > 1) ontape with STDIO, > > 2) remote query > > 3) onbar/ISM backup to a NFS file system, and do restore in the target > machine. > > and could anybody share the best practice doing the backup using onbar with > ISM? > > thanks for your time. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1141c1e0679dcb05296082e9

On Fri, Jan 15, 2016 at 2:36 PM, CHUAN LU <luchuan@cn.ibm.com> wrote: > HI, > A customer has about 6.6TB real user data, IDS version is 11.5 , and I > want to > copy the data to another testing instance, the customer can't use disk > mirror > technology. the two box has 10GB network adapter, Informix has below > method, > from your experience, which one is more quickly. > > 1) ontape with STDIO, > Slow as it works with a single thread. Can't be paralell. > 2) remote query > Can be run in parallell but data consistency will be an issue. Additionally the target database would have to use the same logging mode as the source, which for logged databases means less efficiency on the copy side (write) 3) onbar/ISM backup to a NFS file system, and do restore in the target > machine. > If you can get good performance from the NFS this would be the best option. > > and could anybody share the best practice doing the backup using onbar with > ISM? > I'm not the right person to help you with ISM. It has been deprecated for many years and I haven't used it. I believe it has a limit of 4 "devices" so try to configure it with that number of files in the data pool. It would be bettwe to do a whole system backup (-w). That will avoid the need of logical recovery and since 11.x it can be done in parallel Regards. > > thanks for your time. > > > > ******************************************************************************* > 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... --001a113f9a8c3987140529609825

Ontape is the easiest, but you have ifxclone, ER and HPL as well Cheers Paul Paul Watson Oninit www.oninit.com +1 913 387 7529 Oninit® is a Registered Trademark of Oninit LLC > On Jan 15, 2016, at 08:36, CHUAN LU <luchuan@cn.ibm.com> wrote: > > HI, > A customer has about 6.6TB real user data, IDS version is 11.5 , and I want to > copy the data to another testing instance, the customer can't use disk mirror > technology. the two box has 10GB network adapter, Informix has below method, > from your experience, which one is more quickly. > > 1) ontape with STDIO, > > 2) remote query > > 3) onbar/ISM backup to a NFS file system, and do restore in the target > machine. > > and could anybody share the best practice doing the backup using onbar with > ISM? > > thanks for your time. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum.

For the last migration to new hardware I simply setup the target as an HDR secondary , and eventually flipped primary/secondary. It worked fine although it was across slow small pipes so the initial archive push took ~30 hours. The logical log syncing was very fast even when there were 10,000+ logical logs to sync (due to the long archive time). Sounds like you just want a copy so the flipping would be unnecessary. You would just break HDR (on purpose) and establish the secondary as a stand-alone engine. ifxclone isn't available with 11.5 (unless it got back ported and I missed it). Make sure RESTARTABLE_RESTORE is set to ON on both sides so the initial restore can restart from where it left off. Thanks - Mark Scranton The Mark Scranton Group "All Informix ... All the Time" mark@markscranton.com