f



RE: [Info-ingres] Ingres 2.6 on Solaris #2

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_01C6046F.26610010
Content-Type: text/plain;
	charset="ISO-8859-2"
Content-Transfer-Encoding: quoted-printable

Solaris 2.6
II 2.6/0305 (su4.us5/00)
Patch 10402=20
=20
No unplanned downtime in last 6 months ;-))
(Last downtime I have recorded is from 2004, but I could miss =
something. 6
months for sure.)

Regards,
Artur Fajok



  _____ =20

From: Gareth Williams [mailto:Gareth.Williams@bromor-tr.wales.nhs.uk]=20
Sent: Friday, December 16, 2005 5:30 PM
To: info-ingres@cariboulake.com
Subject: RE: [Info-ingres] Ingres 2.6 on Solaris



We have 2.6 on solaris 9 our current levels...=20

II 2.6/0305 (su9.us5/00) 64bit!=20
11090=20


This is running an old ABF application (500 users), 24hrs a day. We =
also
have a "modern" version of the app that runs via ODBC from ASP.net.

Downtime so far has been mainly down to bugs - for example stack =
overflow on
large SQLs, case statement in wrong part of SQL crashes the IIDBMS =
instead
of returning a syntax error. We've also had to back out of patches that =
have
broken other things.

We do have some locking issues - but I think this is mainly down to our
buggy applications.=20

Our downtime stats last few months...=20

Sept 2005 - 159mins (planned maintenance)=20
Oct 2005 - 399mins (unplanned caused by bug)=20
Nov 2005 - none=20
Dec 2005 - none - touch wood.=20

I think configuration is the key - get some CA training as the docs and
config tools aren't very helpful.=20

out of interest - what's your current platform?=20

Cheers=20

Gareth=20


-----Original Message-----=20
From: moab88@emirates.net.ae [mailto:moab88@emirates.net.ae
<mailto:moab88@emirates.net.ae> ]=20
Sent: 13 December 2005 14:08=20
To: info-ingres@cariboulake.com=20
Subject: [Info-ingres] Ingres 2.6 on Solaris=20


We are planning to migrate a critical highly concurrent Ingres II=20
database to 2.6 on Solaris. Does anyone know of any major major issues=20
in 2.6 on Solaris.  The application can afford no downtime and requires =

a  true 24 X 7 environment.=20

Any feedback (good and not so good) will be helpful in helping us move=20
forward.  We have had major issues with 2.6 on a different platform=20
where sessions get stuck in any of the following states (COM, LOG,=20
LKEVENT, <any>) and we are not able to remove them.  If they are=20
holding locks then we must shutdown/startup, if they have an open=20
transaction, then the transaction log keeps on increasing until we=20
shutdown, if none of the above, the server would hang after sometime.=20

Feedback on Solaris release/patches, Ingres release level and patches,=20
any special configuration settings, etc.  would also help.=20

Nabil Courdy=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=20

_______________________________________________=20
Info-ingres mailing list=20
Info-ingres@cariboulake.com=20
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
<http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres> =20




Cymraeg:-=20
Mae'r neges hon yn gyfrinachol.Os nad chi yw'r derbynnydd y bwriedid y =
neges
ar ei gyfer, byddwch mor garedig =E2 rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu =
sylwadau a
wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o=20
eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol =
ohoni na
chorff cysylltiedig.

Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i =
Ymddiriedolaeth
GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu=20
ohebiaeth a dderbynnir, yn unol ag amodau'r Ddeddf Rhyddid Gwybodaeth =
2000.
I gael mwy o wybodaeth am Ryddid Gwybodaeth, cofiwch gyfeirio=20
at wefan Ymddiriedolaeth GIG Bro Morgannwg ar =
www.bromor-tr.wales.nhs.uk

English:-=20
This message is confidential. If you are not the intended recipient of =
the
message then please notify the sender immediately.=20
Any of the statements or comments made above should be regarded as =
personal
and not necessarily those of Bro Morgannwg NHS Trust, any=20
constituent part or connected body.

Please be aware that, under the terms of the Freedom of Information Act
2000, Bro Morgannwg NHS Trust may be required to make public the=20
content of any emails or correspondence received. For further =
information on
Freedom of Information, please refer to the Bro Morgannwg NHS=20
Trust website at www.bromor-tr.wales.nhs.uk.=09


------_=_NextPart_001_01C6046F.26610010
Content-Type: text/html;
	charset="ISO-8859-2"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-2">
<TITLE>RE: [Info-ingres] Ingres 2.6 on Solaris</TITLE>

