RE: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails
Check the SQL Server Agent account has permission to access your database. Running from enterprise manager could run using a different user context to scheduling via SQL Agent depending on the accounts configured to run the SQL Server Service and that of the SQL Agent.. Geoff -----Original Message----- From: Steve [mailto:SMaxwell@NationalExpress.com] Sent: Tuesday, April 25, 2006 10:45 AM To: info-ingres@cariboulake.com Subject: [Info-ingres] Scheduled SQL Job pulling from Ingres Fails Hi All, I have a DTS job to pull data out of an ingres database. When I run this job manually through enterprise manager, it runs perfectly, when I schedule it, it fails. I've found a Microsoft KB on a similar problem that didnt help. Has anyone had this before? What did you do to resolve this? Cheers, Steve Technical Bumf: Intel Ingres II running on Windows 2003 Server, SQL Server 2000, SP3. _______________________________________________ Info-ingres mailing list Info-ingres@cariboulake.com http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres ********************************************************************** The information contained in this e-mail is confidential and intended only for the use of the addressee. If the reader of this message is not the addressee, you are hereby notified that you have received this e-mail in error and you must not copy, disseminate, distribute, use or take any action as a result of ...

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

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

[Info-ingres] RES: [Info-ingres] Re: What animal should Ingres be?
Hi Paul, I agree totally with you Ingres needs a promotion strategy (urgently). For me the one of the main issue to try change this "perception" is to promote the use of Ingres for ISVs. There are many of then adapting their software to use open source technology (OS, Database, Development tools, etc.), and this is a great opportunity to grow up the use of Ingres. Here I know around ten software vendors (medium size) which are doing this move. And most of then are moving to use MySQL, PostgreSQL and Firebird. Unhappily, Ingres is so unknown it is not being considered a...

[Info-ingres] SV: [Info-ingres] Re: Ingres in the news
Well in the updated profile for Mark Berrenchea (www.ingres.com Board of Directors) after he switched from CA to Garnett & Helfrich, and Sam Greenblatt takes over of CA's Board membership it says that he's now responsible for Europe, Asia so hopefully something will happen in the close future, But as all others we're waiting. Mark Barrenechea joined Garnett & Helfrich Capital as a director effective June 19, 2006. Barrenechea will help expand the firm's investments into Europe and Asia in the emerging segment of Venture Buyouts, partnering with large technology co...

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

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] Re: What animal should Ingres be? #2
Can't agree more with you Paul. I would be sceptical of something that is billed as rising from the ashes as it implies it was a pile of crud in the first place, and yes, it's very cheesy too. If Ingres Corp are serious about this animal logo then they should be thinking clearly what message they want it to portrait. Is it to symbolise the product ethos? Is it to align the product within an industry sector? Or maybe they want it to capture the public imagination? It should also be tightly integrated into Ingres Corp's marketing strategy, which makes me think that this ...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hello Mikey, SQL/J. Again. Gawd ... Michael Leo <mleo@cariboulake.com> wrote: >Mike Schilling wrote: > >>"Michael Leo" <mleo@cariboulake.com> wrote in message >>news:mailman.1133916120.16345.info-ingres@cariboulake.com... >> >> >>>Emiliano wrote: >>> >>> >>> >>>>On 2005-12-06, Paul Andrews <ac297@dial.pipex.commmmm> wrote: >>>> >>>> >>>> >>>> >>>> >>>>>I assume roy is thinking a...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, Michael Leo <mleo@cariboulake.com> wrote: >Sorry. I lied. Not my last word. The missile missed. Packer >fans are happy in heaven. > Given the Packers' performances this season ... >Roy Hann wrote: > >>"Michael Leo" <mleo@cariboulake.com> wrote in message >>news:mailman.1134079081.15832.info-ingres@cariboulake.com... >> >> >> [snip] >> >>I am sure that happened, but my recollection of the same era is that it was >>the lack of row-level locking that got everyone all twi...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi Mike, Michael Leo <mleo@cariboulake.com> wrote: [ lots of very true stuff about Java snipped ] A lot of what you say about Java is very true; in our shop, we have Java bytecode bouncing between Windows, Solaris, AIX and Linux. Any issues we've bumped into have been JVM implementation issues, not problems with the bytecode itself. And a JVM might open up some other interesting possibilities for sickos like me - JIProlog, anybody, or maybe even ML/J ? However, for the task at hand, my main gripes can be enumerated as : - the core Java language is weak (generally, and ...

RE: [Info-ingres] Re: Ingres stand-by database
This is a multi-part message in MIME format. ------=_NextPartTM-000-bba2044a-af8b-45e6-a531-d80e6c174589 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C56CF8.D5A2691A" ------_=_NextPart_001_01C56CF8.D5A2691A Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <?xml version=3D"1.0" ?> Yes, auditdb binary output is piped into the Java program the builds the = JDBC commands to execute them. A unique key is required. -----Original Message----- From: martin.bowes@ctsu.ox.ac.uk [m...

