IDS Forum

Re: ontape -r Memory Fault

Posted By: Art Kagel
Date: Tuesday, 11 June 2013, at 10:52 a.m.

In Response To: ontape -r Memory Fault (LUKE MORGAN)

You CANNOT restore an Informix archive with any other version than the one
with which it was made (at least down to the minor version level - so any
7.23 would work but 7.24 and later will not be able to restore this
archive). Note that you also cannot restore an Informix archive on a
different physical platform so if the archive was made on a Sparc machine
running Solaris you cannot restore it on a Solaris Intel or Linux Sparc
platform and by extension not on WIndows, HPUX, or AIX for that matter.

You have three good choices:

1. Install 7.23 on the new machine, restore the archive using the 7.23

executable, shutdown 7.23, start up 7.31 and it will convert the disk

structures to 7.31 format automatically.

2. Export the 7.23 database(s) using dbexport (or another ETL tool of

your choice) and reimport the database(s) on the new server using dbimport

(or whatever).

3. Create the schema taken from the 7.23 server on the 7.31 server and

copy the data table-by-table directly from one server to the other. My

dbcopy utility (especially with the mkdbcopy.awk script in my utils4_ak

package) is VERY good at this and fast, but you can also use hploader for

this (assuming 7.23 had a working hploader - I don't remember).

You are aware that both of these Informix releases are WAY out-of-date and
out-of-support, right? What you should REALLY be doing is importing that
data into a modern Informix v11.70 or 12.10 release engine! It will
perform at least 55% faster than the 7.31 (and maybe another 25% faster
above that than the 7.23 version does and that's without counting that you
are probably running 7.23 on hardware that's less than 1/4 the processing
speed of a modern machine!) Version 7.31.xD8 dates from before 1999 and
7.23 from around 1995/1996.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Tue, Jun 11, 2013 at 10:34 AM, LUKE MORGAN <lukemorgan@eaton.com> wrote:

> Hi,
>
> I have backed up an instance of Informix 7.23.UC7 using ontape.
>
> I am attempting to restore this to another server that is running Informix
> 7.31.FD8
>
> These are legacy servers without current support.
>
> I have recreated the DBspaces on the newer server, all the same sizes.
> When using ontape -r, after taking Informix offline, I get the following :
> "Archive Tape Information
>
> Tape type: Archive Backup Tape
> Online version: INFORMIX-OnLine Version 7.23.UC7
> Archive date: Wed May 29 09:38:51 2013
> User id: root
> Terminal id: /dev/ttyp3
> Archive level: 0
> Tape device: /dev/rmt/0m
> Tape blocksize (in k): 128
> Tape size (in k): 12000000
> Tape number in series: 1
>
> Spaces to restore:1 [rootdbs ]
> 2 [plogdbs ]
> 3 [llogdbs ]
> 4 [temp1dbs ]
> 5 [temp2dbs ]
> 6 [temp3dbs ]
> 7 [temp4dbs ]
> 8 [data1dbs ]
> 9 [edi_dbs ]
>
> Archive Information
>
> INFORMIX-OnLine Copyright(C) 1986-1995 Informix Software, Inc.
> Initialization Time 03/22/1999 14:50:21
> System Page Size 2048
> Version 4
> Archive CheckPoint Time 05/29/2013 09:38:51
> Memory fault"
>
> I cannot find anything in online.log or the syslog to explain what the
> problem
> is, and I'm unsure what is meant by memory fault in this context.
> Informix starts and stops ok, and I have done ontape -s to /dev/null after
> creating the dbspaces.
>
> I would appreciate any help or advice, or if someone can point out whether
> or
> not it is even possible to restore from v7.23 to v7.31
>
> Thank you!
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--001a11c2675cf0c93604dee20982

Messages In This Thread

• ontape -r Memory Fault
  LUKE MORGAN -- Tuesday, 11 June 2013, at 10:34 a.m.
  • Re: ontape -r Memory Fault
    Clifton Bean -- Tuesday, 11 June 2013, at 10:42 a.m.
    • Re: ontape -r Memory Fault
      LUKE MORGAN -- Tuesday, 11 June 2013, at 10:50 a.m.
      • Re: ontape -r Memory Fault
        Art Kagel -- Tuesday, 11 June 2013, at 10:56 a.m.
        • Re: ontape -r Memory Fault
          Marcus Haarmann -- Tuesday, 11 June 2013, at 11:05 a.m.
      • Re: ontape -r Memory Fault
        Art Kagel -- Tuesday, 11 June 2013, at 11:01 a.m.
      • Re: ontape -r Memory Fault
        Marcus Haarmann -- Tuesday, 11 June 2013, at 11:08 a.m.
  • Re: ontape -r Memory Fault
    Art Kagel -- Tuesday, 11 June 2013, at 10:52 a.m.
    • Re: ontape -r Memory Fault
      LUKE MORGAN -- Tuesday, 11 June 2013, at 11:01 a.m.
      • Re: ontape -r Memory Fault
        Art Kagel -- Tuesday, 11 June 2013, at 11:32 a.m.
        • Re: ontape -r Memory Fault
          LUKE MORGAN -- Tuesday, 11 June 2013, at 11:36 a.m.
          • Re: ontape -r Memory Fault
            Art Kagel -- Tuesday, 11 June 2013, at 12:17 p.m.
          • Re: ontape -r Memory Fault
            Hrvoje Zokovic -- Tuesday, 11 June 2013, at 12:44 p.m.
            • Re: ontape -r Memory Fault
              Art Kagel -- Tuesday, 11 June 2013, at 12:52 p.m.
              • Re: ontape -r Memory Fault
                Marcus Haarmann -- Wednesday, 12 June 2013, at 2:33 a.m.
        • Re: ontape -r Memory Fault
          Hrvoje Zokovic -- Tuesday, 11 June 2013, at 12:46 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.