<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=734123307-19122005>Solaris 2.6</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=734123307-19122005>II 2.6/0305 (su4.us5/00)</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=734123307-19122005>Patch 10402 </SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=734123307-19122005></SPAN></FONT>&nbsp;</DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN 
class=734123307-19122005>No unplanned downtime in last 6 months 
;-))</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=734123307-19122005>(Last 
downtime I have recorded is from 2004, but I could miss something.&nbsp;6 months 
for sure.)</SPAN></FONT></DIV>
<DIV align=left>
<P><SPAN class=734123307-19122005>Regards</SPAN>,<BR>Artur 
Fajok<BR><BR></P></DIV>
<BLOCKQUOTE 
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
  <DIV class=OutlookMessageHeader lang=pl dir=ltr align=left>
  <HR tabIndex=-1>
  <FONT face=Tahoma size=2><B>From:</B> Gareth Williams 
  [mailto:Gareth.Williams@bromor-tr.wales.nhs.uk] <BR><B>Sent:</B> Friday, 
  December 16, 2005 5:30 PM<BR><B>To:</B> 
  info-ingres@cariboulake.com<BR><B>Subject:</B> RE: [Info-ingres] Ingres 2.6 on 
  Solaris<BR></FONT><BR></DIV>
  <DIV></DIV>
  <P><FONT size=2>We have 2.6 on solaris 9 our current levels...</FONT> </P>
  <P><FONT size=2>II 2.6/0305 (su9.us5/00) 64bit!</FONT> <BR><FONT 
  size=2>11090</FONT> </P><BR>
  <P><FONT size=2>This is running an old ABF application (500 users), 24hrs a 
  day. We also have a "modern" version of the app that runs via ODBC from 
  ASP.net.</FONT></P>
  <P><FONT size=2>Downtime so far has been mainly down to bugs - for example 
  stack overflow on large SQLs, case statement in wrong part of SQL crashes the 
  IIDBMS instead of returning a syntax error. We've also had to back out of 
  patches that have broken other things.</FONT></P>
  <P><FONT size=2>We do have some locking issues - but I think this is mainly 
  down to our buggy applications.</FONT> </P>
  <P><FONT size=2>Our downtime stats last few months...</FONT> </P>
  <P><FONT size=2>Sept 2005 - 159mins (planned maintenance)</FONT> <BR><FONT 
  size=2>Oct 2005 - 399mins (unplanned caused by bug)</FONT> <BR><FONT 
  size=2>Nov 2005 - none </FONT><BR><FONT size=2>Dec 2005 - none - touch 
  wood.</FONT> </P>
  <P><FONT size=2>I think configuration is the key - get some CA training as the 
  docs and config tools aren't very helpful.</FONT> </P>
  <P><FONT size=2>out of interest - what's your current platform?</FONT> </P>
  <P><FONT size=2>Cheers</FONT> </P>
  <P><FONT size=2>Gareth</FONT> </P><BR>
  <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: 
  moab88@emirates.net.ae [<A 
  href="mailto:moab88@emirates.net.ae">mailto:moab88@emirates.net.ae</A>]</FONT> 
  <BR><FONT size=2>Sent: 13 December 2005 14:08</FONT> <BR><FONT size=2>To: 
  info-ingres@cariboulake.com</FONT> <BR><FONT size=2>Subject: [Info-ingres] 
  Ingres 2.6 on Solaris</FONT> </P><BR>
  <P><FONT size=2>We are planning to migrate a critical highly concurrent Ingres 
  II</FONT> <BR><FONT size=2>database to 2.6 on Solaris. Does anyone know of any 
  major major issues</FONT> <BR><FONT size=2>in 2.6 on Solaris.&nbsp; The 
  application can afford no downtime and requires</FONT> <BR><FONT 
  size=2>a&nbsp; true 24 X 7 environment.</FONT> </P>
  <P><FONT size=2>Any feedback (good and not so good) will be helpful in helping 
  us move</FONT> <BR><FONT size=2>forward.&nbsp; We have had major issues with 
  2.6 on a different platform</FONT> <BR><FONT size=2>where sessions get stuck 
  in any of the following states (COM, LOG,</FONT> <BR><FONT size=2>LKEVENT, 
  &lt;any&gt;) and we are not able to remove them.&nbsp; If they are</FONT> 
  <BR><FONT size=2>holding locks then we must shutdown/startup, if they have an 
  open</FONT> <BR><FONT size=2>transaction, then the transaction log keeps on 
  increasing until we</FONT> <BR><FONT size=2>shutdown, if none of the above, 
  the server would hang after sometime.</FONT> </P>
  <P><FONT size=2>Feedback on Solaris release/patches, Ingres release level and 
  patches,</FONT> <BR><FONT size=2>any special configuration settings, 
  etc.&nbsp; would also help.</FONT> </P>
  <P><FONT size=2>Nabil Courdy</FONT> <BR><FONT size=2>=========</FONT> </P>
  <P><FONT size=2>_______________________________________________</FONT> 
  <BR><FONT size=2>Info-ingres mailing list</FONT> <BR><FONT 
  size=2>Info-ingres@cariboulake.com</FONT> <BR><FONT size=2><A 
  href="http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres" 
  target=_blank>http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres</A></FONT> 
  </P><BR><BR>
  <TABLE style="COLOR: black" bgColor=white>
    <TBODY>
    <TR>
      <TD><BR>Cymraeg:-&nbsp;<BR>Mae'r&nbsp;neges&nbsp;hon&nbsp;yn&nbsp;gyfrinachol.Os&nbsp;nad&nbsp;chi&nbsp;yw'r&nbsp;derbynnydd&nbsp;y&nbsp;bwriedid&nbsp;y&nbsp;neges&nbsp;ar&nbsp;ei&nbsp;gyfer,&nbsp;byddwch&nbsp;mor&nbsp;garedig&nbsp;�&nbsp;rhoi&nbsp;gwybod<BR>i'r&nbsp;anfonydd&nbsp;yn&nbsp;ddi-oed.&nbsp;Dylid&nbsp;ystyried&nbsp;un&nbsp;rhywd&nbsp;datganiadau&nbsp;neu&nbsp;sylwadau&nbsp;a&nbsp;wneir&nbsp;uchod&nbsp;yn&nbsp;rhai&nbsp;personol,ac&nbsp;nid&nbsp;o&nbsp;angen&nbsp;rhaid&nbsp;yn&nbsp;rhai&nbsp;o&nbsp;<BR>eiddo&nbsp;Ymddiriedolaeth&nbsp;GIG&nbsp;Bro&nbsp;Morgannwg,&nbsp;nac&nbsp;unrhyw&nbsp;ran&nbsp;gyfansoddol&nbsp;ohoni&nbsp;na&nbsp;chorff&nbsp;cysylltiedig.<BR><BR>Cofiwch&nbsp;fod&nbsp;yn&nbsp;ymwybodol&nbsp;ei&nbsp;bod&nbsp;yn&nbsp;bosibl&nbsp;y&nbsp;bydd&nbsp;disgwyl&nbsp;i&nbsp;Ymddiriedolaeth&nbsp;GIG&nbsp;Bro&nbsp;Morgannwg&nbsp;roi&nbsp;cyhoeddusrwydd&nbsp;i&nbsp;gynnwys&nbsp;unrhyw&nbsp;ebost&nbsp;neu&nbsp;<BR>ohebiaeth&nbsp;a&nbsp;dderbynnir,&nbsp;yn&nbsp;unol&nbsp;ag&nbsp;amodau'r&nbsp;Ddeddf&nbsp;Rhyddid&nbsp;Gwybodaeth&nbsp;2000.&nbsp;I&nbsp;gael&nbsp;mwy&nbsp;o&nbsp;wybodaeth&nbsp;am&nbsp;Ryddid&nbsp;Gwybodaeth,&nbsp;cofiwch&nbsp;gyfeirio&nbsp;<BR>at&nbsp;wefan&nbsp;Ymddiriedolaeth&nbsp;GIG&nbsp;Bro&nbsp;Morgannwg&nbsp;ar&nbsp;www.bromor-tr.wales.nhs.uk<BR><BR>English:-&nbsp;<BR>This&nbsp;message&nbsp;is&nbsp;confidential.&nbsp;If&nbsp;you&nbsp;are&nbsp;not&nbsp;the&nbsp;intended&nbsp;recipient&nbsp;of&nbsp;the&nbsp;message&nbsp;then&nbsp;please&nbsp;notify&nbsp;the&nbsp;sender&nbsp;immediately.&nbsp;<BR>Any&nbsp;of&nbsp;the&nbsp;statements&nbsp;or&nbsp;comments&nbsp;made&nbsp;above&nbsp;should&nbsp;be&nbsp;regarded&nbsp;as&nbsp;personal&nbsp;and&nbsp;not&nbsp;necessarily&nbsp;those&nbsp;of&nbsp;Bro&nbsp;Morgannwg&nbsp;NHS&nbsp;Trust,&nbsp;any&nbsp;<BR>constituent&nbsp;part&nbsp;or&nbsp;connected&nbsp;body.<BR><BR>Please&nbsp;be&nbsp;aware&nbsp;that,&nbsp;under&nbsp;the&nbsp;terms&nbsp;of&nbsp;the&nbsp;Freedom&nbsp;of&nbsp;Information&nbsp;Act&nbsp;2000,&nbsp;Bro&nbsp;Morgannwg&nbsp;