RE: [Info-ingres] Re: Ingres article #2
At 9:59 AM +1100 2/3/2006, Paul White wrote: >When CA announced they were moving their internal systems to SAP the >obvious question was asked - are they going to run SAP over ingres? I >wonder if this is one of the drivers. >Paul > This is strictly hearsay, but I seem to recall hearing that CA decided to run SAP on DB/2. They have some hard time constraints with very VERY severe penalties for missing deadlines. I have no idea how seriously SAP on Ingres was discussed at the time. Even if Ingres were a drop-in, I can't imagine a CA executive deciding to start...

RE: [Info-ingres] Re: How Different is Ingres? #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_01C5820F.3450AD70 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit > -----Original Message----- > From: David Richard [mailto:Richard.David@aah.co.uk] > Sent: 06 July 2005 09:49 > To: info-ingres@cariboulake.com > Subject: RE: [Info-ingres] Re: How Different is Ingres? > > Postgres' Multi Version Concurrency Control (MVCC) is explained here http://www.develope...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, I wasn't going to respond to this point by point, but my general point in this discussion is based on choices. Some people want to be able to use Java in the server. Other people want to be able to use C# in the server. I want to be able to use R (say), and others may want to use Foolang, whatever they like. I don't think we should, at this point, be going down a "any colour you like, so long as it's black" route for this. We all agree it's going to be a hang of a lot of work to do *anything* in this area; I'd just like to make that load of work as ge...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, "Paul Andrews" <ac297@dial.pipex.commmmm> wrote: >Oops, the database procedural language debate has turned into some kind of >academic discussion and is in danger of dissappearing up it's own posterior. > Isn't that pretty much what these types of discussions are for ? >Here's some ill-informed thoughts of my own. > >We're debating something, not even sanctioned by ingres corp. Welcome to open source. With the source available, we don't really need to ask for permission about this sort of stuff. The open sourc...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, "Roy Hann" <specially@processed.almost.meat> wrote: >"Emiliano" <Emiliano@Iris-Advies.nl> wrote in message >news:d395$43973fce$3ec29f9d$4203@news.chello.nl... >> Tonyd08068@netscape.net wrote: >> >> > If we're going to go to all that hassle, why not take a leaf out of the >PostgreSQL book and > >> I don't really care whether it's java, or python, or C#, or Tcl or even >> lisp; it's just that many of the developers around me that have grown up >> on the 'regular' ...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi there, Emiliano <Emiliano@Iris-Advies.nl> wrote: >I don't really care whether it's java, or python, or C#, or Tcl or even >lisp; it's just that many of the developers around me that have grown up > on the 'regular' procedural and/or OO languages find Ingres' SP >language arcane. > I don't really care what language folks want to use either; that's why I think the choice should be left open. Individual sites will no doubt choose a standard, but that standard may vary. I've never found the syntax of the procedure lan...

Re: [Info-ingres] Re: What animal should Ingres be? #2
Hi Mike, Michael Leo <mleo@cariboulake.com> wrote: [ snippage ] >Tony, > >You inspired me to look at how PostgreSQL does it. >I'm liking what I see, but I can't seem to find anything about >a Java binding. > The two I had a brief look at were PL/Java - http://gborg.postgresql.org/project/pljava/projdisplay.php PL-J - http://plj.codehaus.org Both seem to be reasonably current, so there is very probably some horrible, wrinkly difference between the two - otherwise they wouldn't have any justification for hanging around. PL/Java seems t...

RE: [Info-ingres] Re: What animal should Ingres be? #2
I've been following it all the way, it's great but it's missing something?! Imagine a thread this long and Marty hasn't said anything! C'mon Marty, lets hear something incisive and witty on this topic!!! ;-) Finn -----Original Message----- From: Roy Hann [mailto:specially@processed.almost.meat] Sent: 13 December 2005 08:55 To: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Re: What animal should Ingres be? ************************************* This e-mail has been received by the Revenue Internet e-mail service. ************************...

RE: [Info-ingres] Re: How Different is Ingres? #2
Hi there, >I can't see why a similar locking option couldn't be added to Ingres in >time?? > Hmmm.... way back when, Postgres had a feature called "time travel", where you could consciously step back to older versions of rows of data to see how it used to look. At this time, it still used conventional locks. Around version 6.5 (6.5.2 ?) the time travel feature was dropped and converted into MVCC, and traditional spinlocks were dropped as the default mechanism (you can still get them by doing "select for update", IIRC) The thing is that Postgres ...