f



RE: Mirror / Raw device / Informix

This is a multi-part message in MIME format.

------_=_NextPart_001_01C6153D.0A4774A2
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Muthana-

          In order to use redundant drives on your server: in your
onconfig file, change MIRROR     0 to MIRROR   1, then bounce your
database.  You may then use onspaces -m to mirror your dbspaces.  Read
the manual first.  For replication across servers, Informix has built in
high availability data replication (master - slave only) and enterprise
replication (can be configured in many different ways).  Both are free
in enterprise edition.  High availability requires an additional license
for workgroup edition.  Enterprise replication is not allowed in
workgroup edition.

          For documentation, see:
http://www.ibm.com/software/data/informix/pubs/library

=20

                                                          --EEM

=20

-----Original Message-----
From: Muthana.AL-Temimi@tu-harburg.hamburg.de
[mailto:Muthana.AL-Temimi@tu-harburg.hamburg.de]=20
Sent: Monday, January 09, 2006 10:06 AM
To: informix-list@iiug.org
Cc: m.al@tuhh.de
Subject: Mirror / Raw device / Informix

=20

Dear IIUG,

=20

I would like to ask if I can do a mirror of my database which is
installed on raw device into the 2 server by using mirror technology.

I heart that this solution won't work with Informix but I'm not sure
therefore I asked the question on IIUG.

=20

Is there any tool by Informix can help me to mirror the database of my
raw device?

Are there anyway to build redundant system for my database server?

=20

I used Informix 10.0 and as OS Suse Enterprice Linux Sever 9=20

Any help will be grateful

=20

Regards,

Muthana AL-Temimi


------_=_NextPart_001_01C6153D.0A4774A2
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:"Comic Sans MS";
	panose-1:3 15 7 2 3 3 2 2 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.emailformatvorlage17
	{font-family:Arial;
	color:windowtext;}