NHS&nbsp;Trust&nbsp;may&nbsp;be&nbsp;required&nbsp;to&nbsp;make&nbsp;public&nbsp;the&nbsp;<BR>content&nbsp;of&nbsp;any&nbsp;emails&nbsp;or&nbsp;correspondence&nbsp;received.&nbsp;For&nbsp;further&nbsp;information&nbsp;on&nbsp;Freedom&nbsp;of&nbsp;Information,&nbsp;please&nbsp;refer&nbsp;to&nbsp;the&nbsp;Bro&nbsp;Morgannwg&nbsp;NHS&nbsp;<BR>Trust&nbsp;website&nbsp;at&nbsp;www.bromor-tr.wales.nhs.uk.</TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C6046F.26610010--
0
Artur
12/19/2005 7:38:05 AM
comp.databases.ingres 5857 articles. 0 followers. specially (35) is leader. Post Follow

0 Replies
764 Views

Similar Articles

[PageSpeed] 3

Reply:

Similar Artilces:

Re: [Info-Ingres] Upgrading from Ingres 2.6 to Ingres 2006- version9.2
I will be out of the office now until Wednesday 25th March, and will respond to your e-mail as soon as I can upon my return. If the matter is urgent, please raise a call via the ICT Helpdesk. This e-mail and any files transmitted with it are the property of the London Borough of Havering, are confidential, may be subject to legal privilege and are intended only for the person(s) or organisation(s) named above. Any unauthorised use, retention, distribution, copying or disclosure is strictly prohibited. If you receive this email in error, please notify the sender immediately and delete this e-mail from your system. WARNING: It is your responsibility to take all necessary steps to ensure this e-mail and any attachments to it are free from viruses. ...

