International Informix Users Group

	Informix News

16 October 08 - VendorRate - Informix Earns Top Customer Satisfaction Score on VendorRate in Q3... Read 14 August 08 - IIUG.org - Sellout Expected for the 2009 IIUG Informix Conference... Read 29 April 08 - IntelligentEnterprise.com - IBM Informix Upgrade Enhances Clustering, Database Management... Read 29 April 08 - itweek.com - IBM 'Cheetah 2' mauls data costs... Read 28 April 08 - eWeek.com - IBM Uncages Cheetah 2 Data Server... Read 28 April 08 - CNNMoney.com - IBM Helps Clients Reduce Data Management Costs With New Informix Dynamic Server... Read 09 April 08 - CNNMoney.com - MediaSpan Embeds IBM Informix Dynamic Server Software for Delivering News to Print, Web and Wireless Devices... Read 08 April 08 - IT-Director.com - Informix seeks developers... Read 18 February 08 - marketwire.com - Icarus Studios Partners With IBM to Upgrade Performance, Availability for Its Online Games... Read 17 January 08 - eWeek.com - IBM Adds Mac Support to IDS for Higher Education... Read 17 January 08 - informationweek.com - Lotus Notes For iPhone Signals Closer Ties Between IBM, Apple... Read 16 January 08 - marketwire.com - IBM Informix Dynamic Server to Deliver Support for Mac OS X... Read 16 January 08 - internetnews.com - IBM's IDS to Support Mac Platform... Read 28 June 07 - REG Developer - IBM and Informix tie down Cheetah... Read 27 June 07 - CBRonline.com - IBM corrects its own Informix customer figures... Read 14 June 07 - vnunet.com - IBM changes spots with Informix 'Cheetah' database... Read 14 June 07 - eChannelLine - IBM expands scope for IDS... Read 14 June 07 - Resellernews - IBM: Informix database alive and kicking... Read 13 June 07 - DB2 Magazine - Cheetah is now out of the gate... Read 12 June 07 - IBM - IDS 11 release announcement (pdf)... Read 12 June 07 - ChannelWeb Network - IBM Uncages IDS 11, Aka Cheetah, Database... Read 12 June 07 - eWeek.com - IBM's 'Cheetah' Ready to Pounce... Read 12 June 07 - InformationWeek - IBM Unleashes 'Cheetah' Database... Read 12 June 07 - WebWire - IBM Strengthens Database Portfolio With New Informix Dynamic Server... Read 12 June 07 - Intelligent Enterprise - IBM Unveils Informix Upgrade... Read 12 June 07 - ComputerWeekly.com - IBM's Cheetah IDS makes leap to better data centre clustering... Read 12 June 07 - ebiz - IBM Unveils Next Generation Informix Dynamic Server... Read 12 June 07 - computerworld.com - Will 'Cheetah' help IBM's Informix chase down market share?... Read 12 June 07 - Internetnews.com - No Data Can Outrun This 'Cheetah'... Read 12 June 07 - de.internet.com - IBM neuer Datenbank-Server mit Codenamen Cheetah ist fertig... Read 12 June 07 - verifox.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - golem.de - Informix 11 vorgestellt... Read 12 June 07 - Computerwoche.de - IBM stellt neue Informix-Version vor... Read 12 June 07 - IBM.de - IBM stärkt Datenbank-Portfolio mit neuem Informix Dynamic Server... Read 12 June 07 - Heise - IBM gibt Informix 11 frei... Read 25 May 07 - Taiwan.CNET.com - Local Taiwan Informix user group established... (Chinese language) ... Read 18 May 07 - ChannelWeb Network - IBM Musters Partners For Cheetah Release... Read 18 May 07 - eWeek.com - IBM Looks to 'Cheetah' to Speed Up Blade Servers... Read 7 May 07 - DB2 Magazine - SQL Shortcuts - Use these tricks to generate IDS SQL scripts... Read Previous news items

Home Member Area About IIUG

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum

RE: Informix 7.3 restore question.

Posted By: Don Cutting
Date: Wednesday, 22 January 2003, at 10:03 a.m.

In Response To: Informix 7.3 restore question. (Don Cutting )

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2C227.37845E10
Content-Type: text/plain

Martin,

Thanks for the information. We contacted IBM Informix support and
they pretty much noted the same. We checked a number of things and
everything looked fine - no errors in our logs and the restore log noted
that all spaces were restored with no errors. We made the call to refresh
the DR system at the AIX level and tried the restore again, and this time
it worked fine. Our system staff is now in the process of checking to see
what was done different between the two times they loaded the AIX level
software. We had a staff change in that area, so we are expecting that
something in the DR document was not followed.

Again, thank you for your response and have a good day!

Thanks!

Donald H. Cutting
A. N. Deringer, Inc.
Systems Analyst / D.B.A.
Tel : 802-524-8172
Fax: 802-524-8297
www.anderinger.com

