f



[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 account, for instance, has the file(blocks) ulimit
parameter set to unlimited for this reason.
=20
Hope this helps!
=20
Troy E. Anderson=20
BV SOLUTIONS GROUP, Inc., A Black & Veatch Company
10950 Grandview Ave.
Overland Park, KS 66210
Tel. (913) 458-8521
Fax. (913) 458-4994
<mailto: andersonte@bvsg.com <mailto:%20%20andersonte@bvsg.com> >
Visit us: http://www.bvsg.com <http://www.bvsg.com/> =20
=20
=20
________________________________

From: info-ingres-admin@cariboulake.com
[mailto:info-ingres-admin@cariboulake.com] On Behalf Of David G. Brooks
Sent: Wednesday, February 09, 2005 10:47 AM
Cc: info-ingres@cariboulake.com
Subject: [Info-ingres] File size (2 GB) limit when using AIX Version 5.1
with Ingres 2.6/0305


I am having a problem when I attempt to create a Transaction Log file
greater than 2 GB on our AIX 5.1 box, under Ingres 2.6/0305.  I also
note that we've also had a problem moving (via ftp) any files over 2 GB
(like large .tar files of databases) onto this same box, so I guess its
related.  Somewhere I think I recall hearing that this limit is
defaulted on AIX systems and the maximum size can be increased.

Does anyone know about this problem and what I could do to fix.  I know
its more an AIX/Unix problem but its hampering my Ingres installation so
I thought I would pose the question here, in the hope that someone has
run across it too (and hopefully has a solution).

Thanks,
David.

--=20
-----------------------------------------
David G. Brooks
Vision Systems Software
(P.O. Box 804, Bridgetown)
Omega Building - Suite 5
Dayrells Court Business Centre
Dayrells Road
Christ Church
BARBADOS
West Indies

URL:	http://www.VisionSystemsSoftware.com/

Tel:	(246) 431-0193 - Work
	(246) 436-1417 - Home

Fax:	(246) 431-0192 - Work
_______________________________________________ Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres=20

------_=_NextPart_001_01C50ED1.33C08D7F
Content-Type: text/html;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1479" name=3DGENERATOR></HEAD>
<BODY text=3D#000099 bgColor=3D#ffffff>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D840362517-09022005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Hi David,</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D840362517-09022005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D840362517-09022005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>This usually means that the Unix account you =
are using has=20
a file size limit (seen via ulimit -a (your account's soft =
limit)&nbsp;or ulimit=20
-aH (your account's hard limit)) that is stopping you from creating that =
big of=20
a file.&nbsp; Your root user can adjust your account's file size limit =
via the=20
smitty utility program to allow you to create files greater than =
2gb.&nbsp; My=20
Ingres account, for instance, has the file(blocks) ulimit parameter set =
to=20
unlimited for this reason.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D840362517-09022005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D840362517-09022005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Hope this helps!</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D840362517-09022005><SPAN =
lang=3Den-us><B><FONT=20
face=3DTahoma size=3D2></FONT></B></SPAN></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D840362517-09022005><SPAN =
lang=3Den-us><B><FONT=20
face=3DTahoma size=3D2>Troy E. Anderson</FONT></B></SPAN> <BR><SPAN=20
lang=3Den-us><B><FONT face=3DTahoma size=3D2>BV SOLUTIONS GROUP, =
Inc.</FONT></B><FONT=20
face=3DTahoma size=3D2>, A Black &amp; Veatch Company</FONT><FONT=20
face=3D"Times New Roman"><BR></FONT><FONT face=3DTahoma size=3D2>10950 =
Grandview=20
Ave.</FONT><FONT face=3D"Times New Roman"><BR></FONT><FONT face=3DTahoma =

size=3D2>Overland Park, KS 66210</FONT><FONT=20
face=3D"Times New Roman"><BR></FONT><FONT face=3DArial size=3D2>Tel. =
(913)=20
458-8521</FONT><FONT face=3D"Times New Roman"><BR></FONT><FONT =
face=3DArial=20
size=3D2>Fax. (913) 458-4994</FONT><FONT face=3D"Times New =
Roman"><BR></FONT><FONT=20
face=3DArial size=3D2>&lt;</FONT></SPAN><A=20
href=3D"mailto:%20%20andersonte@bvsg.com"><SPAN lang=3Den-us><U><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>mailto: =
andersonte@bvsg.com</FONT></U></SPAN></A><SPAN=20
lang=3Den-us><FONT face=3DArial size=3D2>&gt;</FONT><FONT=20
face=3D"Times New Roman"><BR></FONT><FONT face=3DArial size=3D2>Visit =
us:</FONT><FONT=20
face=3D"Times New Roman"></FONT> <FONT face=3D"Courier New" size=3D2><A=20
href=3D"http://www.bvsg.com/">http://www.bvsg.com</A></FONT><FONT=20
face=3D"Times New Roman"> </FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN =
class=3D840362517-09022005></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
</DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DTahoma size=3D2><B>From:</B>=20
info-ingres-admin@cariboulake.com =
[mailto:info-ingres-admin@cariboulake.com]=20
<B>On Behalf Of </B>David G. Brooks<BR><B>Sent:</B> Wednesday, February =
09, 2005=20
10:47 AM<BR><B>Cc:</B> info-ingres@cariboulake.com<BR><B>Subject:</B>=20
[Info-ingres] File size (2 GB) limit when using AIX Version 5.1 with =
Ingres=20
2.6/0305<BR></FONT><BR></DIV>
<DIV></DIV><FONT size=3D+1><FONT face=3D"Century Gothic">I am having a =
problem when=20
I attempt to create a Transaction Log file greater than 2 GB on our AIX =
5.1 box,=20
under Ingres 2.6/0305.&nbsp; I also note that we've also had a problem =
moving=20
(via ftp) any files over 2 GB (like large .tar files of databases) onto =
this=20
same box, so I guess its related.&nbsp; Somewhere I think I recall =
hearing that=20
this limit is defaulted on AIX systems and the maximum size can be=20
increased.<BR><BR>Does anyone know about this problem and what I could =
do to=20
fix.&nbsp; I know its more an AIX/Unix problem but its hampering my =
Ingres=20
installation so I thought I would pose the question here, in the hope =
that=20
someone has run across it too (and hopefully has a=20
solution).<BR><BR>Thanks,<BR>David.<BR></FONT></FONT><PRE =
class=3Dmoz-signature cols=3D"72">--=20
-----------------------------------------
David G. Brooks
Vision Systems Software
(P.O. Box 804, Bridgetown)
Omega Building - Suite 5
Dayrells Court Business Centre
Dayrells Road
Christ Church
BARBADOS
West Indies

URL:	<A class=3Dmoz-txt-link-freetext =
href=3D"http://www.VisionSystemsSoftware.com/">http://www.VisionSystemsSo=
ftware.com/</A>

Tel:	(246) 431-0193 - Work
	(246) 436-1417 - Home

Fax:	(246) 431-0192 - Work
</PRE>_______________________________________________ Info-ingres =
mailing list=20
Info-ingres@cariboulake.com=20
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres =
</BODY></HTML>

------_=_NextPart_001_01C50ED1.33C08D7F--
0
Anderson
2/9/2005 6:00:07 PM
comp.databases.ingres 5857 articles. 0 followers. specially (35) is leader. Post Follow

0 Replies
1994 Views

Similar Articles

[PageSpeed] 19

Reply:

Similar Artilces:

[Info-ingres] File size (2 GB) limit when using AIX Version 5.1 with Ingres 2.6/0305
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000099"> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> <font size="+1"><font face="Century Gothic">I am having a problem when I attempt to create a Transaction Log file greater than 2 GB on our AIX 5.1 box, under Ingres 2.6/0305.&nbsp; I also note that we've also had a problem moving (via ftp) any files over 2 GB (like large .tar files of databases) onto this same box, so I guess its related.&nbsp; Somewhere I think I recall hearing that this limit is defaulted on AIX systems and the maximum size can be increased.<br> <br> Does anyone know about this problem and what I could do to fix.&nbsp; I know its more an AIX/Unix problem but its hampering my Ingres installation so I thought I would pose the question here, in the hope that someone has run across it too (and hopefully has a solution).<br> <br> Thanks,<br> David.<br> </font></font> <pre class="moz-signature" cols="72">-- ----------------------------------------- David G. Brooks Vision Systems So...

RE: [Info-ingres] File size (2 GB) limit when using AIX Version 5.1 withIngres 2.6/0305
This is a multi-part message in MIME format. ------_=_NextPart_001_01C50F59.4B71A035 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =20 If=20the=20log=20file=20is=20all=20that's=20on=20the=20file=20system=20(I'= d=20recommend=20that=20if you=20have=20enough=20disks=20to=20allow)=20then=20it=20should=20be=20a=20= simple=20case=20of stopping=20ingres,=20destroying=20the=20log=20file,=20removing=20the=20fil= e=20system (umount=20and=20then=20a=20rmfs),=20recreating=20the=20file=20system=20wit= h=20large=20files enabled,=20recreating=20the=20log=20file=20and=20restarting=20ingres.=20=20= Should=20only take=205=20to=2010=20mins=20depending=20on=20the=20speed=20of=20your=20equ= ipment=20and=20the actual=20size=20of=20the=20file=20system=20you=20recreate. =20 If=20on=20the=20other=20hand,=20you've=20other=20stuff=20on=20the=20file=20= system,=20which sounds=20likely=20from=20what=20you've=20said,=20then=20yup,=20you're=20lo= oking=20at=20a=20bit of=20reasonable=20downtime=20and=20some=20overtime=20pay=20hopefully=20;-)= =20=20If=20you're having=20to=20take=20this=20option,=20I'd=20seriously=20look=20at=20splitt= ing=20out=20the=20log file=20to=20it's=20own=20disk.=20=20By=20the=20way,=20creating=20the=20new= =20file=20system=20large file=20enabled=20is=20an=20option=20in=20the=20SMIT=20menu=20but=20I=20gue= ss=20you're=20aware=20of that=20now. =20 Good=20l...

[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] 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 database files from .ckp saveset (using tar or cpio) 5. Use cbf to format the transaction log file(s) 6. ingstart 7. Patch iidbdb to demote the dataabse back to version 2.0 8. sql +Y iidbdb 9. update iidatabase set dbcmptlvl = 8.0 where name = <dbname>;\p\g\q 10. Upgradedb <dbname> CHECKPOINT <dbname> AS SOON AS POSSIBLE ************************************************************************ 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 by reply e-mail and then delete it from your system. Please do not copy it or use it for any other purposes, or disclose the content of the e-mail to any other person or store or copy the information in any medium. The views contained in this e-mail are those of the author and not nece...

[Info-ingres] File size limit on Ingres 2.6 + RH 8
Hi all: I am using Ingres 2.6 SP2 on a Red Hat 8 box. One of my user tables is 1.1 GB. size, in one .t00 file. I need to download this table in an ascii file using copydb -c. Doing this, I have the next error and the conexi�n with DB is broken: File size limit excedeed. The result incomplete ascii file is almost 2 GB. I know there is a file size limitation of 2 GB per file on Ingres, but I don't remember that this is applied to Ingres 2.6 over RH 8. Even if this limitation persists on Ingres 2.6 over Linux, simply I will have to create another data location and modify this table over those 2 locations. But this, will work for proper table operation (selects, update, etc). What Can I do for copydb -c? I did a simple test, copying one big file (2.3 GB) to RH file system, and there is no problem. I asume that no problem exists with RH FS supporting a file > 2 GB. Then it will be about Ingres 2.6. I will appreciate your comments and if the only way to solve this is upgrading my OS and Ingres version. Best Regards Oscar -- Lic. Oscar Carl�s Barriocanal Director de Servicios al Cliente �ntegra S.R.L. Telefax: (595 21) 424473 RA ...

[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...

[Info-ingres] Ingres Upgrade from Version 2.0 to Version 2.6
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. Any responses will be appreciated. Thanks Gregory Wilding UK North Midlands Solutions Centre Abney Park Manchester Road Cheadle Cheshire SK8 2PD Tel +44 (0) 161 495 3488 Fax +44(0) 161 428 5009 <mailto:gregory.wilding@eds.com <mailto:gregory.wilding@eds.com> > ...

[Info-Ingres] Go back from Ingres 9.1.1-103 to Ingres 2.6, tru64
Este es un mensaje con varias partes en formato MIME. ------=_NextPart_000_0081_01C9C591.07BA9D10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all! =20 I am in the process of upgrading from Ingres 2.6 to Ingres 9.1.1-103 = (Ingres 2006 r2) on a tru64 5.1b box, production environment. For this, I have two identical machines (same OS, same ingres configuration,etc), one I use for production environment and the other = is for contingency pourpose. My plan is make upgrade to 2006, directly over production machine; = before this I am going to have a snapshot of DBs over the contingency machine. Suppose the upgrade process is success and production environment is = active and transactions are processed over Ingres 9.1.1 version and after a few hours I have performance problems or whatever occurs and I have to go = back to Ingres 2.6 version. For this, I have data snapshot on Ingres 2.6 on contingency machine, before 2006 is going to production, but new transactions is on Ingres 9.1.1 machine. What I need to know is if it is possible to use journals files from = 9.1.1 version, copy them to Ingres 2.6 installation and perform a = rollforwarddb on 2.6 in order to have again Ingres 2.6 data up to date? =20 Many thanks for your help =20 Regards =20 Oscar =20 =20 Lic. Oscar Carl=E9s Barriocanal ITIL V3 Certified Director de Servicios =CDntegra SRL ...

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 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 ...

[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 > ...

[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 Ingres to SQL, but since our move to new hardware last summer, that kind of talk around here has fallen by the wayside. Cheers, Mike Ossing IT Mgr Rodem, Inc. 513-922-6140 x147 ========================================= This GroupWise e-mail message was scanned using Beginfinite's Guinevere Antivirus program and F-Prot Antivirus software. The virus definitions used by F-Prot to block e-mail viruses are updated on a regular basis, thus insuring that no e-mail is infected. Should you have any questions about the content of this e-mail, or are not the intended recipient, please contact the Rodem e-mail Administrator at this address: admin@rodem.com. ========================================= ...

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 ...

[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-ingres] Problem after upgrade to Ingres 2.6 > Dear All, > > We are upgrading Ingres from 2.0 to 2.6. > > We also develop some of our software using ABF, and have found > post-upgrade that any attempt to recompile and link an ABF application > results in a Link failure 2310. > Compiling an embedded C program using the 'make -f ' command and C > compiler ver 4.2 also fails. > > Has anyone experienced this problem after upgrading to Ingres 2.6 ? > regards > Stephen M. Batchelor > EDS (UK North Midland Solution Centre) > Abney Court, Abney Park > Manchester Rd. > Cheadle SK8 2PD > > Phone: 0161 495 3454 > + mailto:stephen.batchelor@eds.com <mailto:stephen.batchelor@eds.com> Cheers! -----Original Message----- From: Wilding, Gregory Sent: Thursday, May 05, 2005 1:41 AM To: Hoan P. Thai Su...

[Info-Ingres] Upgrade from Ingres 2.6 SP5 to Ingres 2006 r2
Hi: I am testing the upgrade process from Ingres 2.6 sp2 over tru64 5.1b to Ingres 2006 r2 (installing Ingres 2006 r2 directly over 2.6 installation) I have an error trying to startup ingres before upgradedb command. The error: E_CL2514_CS_ESCAPED_EXCEPTION, starting the recovery process. Any help will be welcomed Regards Oscar -- Lic. Oscar Carl�s Barriocanal Director de Servicios al Cliente �ntegra S.R.L. Telefax: (595 21) 424473 RA Asunci�n - Paraguay ...

[Info-ingres] LKEvent situation on Tru64 5.1b win Ingres 2.6 0305
This is a multi-part message in MIME format. --------------090107080303070304050501 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Hi: Anybody has any experience with this situation? I have an open issue with Ingres Corp since April 2006 and there is no a=20 real solution. Their workaround was: maintain all time a connection to iidbdb. It=20 works, but I already had one LKEVENT situation, even if I maintain that=20 iidbdb connection. There is a reference of this problem on Ingres Support site, but there=20 is no solution. *Sessions Stuck in LKEVENT State* =20 Summary: Sessions Stuck in LKEVENT State Bug 114498 Problem INGSRV3299 2.6/0305 (Generic) Fixed 10-aug-2006 =20 Problem: Since installing patch 10420 (mark 2636) two or more session may hang in=20 an LKEVENT state and can not be removed via ipm and/or iimonitor. The sessions are logged in lockstat output as "Waiting for TCB at=20 physical address ...". If these sessions hold resources required by other sessions, these=20 sessions will also hang. The only way to continue is to forcibly shutdown the server. =20 Resolution: If a fix is reuqired please contact Ingres Corp Customer Support. =20 See Also: =20 Attachments: =20 Related Categories: TOP>Ingres>Server =20 Related Tickets: =20 Properties: Doc ID:366895 Creation Date:05/12/2005 =20 Comments: Any help will be apreciate. ...

[Info-Ingres] ingres 2.0 to Ingres 2006
This is a multi-part message in MIME format. ------_=_NextPart_001_01C8836C.77ECD4C1 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable All =20 I'm going to unloaddb on Ingres 2.0 and then reload into Ingres 2006 =20 I have an open road 3.5 app, could I point that at Ingres 2006 without any issues? =20 Anyone know of any gotchas? =20 Cheers =20 Gareth Cymraeg:-=20 Mae'r neges hon yn gyfrinachol nad chi yw'r derbynnydd y bwriedid y neges= =20ar ei gyfer, byddwch mor garedig =E2 rhoi gwybod i'r anfonydd yn ddi-oed. Dylid ystyried un rhywd datganiadau neu sylwadau= =20a wneir uchod yn rhai personol,ac nid o angen rhaid yn rhai o=20 eiddo Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni= =20na chorff cysylltiedig. Cofiwch fod yn ymwybodol ei bod yn bosibl y bydd disgwyl i Ymddiriedolaet= h GIG Bro Morgannwg roi cyhoeddusrwydd i gynnwys unrhyw ebost neu=20 ohebiaeth a dderbynnir, yn unol ag amodau'r Ddeddf Rhyddid Gwybodaeth 200= 0. 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 th= e message then please notify the sender immediately.=20 Any of the statements or comments made above should be regarded as person= al and not necessarily those of Bro Morgannwg NHS Trust, any=20 const...

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. ...

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 ...

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: ...

[Info-Ingres] [ANNOUNCEMENT] ingres-2.2.1 (stable) Released.
The new PECL package ingres-2.2.1 (stable) has been released athttp://pecl.php.net/. Release notes ------------- This is a minor release that fixes the following problem: - Fix bug 16688 - EXECUTE PROCEDURE fails due to a missing "break" Package Info ------------- This extension supports the Ingres Relational Database System. Related Links ------------- Package home:http://pecl.php.net/package/ingres Changelog:http://pecl.php.net/package-changelog.php?package=ingres Download:http://pecl.php.net/get/ingres-2.2.1.tgz Win32 DLLs:http://esd.ingres.com/product/drivers/PHP/Windows_32-Bit/PHP_Driver README:http://cvs.php.net/viewvc.cgi/pecl/ingres/README.html?view=co&pathrev=RELEASE_2_2_1 Authors ------------- Grant Croker<grant.croker@ingres.com> (lead) -- Grant Croker - Ingres PHP and Ruby maintainer http://blogs.planetingres.org/grant If you put butter and salt on it, it tastes like salty butter. -- Terry Pratchett, Moving Pictures (regarding popcorn) ...

[Info-Ingres] AIX + Ingres 2.6 + OS Threads
hi, Is there anyone using AIX + Ingres 2.6 + OS Threads? Does it work fine? Our current configuration uses 10 dbms servers with shared memory and internal threads (7 for each server). We think about changing to OS threads, but in the past our experiences were not good (AIX + Ingres 2.0 + OS Threads). Any experiences are welcome! Thanks. -- Atenciosamente, Daniel Ordob�s Bortol�s N�cleo de Inform�tica Justi�a Federal - RS (51) 3214-9064 ...

[Info-ingres] 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 the -d flag, so the journal files don't exist for me that far back (to cover all of 2004). If I weren't using the -d flag, how far back would Ingres track Journal/Checkpoint information? Indefinitely? I have a limited amount of space in my jnl file system, so I doubt I could keep a year's work of jnl files for that database even if I weren't using the -d flag. Thanks, Troy -----Original Message----- From: Paul Mason [mailto:latepaul@gmail.com] Sent: Sunday, Jan...

[Info-Ingres] Ingres 2.6 for Linux on Sparc/Ultra 5 ???
Hi, Checked my log of messages for the last year or so on this forum but couldn't fing anything definitive on this particular subject, so I thought I would just pose a quick question - dumb as it may turn out to be. I've worked with Ingres on Sun/Solaris and Ingres on Intel/Linux, but now I have an Sun Ultra 5 on which I have installed Aurora 1.0 Linux (which is based on Redhat 7.x ported for Sparc machines) and would like to know if there is an Ingres flavour for this combo. Should I just install Ingres as for Unix but which release would be better - the Solaris r...

Web resources about - [Info-ingres] FW: [Info-ingres] File size (2 GB) limit when using AIX Version 5.1 with Ingres 2.6/0305 - comp.databases.ingres

Resources last updated: 2/21/2016 5:50:30 AM