Re: [Info-Ingres] Ingres 2.6 on Solaris 10: createdb slow #2
> -----Original Message----- > From: info-ingres-bounces@kettleriverconsulting.com > [mailto:info-ingres-bounces@kettleriverconsulting.com] On > Behalf Of William Yuan > Sent: 23 April 2007 07:51 > To: Artur.Fajok@psat.pl > Cc: Info Ingres > Subject: Re: [Info-Ingres] Ingres 2.6 on Solaris 10: createdb slow > > > Hi Artur, > > Thanks for your reply. I have been initially testing on > a 2 Gb cooked > log on ufs with RAID 5. Our I/O throughput and latency > on a Solaris > V890 zone appears to be 50-200% quicker than the older > Dec AlphaServer, > according to the bonnie++ disk benchmarks. We plan to > trial using a > rawlog in the next few days. > > The best time I could achieve with Ingres 2006 on a > Solaris 10 zone was > 22 seconds. The timing is still a fair way off from > what I had hoped for. > > > Kind Regards, > > William > > >Hi William, <SNIP> Hi William, Are you sure that you want to use RAID 5 when you need very fast disk writes? Take a look at http://www.baarf.com/ to see why RAID 5 is very bad write intensive disk operations! HTH Richard ************************************************************************ DISCLAIMER The information contained in this e-mail is confidential and is intended for the recipient only. If you have received it in error, please notify us immediately...

RE: [Info-ingres] Ingres Upgrade from Version 2.0 to Version 2.6 #2
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_01C52E34.1F3A78F0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit You can carry a cold backup of an Ingres database (offline checkpoint) quite easily as follows:- PROCEDURE (NOT Supported by CA) 1. Use infodb to identify ALL data locations 2. ingstop 3. Remove ALL underlying database files:- 4. For each data_loc# do cd <data_loc#>; rm * Recover the underlying da...

[Info-ingres] RE: [ingres] [Info-ingres] Dates users were created in Ingres #2
Hi Troy, iidbdb journals are not that big. In one of my larger installations, 3 days worth of journals takes 112Mb for the transaction database and 200Kb for iidbdb. I think in Ingres 2.6 you can keep 100 checkpoints in the history. Paul -----Original Message----- From: Anderson, Troy E. [mailto:AndersonTE@bvsg.com] Sent: Monday, 17 January 2005 3:57 PM To: Paul Mason Cc: info-ingres@cariboulake.com Subject: RE: [ingres] [Info-ingres] Dates users were created in Ingres Hi Paul, Thanks for the information! I do have a question: I checkpoint the iidbdb daily with th...

