IDS Forum

RE: Onunload and onload

Posted By: Paul Watson
Date: Wednesday, 5 June 2013, at 2:25 p.m.

In Response To: Re: Onunload and onload (John Miller iii)

If bandwidth is an issue then stick a gzip/gunzip in the command lines.

If the servers are close and have a spare NIC just use a cross over cable

Cheers
Paul

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of John
Miller iii
Sent: Wednesday, June 05, 2013 1:03 PM
To: ids@iiug.org
Subject: Re: Onunload and onload [30433]

Sounds like you want to copy one system to another system only using the
network
and avoid disk space. This is very simple. You can borrow the
methodology from
setting up a hdr server. For additional information see the manual under
"decrease setup time using ontape STDIO"

ontape -s -L 0 -t STDIO -F | rsh server2 ontape_restore.ksh

-----------------------ontape_restore.sh------------------------------
#!/bin/ksh
#Setup the informix environment then run ontape restore
.. /home/informix/informix.env

# redirect stdout and stderr to avoid any output.
ontape -p -t STDIO >/dev/null 2>&1

John F. Miller III

ids-bounces@iiug.org wrote on 06/05/2013 10:35:47 AM:

> From: "ANDREW PISTOCCHI" <APISTOCCHI@UT.EDU>
> To: ids@iiug.org,
> Date: 06/05/2013 10:36 AM
> Subject: Onunload and onload [30432]
> Sent by: ids-bounces@iiug.org
>
> I have an older HP Integrity server that I would like to use for R&D
testing
> for our Informix databases. I need assistance in copying a database from
one
> server to another. Both servers are Integrity servers running HPUX 11i v3
and
> Informix 11.70.FC4. On the production server, I've used the onunload and
> onload utilities to copy a live database to a train or dev database. This

> works fine. Now I would like to copy a database from one server to the
other
> without using any tape devices. Both servers are on the same network.
Both
> servers have the same size dbspaces. The R&D server was restored from a
HP
> Ignite make_tape_recovery bootable tape so all the file systems, logical
> volumes and dbspaces are the same on both servers.
>
> I've also seen older posts on using dbexport / dbimport and other
utilities.
> What would be the best utility to do this on a regular basis? Thanks.
>
> Andy Pistocchi
> DBA / Systems Administrator
> The University of Tampa
> apistocchi@ut.edu<mailto:apistocchi@ut.edu>
>
>
>

****************************************************************************
***

> Forum Note: Use "Reply" to post a response in the discussion forum.
>

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Onunload and onload
  ANDREW PISTOCCHI -- Wednesday, 5 June 2013, at 1:35 p.m.
  • Re: Onunload and onload
    John Miller iii -- Wednesday, 5 June 2013, at 2:02 p.m.
    • Re: Onunload and onload
      Nagaraju Inturi -- Wednesday, 5 June 2013, at 2:16 p.m.
    • RE: Onunload and onload
      Paul Watson -- Wednesday, 5 June 2013, at 2:25 p.m.
  • Re: Onunload and onload
    Art Kagel -- Wednesday, 5 June 2013, at 2:17 p.m.
    • RE: Onunload and onload
      ANDREW PISTOCCHI -- Wednesday, 5 June 2013, at 3:53 p.m.
      • Re: Onunload and onload
        Art Kagel -- Wednesday, 5 June 2013, at 4:14 p.m.
        • Re: Onunload and onload
          Marcus Haarmann -- Wednesday, 5 June 2013, at 4:29 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.