span.EmailStyle18
	{font-family:"Comic Sans MS";
	color:blue;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
@page Section1
	{size:595.3pt 841.9pt;
	margin:70.85pt 70.85pt 56.7pt 70.85pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D3 color=3Dblue face=3D"Comic Sans =
MS"><span
style=3D'font-size:12.0pt;font-family:"Comic Sans =
MS";color:blue'>Muthana-</span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblue face=3D"Comic Sans =
MS"><span
style=3D'font-size:12.0pt;font-family:"Comic Sans =
MS";color:blue'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
In
order to use redundant drives on your server: in your onconfig file, =
change
MIRROR&nbsp;&nbsp;&nbsp;&nbsp; 0 to MIRROR&nbsp;&nbsp; 1, then bounce =
your
database.&nbsp; You may then use onspaces &#8211;m to mirror your =
dbspaces.&nbsp;
Read the manual first.&nbsp; For replication across servers, Informix =
has built
in high availability data replication (master &#8211; slave only) and
enterprise replication (can be configured in many different ways).&nbsp; =
Both
are free in enterprise edition.&nbsp; High availability requires an =
additional
license for workgroup edition.&nbsp; </span></font><font color=3Dblue
  face=3D"Comic Sans MS"><span style=3D'font-family:"Comic Sans =
MS";color:blue'>Enterprise</span></font><font
color=3Dblue face=3D"Comic Sans MS"><span style=3D'font-family:"Comic =
Sans MS";
color:blue'> replication is not allowed in workgroup =
edition.</span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblue face=3D"Comic Sans =
MS"><span
style=3D'font-size:12.0pt;font-family:"Comic Sans =
MS";color:blue'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
For
documentation, see: <a
href=3D"http://www.ibm.com/software/data/informix/pubs/library">http://ww=
w.ibm.com/software/data/informix/pubs/library</a></span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblue face=3D"Comic Sans =
MS"><span
style=3D'font-size:12.0pt;font-family:"Comic Sans =
MS";color:blue'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblue face=3D"Comic Sans =
MS"><span
style=3D'font-size:12.0pt;font-family:"Comic Sans =
MS";color:blue'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
--EEM</span></font></p>

<p class=3DMsoNormal><font size=3D3 color=3Dblue face=3D"Comic Sans =
MS"><span
style=3D'font-size:12.0pt;font-family:"Comic Sans =
MS";color:blue'>&nbsp;</span></font></p>

<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0in 0in =
0in 4.0pt'>

<p class=3DMsoNormal><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b>
Muthana.AL-Temimi@tu-harburg.hamburg.de
[mailto:Muthana.AL-Temimi@tu-harburg.hamburg.de] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> </span></font><font =
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>Monday, January
 09, 2006</span></font><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma'> </span></font><font size=3D2 face=3DTahoma><span
 style=3D'font-size:10.0pt;font-family:Tahoma'>10:06 =
AM</span></font><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> </span></font><font =
size=3D2
 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>informix-list@iiug.org</spa=
n></font><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> m.al@tuhh.de<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Mirror / Raw =
device /
Informix</span></font></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DDE =
style=3D'font-size:10.0pt;
font-family:Arial'>Dear IIUG,</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DDE =
style=3D'font-size:10.0pt;
font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>I would like to ask if I can do a mirror of my
database which is installed on raw device into the 2 server by using =
mirror
technology.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>I heart that this solution won&#8217;t work =
with
Informix but I&#8217;m not sure therefore I asked the question on =
IIUG.</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>Is there any tool by Informix can help me to =
mirror
the database of my raw device?</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>Are there anyway to build redundant system for =
my
database server?</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>I used Informix 10.0 and as OS Suse Enterprice =
Linux
Sever 9 </span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>Any help will be grateful</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>Regards,</span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-GB =
style=3D'font-size:
10.0pt;font-family:Arial'>Muthana AL-Temimi</span></font></p>

</div>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C6153D.0A4774A2--
0
Everett
1/9/2006 4:52:13 PM
comp.databases.informix 16083 articles. 0 followers. Post Follow

0 Replies
366 Views

Similar Articles

[PageSpeed] 23

Reply:

Similar Artilces:

Mirror / Raw device / Informix
This is a multi-part message in MIME format. ------_=_NextPart_001_01C61536.8C8CD89C Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Dear IIUG, =20 I would like to ask if I can do a mirror of my database which is installed on raw device into the 2 server by using mirror technology. I heart that this solution won't work with Informix but I'm not sure therefore I asked the question on IIUG. =20 Is there any tool by Informix can help me to mirror the database of my raw device? Are there anyway to build redundant system for my database server? =20 I used Informix 10.0 and as OS Suse Enterprice Linux Sever 9=20 Any help will be grateful =20 Regards, Muthana AL-Temimi ------_=_NextPart_001_01C61536.8C8CD89C Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable <html> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Dus-ascii"> <meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)"> <style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0cm; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline;} span.Ema...

How to copy a sun-database in one informix database to another informix database?
Hi, Sorry I am not an informix dba, and I was faced to copy a sub-database(sorry I don't know the clear name of such concept, as informix is like sql-server, which used multiple database) from one informix database system to another informix database. I know in oracle, we can use transportable tablespace, copy the datafile and transport the metadata, and do something else. How can I do it in informix then? Is there document which talk about the detail step? Thanks It would really help if you knew the versions of the Informix databases. Assuming Informix IDS 7.x or IDS...

AW: Mirror / Raw device / Informix
Art Kagel wrote:=20 >=20 > There are better solutions however. As hinted by others,=20 > Informix provides=20 > two levels of database replication that can be used to=20 > maintain a secondary=20 > server which is either a hot backup system for failovers only=20 > or which is=20 > indeed a live server which can be accessed anytime with=20 > up-to-date data. >=20 > These are respectively known as HighAvailability Data=20 > Replication (HDR) and=20 > Enterprise Replication (ER). Neither uses OS or disk vendor=20 > services for=20 > replication. =20 There is a third option, you may use the perpetual restore method=20 where you keep a secondary instance in logical recovery mode=20 and constantly feed logical logs with onbar as the get produced=20 on the production side. (relies on the imported restore and=20 the fact that IDS can suspend logical recovery after a failure to=20 retrieve an object from the storage manager. The method has been developed by Bob Weiman (a former 3rd level support engineer at Informix),=20 and is described in a Technote available at http://www.ibm.com/support/docview.wss?rs=3D630&context=3DSSGU8G&q1=3Dper= petua l+restore&uid=3Dswg21210590&loc=3Den_US&cs=3Dutf-8&lang=3Den Regards Tilman=20 What happens whihlst you are doing this the machine is rebooted e.g. hardware failure, panic, power failure? When IDS (+possibly ISM) restart what happe...

RE: [Informix][Informix ODBC Driver] Database locale information mismatch
You could try issuing the following statement and see what the engine is configured for. onstat -g env This will give you the environment of the engine. I believe it is listed there what the locale is set to. David -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of bobkot@gmail.com Sent: Tuesday, May 23, 2006 7:28 AM To: informix-list@iiug.org Subject: [Informix][Informix ODBC Driver] Database locale information mismatch I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environment, and I cannot find any matching pairs. Can somebody help. XP client and Linux server _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Version 10.00.UC4E is what I am running. How do I determine what the database was created with ? I have no customer support - that is me - so where to for the patches ? Would that be for the IDS or the SDK This is a multipart message in MIME format. --=_alternative 0023D97D65257178_= Content-Type: text/plain; charset="US-ASCII" To find out what's the database locale in your environment go to the server in...

RE: Relocate Informix database from Raw slices to filesystem
In the past we have used Informix's internal mirroring capabilities to move to new disk arrays. This should also work to move from raw to cooked disks. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of mccmx@hotmail.com Sent: Monday, October 17, 2005 9:26 AM To: informix-list@iiug.org Subject: Relocate Informix database from Raw slices to filesystem Is there any way I can relocate my IDS 7.31 database from its raw slices to the local filesystem...? I can 'dd' the slices to files easily, but I need a w...

Re: Relocate Informix database from Raw slices to filesystem #2
Why pay someone ??? It's a trivial task On 10/17/05, Neil Truby <neil.truby@ardenta.com> wrote: > > <mccmx@hotmail.com> wrote in message > news:1129561344.240798.314750@g49g2000cwa.googlegroups.com... > > Thats sounds promising. > > > > So effectively add a mirrored chunk to each dbspace using onspaces and > > then drop the original chunk. > > > > Can you do this for the rootdbs dbspace too...? > > > > Matt > > > > If it's a production system you might be better off paying someone who &...

RE: Relocate Informix database from Raw slices to filesystem #5
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of mccmx@hotmail.com Sent: Tuesday, October 18, 2005 3:59 AM To: informix-list@iiug.org Subject: Re: Relocate Informix database from Raw slices to filesystem Funnily enough, your idea to create a soft link in /dev from the old device to the new device/location is exactly what I was planning to do if I couldn't find a 'better' solution. Based on this thread, I may well have to go down that route... My Informix knowledge is very limited....!?! What I wil...

Re: Relocate Informix database from Raw slices to filesystem #4
True there are issues but it's a easy solution to the problem, gets round the 'can not rename chunks' issue, no need to hassle about mirroring etc But the original post said going to internal disks so there will not be a name clash. On 10/17/05, Paul Watson <pwatson@irace.com> wrote: > > On 17 Oct 2005 15:26:36 -0700, david@smooth1.co.uk <david@smooth1.co.uk> > wrote: > > > > > > Paul Watson wrote: > > > If the device is 'not going to exist anymore' why not dd the data from > > the > > >...

Re: Relocate Informix database from Raw slices to filesystem #3
If the device is 'not going to exist anymore' why not dd the data from the old slice to the internal disk and then just link the 'not going to exist anymore device' to the new location On 10/17/05, Fernando Nunes <spam@domus.online.pt> wrote: > > Clive Eisen wrote: > > mccmx@hotmail.com wrote: > > > >> > >> I don't neccesarily need to move them off raw slices, but I do need to > >> move them to different slices. This is because I am moving the > >> database from SAN storage to internal disks... So...

informix databases (dbaaccess)(Informix-SE)
How to get the informix databases. i tried to get from net but i didnot get . the ibm site is asking for password. how can we get it . i am asking this because we can de database acess from unix shell scrpting using informix databses. do any one know how to install and download the dbaaccess or informix SE. uday <kariudaykiran@yahoo.co.in> wrote: > How to get the informix databases. i tried to get from net but i didnot > get . the ibm site is asking for password. Type your password. > how can we get it . i am asking this because we can de database acess > from unix shell ...

RE: Do I have to have an Informix Database?
Bruce, You have to buy a database from somewhere. But 4Js and Querix offer versions of the Informix-4GL compiler that will work with other databases. I think they both give the choice between Informix and Oracle, and I think DB2. But visit their web-sites to find out the latest info. Their compilers also work on Windows or UNIX thereby giving even more flexibility. Malcolm -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Bruce Truter Sent: 15 February 2004 03:36 To: informix-list@iiug.org Subject: Do I have ...

RE: [Maybe Spam] Re: Informix device permissions after SuSE reboot
-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Art S. Kagel Sent: Friday, June 25, 2004 6:07 PM To: informix-list@iiug.org Subject: [Maybe Spam] Re: Informix device permissions after SuSE reboot On Fri, 25 Jun 2004 08:08:07 -0400, Neil Truby wrote: > "Doug Lawry" <lawry@nildram.co.uk> wrote in message > news:cbh1po$lis$1@nntp0.reith.bbc.co.uk... >> On Suse 2.4.19, we also had to add a "chown" command to: >> >> /etc/init.d/boot.l...

RE: [Maybe spam] Re: Relation of OS user to Informix database
Jonathan... am I correct in thinking that you can't revoke rights from a user who has those rights because they're a member of public? Ie, if they don't have the rights assigned with an explicit GRANT statement, then you can't revoke their rights without revoking public's rights and then granting permissions to all other users individually? Cheers Simon -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: 25 August 2005 05:24 To: informix-list@iiug.org Subject: [Maybe sp...

RE: [Maybe spam] Re: Relation of OS user to Informix database #2
You can only revoke a privilege that exists explicitly and you are the GRANTOR, if a user's rights are part of "public" then you cannot prevent the access unless you revoke connection privileges from public Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Gosney Simon" <GosneyS@axxia.com> >To: "Jonathan Leffler" <jleffler@earthlink.net>, <informix-list@iiug.org> >Subject: RE: [Maybe spam] Re: Relation of OS user to Informix databas...

RE: Informix database creation
The Raw device of 17Gb will not be useful to you on 7.31.FD6. You need to create then at 2Gb (maximum sizes are listed in your release notes), or upgrade to 9.40. Check onstat -d again...it suggests you have successfully created that dbspace and are trying to create it again. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Seweryn > Sent: Thursday, 7 August 2003 7:57 a.m. > To: informix-list@iiug.org > Subject: Informix database creation > > > Hi all, > > I'm ...

RE: Rowids in Informix Databases
Vijay All the tables will have rowids (they must !!), they are not visible on a normal table view but can be returned by query. If a table is fragmented (but only if (v7.31) ) it can be created WITH ROWIDS which will create a separate rowid column. Why do you need rowids? They tend to be a fudge to cover up poor or inadequate database design. Don't you have lots of lovely, simple (single column) primary keys to use to identify your records. Keith=20 -> -----Original Message----- -> From: Vijay Kumar [mailto:rudrappa@india.hp.com] -> Sent: Tuesday, October 12, 20...

Re: Start informix database
May be you have more than one Informix's instances and your missed database was not created in the instance where you are looking for it. Send us the content of your sqlhosts file and the result of : echo $INFORMIXSERVER Regards ----- Original Message ----- From: "madiego" <madiego@qf21.com> To: <informix-list@iiug.org> Sent: Tuesday, August 03, 2004 1:04 PM Subject: Start informix database > Hello, > > I had an informix database in the unix server. The server has been > restarted and now I can't start the database. &...

Re: Difference between Informix connect and Informix Client SDK
Informix-connect holds the runtime libraries which will allow you to connect to the database ..so if you have ESQL/C binaries, you can just put Informix-connect on the server and run the binaries. But, if you want to build the binary then you will have to use CSDK ... As for pricing, I think both are free and can be downloaded from the IBM site. Thanx much, Rajib Sarkar Advisory Support Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi ...

Re: Informix Upgrade Optons for an ancient Informix system
There is an open source Informix compatible 4GL - if you're interested... (It also works quite well with Postgres :-) On Wednesday 13 July 2005 12:18, Data Goob wrote: > scottishpoet wrote: > > Might be able to get a Linux/Informix package deal from IBM. They were > > running some prgrammes toward the end of last year, not sure if they > > are still running. > > Thanks, > > I'll ask my IBM reseller, who is right down the street. Very surprised > to see the pricing for 4GL, I would have expected this to go Open Source > by now,...

Re: Informix mirroring [6769]
<Also posted to IIUG Forum> OH I CAN'T RESIST! Informix mirroring OVER RAID5? Do you have a death wish? NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! NO RAID5!!! This is bad on SO many levels. OK, first issue, if you ARE using Informix mirroring, the only one side of the mirror will have been trashed when the array crashed. You should only have to tell IDS to recover the failed mirror from the remaining member by dropping either the primary or the mirror chunk(s) (whichever one failed) and then adding back the replacement mirror segment(s) using onspaces. If you have both sides of the mirror on the same failed array, well that's just foolish and you deserve to lose your data. (Not to be cruel, but ...) Finally, you should not be mirroring over RAID5. RAID5 is inherently UNSAFE AT ANY SPEED, besides being slow, and adding mirroring just adds overhead without much additional safety. The RAID5 underneath is undermining the safety of the mirror. If you want to mirror but also want the additional performance of a stripe, then either mirror at the Informix level from RAID0 (stripe only) arrays (which amounts to a RAID01 array in practice), or better yet, set up an OS or VM level RAID10 array and do away with the Informix mirroring. The RAID10 array will tend to be about 10% faster than Informix mirroring of RAID0 arrays, much faster to recover from a down drive, and less likely to lose all of your data. Y...

FW: RE: Informix IDS query to the Informix -list
Fwd from sputnik� ________________________________________ From: None [mailto:myinformix@rediffmail.com] Sent: Tuesday, September 14, 2004 02:08 To: Jean Georges Perrin Subject: Re: RE: Informix IDS query to the Informix -list � Hi Jean, Thank you for your prompt reply. If you can please publish the following request in informix-list@iiug.org where all our Informix gurus are roaming. I am a registered user at iiug an it was my first attempt to publish anything. Please let me know if this is not possible for you to publish in the above list. Thank you very much. Sputnik...

Re: Benchmarking for Informix database
Peter Chang said: > > I was wondering if there are any benchmarking tool that I can use to > calculate TPM of an Informix database on a particular server? I seem to recall that it's possible to download the TPC benchmarks from www.tpc.org ...? But the best benchmark is your own application and something like a load runner robot. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH &qu...

[Informix][Informix ODBC Driver] Database locale information mismatch
I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environment, and I cannot find any matching pairs. Can somebody help. XP client and Linux server This is a multipart message in MIME format. --=_alternative 0046812965257177_= Content-Type: text/plain; charset="US-ASCII" I am guessing that you are using 10.00.xC4 or the version where you have fix for 171156 IDS defect. Basically this bug fix will enforce the correct database locale setting from client (i.e. ODBC etc). If you supply the (default is en_US.1252) correct database locale(that is actually the database created with) in ODBC DSN(or your connection string) then your connection should go through. However in ODBC side as well we have the corresponding fix in place. Ask your customer support to get the patch of ODBC defects 175110 and 175746. These ODBC fixes will automatically take care of getting the correct database locale value for the given database (through DSN). Thanks & Regards -Shesh bobkot@gmail.com Sent by: informix-list-bounces@iiug.org 05/23/2006 05:58 PM To informix-list@iiug.org cc Subject [Informix][Informix ODBC Driver] Database locale information mismatch I have download ClientSDK 2.90.T...

Re: Difference between Informix connect and Informix Client SDK #2
Hi Francisco. Client SDK is a developer's kit. You can create and compile program using ESQL/C (it is bundled.) Connect is a runtime of Client SDK. HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Francisco Roldan <froldan@5b.com.gt> >To: informix-list@iiug.org >Subject: Difference between Informix connect and Informix Client SDK >Date: Tue, 8 Jul 2003 12:18:35 -0600 > >Does Somebody would tell me the difference between >those Informix products? > >And the estimated cost of each one (for Linux) ? > >...

Web resources about - RE: Mirror / Raw device / Informix - comp.databases.informix

IBM Informix - Wikipedia, the free encyclopedia
IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system ...

IBM Informix (@IBM_Informix) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Informix - News, Features, and Slideshows
Latest news, features, and slideshows on Informix from Computerworld

Informix Database Administrator / Developer
Defining Technology for Australia's IT Leaders.

Informix technology whiz bails out for Andromedia
San Francisco, CA News - View Daily Local Business News, Resources & more in San Francisco, California. Informix, the Menlo Park-based database ...

S&P Stock Reports: Informix Corp.
Revenues in the first quarter of 1997 declined over 30%, owing to sluggishness associated with product transition uncertainties stemming from ...

Informix says Oracle is "sleazy"
... A CNET article by CNET News.com Staff, . Published on January 24, 1997 12:30 PM PST. No love has ever been lost between database makers Informix ...

IBM Acquires Informix
IBM took a major step today in its effort to strengthen its software business and take down Oracle by agreeing to acquire Informix Software's ...

The Four HundredIBM Buys Other Half of Informix with Ascential Acquisition
IBM Buys Other Half of Informix with Ascential Acquisition by Timothy Prickett Morgan Four years ago, in April 2001 to be precise, IBM bought ...

IBM's Informix buya billion dollars worth of benefit?
So IBM is buying Informix Software, Informix Corp.'s database unit and the heart of the company.

Resources last updated: 2/29/2016 8:04:58 AM