RE: [Info-ingres] Ingres 2.6 on Solaris
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_01C6025D.FD8C6B10 Content-Type: text/plain; charset="iso-8859-1" We have 2.6 on solaris 9 our current levels... II 2.6/0305 (su9.us5/00) 64bit! 11090 This is running an old ABF application (500 users), 24hrs a day. We also have a "modern" version of the app that runs via ODBC from ASP.net. Downtime so far has been mainly down to bugs - for example stack overflow on large SQLs, case statement in wrong part of SQL crashes the IIDBMS instead of returning a syntax error. We've also had to back out of patches that have broken other things. We do have some locking issues - but I think this is mainly down to our buggy applications. Our downtime stats last few months... Sept 2005 - 159mins (planned maintenance) Oct 2005 - 399mins (unplanned caused by bug) Nov 2005 - none Dec 2005 - none - touch wood. I think configuration is the key - get some CA training as the docs and config tools aren't very helpful. out of interest - what's your current platform? Cheers Gareth -----Original Message----- From: moab88@emirates.net.ae [mailto:moab88@emirates.net.ae] Sent: 13 December 2005 14:08 To: info-ingres@cariboulake.com Subject: [Info-ingres] Ingres 2.6 on Solaris We are planning to migrate a critical highly concurrent Ingres II database t...

[Info-Ingres] Upgrading from Ingres 2.6 to Ingres 2006- version 9.2
This is a multi-part message in MIME format. ------_=_NextPart_001_01C9A6A4.5258B9C4 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable We have finally decided to move to the new version of the dbms- does anyone think Ingres 9.2 is too new to move to? How long has it been out there? Thanks, =20Robert Confidentiality/Privilege Notice: This communication is confidential and may be legally privileged. If you= =20are not the intended recipient please delete the message and notify th= e sender at Ports of Auckland Limited. Any use, disclosure, copying, dist= ribution or retention of this communication is strictly prohibited. ------_=_NextPart_001_01C9A6A4.5258B9C4 Content-Type: text/html; charset="us-ascii" 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-asci= i"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 6.5.7652.2= 4"> <TITLE>Upgrading from Ingres 2.6 to Ingres 2006- version 9.2</TITLE> </HEAD> <BODY> <!-- Converted from text/rtf format --> <P><SPAN LANG=3D"en-us"><FONT SIZE=3D2 FACE=3D"Arial">We have finally dec= ided to move to the new version of the dbms-&nbsp; does an...

RE: [Info-ingres] Re: Ingres/ICE (3.0.2) and Apache 2.0.54 #2
The example PHP file is available via http://www.ingres.co.uk/files/php/blob_read.phps and not the url posted earlier. ...