> -----Original Message-----
> From: Martin Fuerderer [SMTP:martinfu@de.ibm.com]
> Sent: Wednesday, January 22, 2003 9:46 AM
> To: Don Cutting
> Cc: forum.subscriber@iiug.org; ids@iiug.org
> Subject: Re: Informix 7.3 restore question. [62]
>
> Hi,
>
> this should not happen.
> Temp dbspaces that existed BEFORE the archive was done
> should (automatically) be re-created during/after the restore.
> They are re-created and not restored (since they are not archived).
>
> I admit that I didn't try out this scenario with a whole-system
> archive and restore in 7.3 for quite some time. I don't think
> that this is a known problem, at least I can't find any.
>
> Any error message about these temp dbspaces in either online.log
> or in bar_act.log file ? There could be a hint as to why this happened ...
>
> [ Path names must be exactly the same on system to be restored.
> Chunk files must exist prior to starting the restore, owner/group both
> "informix", access rights -rw-rw---- (660). I assume you've got these
> things right ... ]
>
> In case all this doesn't help/work, more information is needed :
> - "onstat -d" output of archived system,
> - ls -l of chunks pathnames on restore system,
> - log files of the "critical times" during archive and restore,
> - exact version (oninit -V),
> - OS name / version.
>
> Regards,
> Martin
> --
> Martin Fuerderer
> IBM Informix Development Munich
> Data Management Solutions
>
>
>
>
>
> "Don Cutting " <dcutting@anderinger.com>
> Sent by: forum.subscriber@iiug.org
> 21.01.2003 20:46
>
> To: ids@iiug.org
> cc:
> Subject: Informix 7.3 restore question. [62]
>
>
>
>
> We are testing our restore on our DR system. We use onbar and used onbar
> -r
> -w for the restore option. When we try to bring the server online, it
> errors
> out noting it can find the two dbspaces which are marked as temp. We know
> that temp dbspaces do not restore, the chunks were created on the DR
> system,
> but for some reason the informix server is not seeing them. We have done
> this before and not had this issue.
>
> Any thoughts on why this might be occuring? We are going to recreate the
> chunks and see if that helps.
>
> Thanks
>
> Donald H. Cutting
> A. N. Deringer, Inc.
> Systems Analyst / D.B.A.
> Tel : 802-524-8172
> Fax: 802-524-8297
> www.anderinger.com

------_=_NextPart_001_01C2C227.37845E10
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: Informix 7.3 restore question. [62]</TITLE>
</HEAD>
<BODY>

Martin,


        Thanks for the information. We contacted IBM =
Informix support and they pretty much noted the same. We checked a =
number of things and everything looked fine - no errors in our logs and =
the restore log noted that all spaces were restored with no errors. We =
made the call to  refresh

 the DR system =
at the AIX level and tried the restore again, and this time it worked =
fine. Our system staff is now in the process of checking to see what =
was done different between the two times they loaded the AIX level =
software. We had a staff change in that area, so we are expecting that =
something in the DR document was not followed.

        Again, thank you for your response and have a =
good day!


Thanks!


       =20


       =20


Donald H. Cutting
 A. N. Deringer, Inc. 
 Systems Analyst / D.B.A.
 Tel : 802-524-8172
 Fax: 802-524-8297
 www.anderinger.com

<UL>
-----Original Message-----
 From:   Martin Fuerderer =
[SMTP:martinfu@de.ibm.com]
 Sent:   Wednesday, January 22, 2003 9:46 AM
 To:     Don Cutting 
 Cc:     forum.subscriber@iiug.org; ids@iiug.org
 Subject:       =
 Re: Informix 7.3 restore question. =
[62]


Hi,


this should not happen.
 Temp dbspaces that existed BEFORE the =
archive was done
 should (automatically) be re-created =
during/after the restore.
 They are re-created and not restored =
(since they are not archived).


I admit that I didn't try out this =
scenario with a whole-system
 archive and restore in 7.3 for quite =
some time. I don't think
 that this is a known problem, at =
least I can't find any.


Any error message about these temp =
dbspaces in either online.log
 or in bar_act.log file ? There could =
be a hint as to why this happened ...


[ Path names must be exactly the same =
on system to be restored.
   Chunk files must exist prior =
to starting the restore, owner/group both
   "informix", access =
rights -rw-rw---- (660). I assume you've got these
   things right ... ]


In case all this doesn't help/work, =
more information is needed :
 - "onstat -d" output of =
archived system,
 - ls -l of chunks pathnames on =
restore system,
 - log files of the "critical =
times" during archive and restore,
 - exact version (oninit -V),
 - OS name / version.


Regards,
 Martin
 --
 Martin Fuerderer
 IBM Informix Development =
Munich
 Data Management Solutions

 
 
 
 

"Don Cutting " =
<dcutting@anderinger.com>
 Sent by: =
forum.subscriber@iiug.org
 21.01.2003 20:46
  
         =
To:     ids@iiug.org
         cc: 
         =
Subject:        Informix 7.3 restore =
question. [62]


 

 

We are testing our restore on our DR =
system. We use onbar and used onbar 
 -r
 -w for the restore option. When we =
try to bring the server online, it 
 errors
 out noting it can find the two =
dbspaces which are marked as temp. We know
 that temp dbspaces do not restore, =
the chunks were created on the DR 
 system,
 but for some reason the informix =
server is not seeing them. We have done
 this before and not had this issue. =



Any thoughts on why this might be =
occuring? We are going to recreate the
 chunks and see if that helps.


Thanks


Donald H. Cutting
 A. N. Deringer, Inc. 
 Systems Analyst / D.B.A.
 Tel : 802-524-8172
 Fax: 802-524-8297
 www.anderinger.com

</UL>
</BODY>
</HTML>
------_=_NextPart_001_01C2C227.37845E10--

Messages In This Thread

Informix 7.3 restore question.
Don Cutting -- Tuesday, 21 January 2003, at 2:46 p.m.
- Re: Informix 7.3 restore question.
  Martin Fuerderer -- Wednesday, 22 January 2003, at 9:50 a.m.
- RE: Informix 7.3 restore question.
  Don Cutting -- Wednesday, 22 January 2003, at 10:03 a.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

IDS Forum is maintained by Administrator with WebBBS 5.12.