RE: [Info-Ingres] Ingres R3 Support for Linux 2.6 Kernel? #2
Leavell Although I've not (yet) done any serious testing, I've successfully run the R3 and SuSE 9.1 configuration for a couple of weeks without noticing any problems. Mark -----Original Message----- From: Lucky Leavell [mailto:ingrnews@unixpress.com] Sent: 20 August 2004 15:27 To: info-ingres@ams.org Subject: [Info-Ingres] Ingres R3 Support for Linux 2.6 Kernel? I just downloaaded Ingres R3 for Linux and noticed it only supports (is supported by?) the Linux 2.4 kernel. When will a version for the 2.6 kernel be available? (Guess it is a good thing I have ...

Re: [Info-ingres] Ingres Upgrade from Version 2.0 to Version 2.6
At 3:50 PM +0000 3/21/2005, Wilding, Gregory wrote: >As part of our current DR strategy we copy the checkpoint, dump and journal >files to the DR server on a daily basis and rollforward the database. As >part of the upgrade plan we are looking at upgrading the DR server first and >a week later upgrading the live server. > >Does anybody know if a checkpoint, dump and journal files produced under >Ingres 2.0 can be used on Ingres 2.6. No, they can't. Karl ...

Re: [Info-Ingres] Upgrade from Ingres 2.6 SP5 to Ingres 2006 r2
I will be out of the office now until Monday 4th August, and will respond to your e-mail as soon as I can upon my return. If the matter is urgent, please raise a call via the ICT Helpdesk. This e-mail and any files transmitted with it are the property of the London Borough of Havering, are confidential, may be subject to legal privilege and are intended only for the person(s) or organisation(s) named above. Any unauthorised use, retention, distribution, copying or disclosure is strictly prohibited. If you receive this email in error, please notify the sender immediately and delete this e-mail from your system. WARNING: It is your responsibility to take all necessary steps to ensure this e-mail and any attachments to it are free from viruses. ...

[Info-ingres] FW: [Info-ingres] File size (2 GB) limit when using AIX Version 5.1 with Ingres 2.6/0305
This is a multi-part message in MIME format. ------_=_NextPart_001_01C50ED1.33C08D7F Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Hi David, =20 This usually means that the Unix account you are using has a file size limit (seen via ulimit -a (your account's soft limit) or ulimit -aH (your account's hard limit)) that is stopping you from creating that big of a file. Your root user can adjust your account's file size limit via the smitty utility program to allow you to create files greater than 2gb. My Ingres acc...

Re: [Info-Ingres] Ingres 2.6 on Solaris 10: createdb slow
Hi William, How your transaction log is configured? Maybe it's on zfs? If it is, then it's rather bad idea, and gives similar results. Regards, Artur ________________________________ ProService Agent Transferowy Sp. z o.o. z siedzib� w Warszawie, ul. Pu�awska 436, 02-801 Warszawa, S�d Rejonowy dla m.st. Warszawy, XIII Wydzia� Gospodarczy Krajowego Rejestru S�dowego, rejestr przedsi�biorc�w Krajowego Rejestru S�dowego - KRS 0000013069 Kapita� zak�adowy wynosi 5.050.000,00 z�otych i wp�acony jest w ca�o�ci, NIP 526-25-07-903 > -----Original Message----- > From: William Yuan [mailto:yuan@ariel.its.unimelb.edu.au] > Sent: Monday, April 23, 2007 8:10 AM > To: info-ingres@kettleriverconsulting.com > Subject: [Info-Ingres] Ingres 2.6 on Solaris 10: createdb slow > > Hi there, > > I am configuring a new installation of Ingres 2.6 on > Solaris 10 zones and > seeing some performance issues. In particular, I'm > seeing some very slow > createdb times which is unusual: > > Sun V890 (8 cpus @ 1.5 Ghz), 16 Gb RAM, Solaris 10 > zoned): 22-70 seconds # Snail > Dec AlphaServer ES47 (2 cpus @ 1 Ghz, 8 Gb RAM, DUnix > 5.1): 5-8 seconds # Normal > > Has anyone seen this kind of slowdown on Solaris 10 > before ? I had > similar timings on the createdb when trialling Ingres > 2006 as well. > > I wonder if "de-zoning" the...

RE: [Info-ingres] Re: Ingres stand-by database #2
Well aware of the -b bugs. We have filed many issues and have them all resolved on our version. We don't xfer the ckp's because it is 60GB over a WAN. We also "zero-out" the .jnl files before and after the ones we want to rollforward. We do NOT monkey with the .cnf file, just transfer it. -----Original Message----- From: martin.bowes@ctsu.ox.ac.uk [mailto:martin.bowes@ctsu.ox.ac.uk] Sent: Thursday, June 09, 2005 4:13 AM To: Kale, Mark (STP) Cc: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Re: Ingres stand-by database Hi Mark I think I may hav...

[Info-ingres] Ingres 2.0 upgrade to 2.6
Hello, I'm planning on making the above upgrade in the very near future and wanted to ask for gotchas/suggestions, before starting. I've got the 2.6 SP2 from CA and the Migration Guide, which indicates an upgradedb is the preferred method for this task. This will be running on Win2000. Aside from iidbdb and imadb, there's only one other db, mk, with 2775 tables. There are 325 views, a couple of procedures, and that's about it. Any thoughts you can offer will be greatly appreciated! We've got several MK users in our group who are talking of moving from Ingre...

[Info-ingres] Problem after upgrade to Ingres 2.6 #2
Pretty sure we've seen the same problem on R3; I believe the fix may have been to install the correct C compiler, fix up the path or LD_LIBRARY_PATH, or possibly something to do with the abflnk.opt file. Only the last possibility applies if you are doing an upgrade, preserving the II_SYSTEM onto the same machine & OS. Can you compile the ESQL/C program without make? HTH. ----- Original Message ----- Message: 6 From: "Wilding, Gregory" <gregory.wilding@eds.com> To: info-ingres@cariboulake.com Date: Wed, 4 May 2005 16:00:27 +0100 Subject: [Info-ingre...

RE: [Info-ingres] Re: Differences between 6.4 and 2.6 #2
Graham wrote: > I have to say that accessing Microsoft's equivalent information seems > easier - no registration etc. Roy wrote: > I think getting any Ingres-related information out of CA websites is only > get harder, slower, and more frustrating actually. www.ca.com/opensource is > a particlar disgrace, and the forums are virtually unusable unless you plan > to devote hours to trawling them. I can't be bothered (and I actually > care); no casual user would bother with it for more than 30 seconds. I find the forums a bit frustrating also. I much p...

RE: [Info-ingres] Re: Differences between 6.4 and 2.6 #2
We love to bag CA - but this forum is about Ingres. The Supportconnect PAC will have very little to do with Ingres or product licensing specifically. I'd say comments about the ingres home page are probably going to be handled by the Ingres product group. The AccountConnect group will probably deal with the licensing site registration type items. However I'll make sure all comments are tabled at the PAC. Be sure to also raise your comments with your Customer Advocate. For web performance problems be sure to log issues too. Paul White President Victorian Ingres Users gro...

RE: [Info-ingres] Re: Differences between 6.4 and 2.6 #2
Why does this have to be offline? Surely everyone on this group would be interested in hearing what is being proposed? I'd certainly like to hear what everyone has to say as it may provoke suggestions for other areas that need addressing. -----Original Message----- From: info-ingres-admin@cariboulake.com [mailto:info-ingres-admin@cariboulake.com] On Behalf Of Roy Hann Sent: 31 March 2005 07:43 To: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Re: Differences between 6.4 and 2.6 "Paul White" <pwhite@peerlessit.com.au> wrote in message news:mailman...

[Info-Ingres] Ingres 2.6 and solaris 10
Hi gurus , i have that install ingres database server for critical produccion service ,ill like robust and performance Somebody know (24x7) instalations ingres2.6 over solaris 10? , its need patchs of solaris or ingres?... thx Ingres on Solaris is possibly the most common combination running. Call Support and arrange to get Ingres 2.6 Service Pack 5. Ingres is certified against Solaris 10 - the SP5 release notes give a list of recommended OS patches if using Visual Tools, but there is nothing listed for any other comnponent, including the DBMS. John On Mar 26, 4:37 am, m-angel <lobet...@gmail.com> wrote: > Hi gurus , i have that install ingres database server for critical > produccion service ,ill like robust and performance > > Somebody know (24x7) instalations ingres2.6 over solaris 10? , its > need patchs of solaris or ingres?... > > thx ------=_Part_106136_32084461.1174896507457 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello, Any others comment on Ingres 2006 community edition (II 9.1.0 (su9.us5/119)) and Solaris 8 (SunOS hune 5.8) ? Thx, Jean-Pierre 25 Mar 2007 16:40:23 -0700, John Dennis <denjo02@hotmail.com>: > > Ingres on Solaris is possibly the most common combination running. > Call Support and arrange to get Ingres 2.6 Service Pack 5. Ingres is > certified against Solaris 10 - the S...

RE: [Info-ingres] Ingres stand-by database #2
I am not doing a creeping one. It just allows a copy of the up-to-date journals and last ckp file etc. to be ready for A rollforward when required. -----Original Message----- From: martin.bowes@ctsu.ox.ac.uk [mailto:martin.bowes@ctsu.ox.ac.uk] Sent: Wednesday, 8 June 2005 8:12 p.m. To: Robert Allely; 'chloe.crowder@bl.uk' Cc: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Ingres stand-by database Hi Robert, Chloe etc. I'm not sure if I have a full grasp on whether or not Robert was doing a 'creeping' rollforward or not, but just in case, I'd like to get on the Ol' Soap Box for a moment. Its one thing to set up a DR system using rollforwarddb from a checkpoint/journal etc. Thats a perfectly simple and natural thing to do. But Its quite another to use rollforwarddb from some point and then transfer over more journals and do a 'creeping' rollforwarddb -c +j '#f' - b... [-norollback] ....And then automate the process, ....allowing for errors such as: * the rollforwarddb being locked out by another process, * the possibility of a database being flagged as inconsistent on the DR site - which is very probable. * A breakdown in the transport of a journal or other essential file between the hosts. scp/rcp/ftp failure. * A journal being written to by the primary host archiver as it was transferred to the DR host. Whats that (unsupported) trace point to force ...

RE: [Info-ingres] Re: Ingres/ICE (3.0.2) and Apache 2.0.54
m00n, I have uploaded a DLL for PHP 5.0.5 to http://www.ingres.co.uk/files/php/php-5.0.5-ingres_dll.zip. You should know that the code has been tested with BLOBs of varying sizes up to 100Mb; it should work with larger files I did not have any laying about to test with. The code will fetch data in segments defined by the connect option "blog_segment_length". I believe the maximum segment size is 32k. See http://www.ingres.co.uk/files/php/blob_read.php for an example of setting connect options. Later on it will be possible to set the segment length dynamically not just at c...

Re: [Info-Ingres] Ingres 2.5 and cache memory #2
Hi Gibson, Thanks for your quick reply. I remember the document but I can't find it anymore. Anyway, my main concern is this particular version of Ingres. Somehow (but I might be wrong) I remember some discussions about 2.5 having problems with large cache memory. Cheers, Nick -----Original Message----- From: Gibson Jonathan [mailto:Jonathan.Gibson@HISCOX.com] Sent: 24 January 2007 09:46 To: Barbat, Nicolae : Barclays Wealth Technology; info-ingres Subject: RE: [Info-Ingres] Ingres 2.5 and cache memory Hi Nick, I'd check out the 30 second health check at Rational Commerce (hope it's still there) which should give you some ideas of what to set your dmf cache to as well as checking over other areas of your system. Without knowing more about your system, it would be frivolous to say whether you'll get any benefit. www.rationalcommerce.com Jon Gibson Senior Database Administrator Hiscox Plc T: +44 (0)20 7448 6820 F +44 (0)20 7448 6899 www.hiscox.com -----Original Message----- From: info-ingres-bounces@kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Barbat,Nicolae : Barclays Wealth Technology Sent: 24 January 2007 09:35 To: info-ingres@kettleriverconsulting.com Subject: [Info-Ingres] Ingres 2.5 and cache memory Hi All, We are (still) running Ingres 2.5/0011 patch 7652 on HP-UX 11. Noticed some time ago that the cache parameters are the default ones: ...

Re: [Info-Ingres] Ingres 2.5 and cache memory #2
Hi Jim, We have so many problems with this 2.5....no point going there though. A migration project is just about to start which raises another question: what should it be 2.6, r3 or 2006? But this is a different topic I guess... Thanks for your reply, Nick -----Original Message----- From: info-ingres-bounces@kettleriverconsulting.com [mailto:info-ingres-bounces@kettleriverconsulting.com]On Behalf Of Jim Gramling Sent: 24 January 2007 11:16 To: info-ingres@kettleriverconsulting.com Subject: Re: [Info-Ingres] Ingres 2.5 and cache memory I know of no specific problems with larger cache sizes in 2.5; certainly not with the relatively small increase in group count you are proposing. I've run with 2.5 on other platforms and have never encountered anything to that effect. Assuming you have the o/s resources (particularly shared memory if your cache is shared), there's no reason you can't go substantially larger than you are considering. You probably know by now that 2.5 has a drop support date (I think something like end of 2007), so you should really be thinking about an upgrade to 2.6 at least, as soon as possible. Shouldn't be too traumatic to go from 2.5 to 2.6. Regards, Jim Gramling Rio de Janeiro On Jan 24, 6:35 am, "Barbat, Nicolae : Barclays Wealth Technology" <nicolae.bar...@barclays.com> wrote: > Hi All, > > We are (still) running Ingres 2.5/0011 patch 7652 on HP-UX 11. Noticed ...

[Info-ingres] RES: [Info-ingres] Ingres Resources #2
Hi all, Good news, the knowledge base is back. It is within Ingres Service Desk. http://servicedesk.ingres.com:8080/CAisd/pdmweb.ingres Many thanks to the folks who did this job. Leandro Fava DBA-SINF-UNISC http://www.unisc.br Presidente IUG-BR http://www.iug-br.org Fone: +55 51 3717 7636 > -----Mensagem original----- > De: info-ingres-admin@cariboulake.com > [mailto:info-ingres-admin@cariboulake.com] Em nome de Paul Blondel > Enviada em: Thursday, April 13, 2006 6:16 PM > Para: info-ingres@cariboulake.com > Assunto: Re: [Info-ingres] Ingres Resources > > Leandro Pinto Fava wrote: > > where can I search in a knowledge base for Ingres solutions? It > > seems the knowledge base in service desk at ingres.com does not have > > info. > > Unfortunately it does not work at all. Keep an eye on it and > it may burst into life in the next little while. > _______________________________________________ > Info-ingres mailing list > Info-ingres@cariboulake.com > http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres > ...

Web resources about - RE: [Info-ingres] Ingres 2.6 on Solaris #2 - comp.databases.ingres

Resources last updated: 2/20/2016 7:17:35 PM