[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, January 16, 2005 4:32 PM To: Anderson, Troy E. Cc: info-ingres@cariboulake.com Subject: Re: [ingres] [Info-ingres] Dates users were created in Ingres Anderson, Troy E. wrote: > Hi, > > Does anyone know if Ingres tracks the date that a user was created (in > accessdb)? Is that contained in a system catalog, for example? I'd > like to figure out all new user accounts created in 2004... > > Thanks, > *Troy E. Anderson* > *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_ > > Try this - auditdb -a -table=iiuser iidbdb iidbdb should be journalled so this should tell you what you need to know. ...

[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 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, January 16, 2005 4:32 PM To: Anderson, Troy E. Cc: info-ingres@cariboulake.com Subject: Re: [ingres] [Info-ingres] Dates users were created in Ingres Anderson, Troy E. wrote: > Hi, > > Does anyone know if Ingres tracks the date that a user was created (in > accessdb)? Is that contained in a system catalog, for example? I'd > like to figure out all new user accounts cr...

[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 an option. Ahhh, I suggest cheetah. The fastest animal. 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 Andrews > Enviada em: Thursday, December 01, 2005 10:06 PM > Para: info-ingres@cariboulake.com > Assunto: Re: [Info-ingres] Re: What animal should Ingres be? > > It's kind of dissappointing that my comments about an animal logo and > Phoenix in particular have killed this discussion. Whatever I > think about > what was discussed, the branding of ingres is important. > > I do feel that a rebranding is required. Ingres as it has > been known is a > somewhat damaged brand and I think it needs a sidestep somewhere to ...

[Info-ingres] (Fwd) Re: SV: SV: SV: [Info-ingres] A varchar with no length
Hi Henrik > > Well in that case the conclusion must be that its reported and > solved in a solution number, and if needed There�s a patch > out-the-somewhere J Or at least a similar thing has been reported and solved. > > In your case it might be that the creation of the table was made > before the last patch to 9892 :-? Nice thought, but I already checked and this patch has been on the host since 2004 and this bug was first noticed 21st Feb, 2006. > Marty ...

[Info-ingres] RES: [Info-ingres] What animal should Ingres be?
Hi Richard, Look at this thread at ingres user forum: http://opensource.ca.com/projects/ingres/forum/10/155066963401/ 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 rthdavid > Enviada em: Monday, November 21, 2005 1:32 PM > Para: info-ingres@cariboulake.com > Assunto: [Info-ingres] What animal should Ingres be? > > If MySQL is a dolphin and PostgreSQL is an elephant, What > animal should > Ingres be? > > _______________________________________________ > Info-ingres mailing list > Info-ingres@cariboulake.com > http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres > "Leandro Pinto Fava" <leandro@unisc.br> wrote in message news:mailman.1132589521.13429.info-ingres@cariboulake.com... > Hi Richard, > > Look at this thread at ingres user forum: > http://opensource.ca.com/projects/ingres/forum/10/155066963401/ As I said in that thread, these animal motifs are just a bit juvenile and saccharine for my taste. Bring on the robust nudes I say. (Maybe Ingres Corp's benign dictator and pornographer-general will sort something out! :-) Roy ...

[Info-ingres] RES: [Info-ingres] Ingres Resources
> De: info-ingres-admin@cariboulake.com > [mailto:info-ingres-admin@cariboulake.com] Em nome de Paul Blondel > > 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. Thanks Paul. I will keep an eye on it. Regarding to Ingres Tech Notes, it looks like a dejavu. In 2004 Martin asked: http://groups.google.com/group/comp.databases.ingres/browse_thread/threa d/8ad47cd65aabee8c/01b0473789efb8f9?q=martin+bowes+supportconnectw+paul& rnum=1#01b0473789efb8f9 Regards, Leandro Fava DBA-SINF-UNISC http://www.unisc.br Presidente IUG-BR http://www.iug-br.org Fone: +55 51 3717 7636 ...

RE: [Info-ingres] Re: Ingres in the news
"I don't understand why they haven't held some sort of Ingres 2006 launch event for existing customers," he said. He's got it right there! Gareth -----Original Message----- From: info-ingres-admin@cariboulake.com [mailto:info-ingres-admin@cariboulake.com] On Behalf Of Roy Hann Sent: 13 July 2006 13:23 To: info-ingres@cariboulake.com Subject: [Info-ingres] Re: Ingres in the news <michaelnewport@yahoo.com> wrote in message news:1152788826.617260.137380@i42g2000cwa.googlegroups.com... > http://www.theregister.co.uk/2006/07/12/ingres_roger_bur...

[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] RES: [Info-ingres] RES: [Info-ingres] SQL Injection attacks
> -----Mensagem original----- > De: info-ingres-admin@cariboulake.com > [mailto:info-ingres-admin@cariboulake.com] Em nome de Emiliano > Enviada em: Monday, June 12, 2006 10:06 AM > Para: info-ingres@cariboulake.com > Assunto: Re: [Info-ingres] RES: [Info-ingres] SQL Injection attacks > > On 2006-06-12, Leandro Pinto Fava <leandro@unisc.br> wrote: > > Three years ago we had a case of SQL Injection against our web portal of > > students's info. This portal was made using ICE and reports in 1999 > > (with very bad security control). Now we have this portal made in PHP > > and the possibility of SQL injection is nearly null (I think :-(). We > > had another web application (ASP) that suffered a successful SQL > > injetcion too. The problems were corrected as well. > > And (to hook into the delightful discussion I'm having with Roy), I'll > bet you dimes to dollars that both were using query assembly. The ASP app was, but the ICE app was not directly. Report Writer internally should work with query assembly when passing parameters to run a report. > > The PHP function addslashes ought to protect you if you use it > consistently. PHP ADODb has parameter binds, which are better. Yes. > > > In our case the problems were in the application layer. > > HTML injection? No, when I said application layer, I wanted to say the problem ...

[Info-ingres] SV: [Info-ingres] Re: Disabling index for batch
Well if thats the situation an the Table is not Remodified its Could be because if each Insert Commits the Transaction Log Is either to small or it starts "emptying" it to late. Meaning after the Transaction log is "emptied" on a regular basis, there Room for a "refill". Check your CBF parameters for the size of Transaction Log, and At what Percentage it should do a CheckPoint (CP Interval / Logging-Derived) Kind regards, Henrik Georg S�rensen, Denmark -----Oprindelig meddelelse----- Fra: info-ingres-admin@cariboulake.com [mailto:info-ingres-admin@cariboulake.com] P� vegne af Cecil Westerhof Sendt: 8. juni 2006 09:27 Til: info-ingres@cariboulake.com Emne: [Info-ingres] Re: Disabling index for batch I am afraid I was not clear enough. Our client is changing from software versions and the old data (2 to 5 years) has to be converted. Normal operation is not a problem. The conversion is the problem. When we run the conversion for say two hours, then not for an hour, then again for two hours, ..., the conversion is faster then when we run the conversion in one run. This is the reason we would like to disable the index, but it is not possible, so we have to do it in little steps. _______________________________________________ Info-ingres mailing list Info-ingres@cariboulake.com http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres ...

[Info-ingres] SV: SV: [Info-ingres] A varchar with no length
It seems like it's still possible to create a table with our Ingres 2.6-release (patched uptil july 2005) but it's not crashing the server, or destroying a select, as it used to :-) Created on Ingres 2.6/0305 (axp.osf/00) Patch 10967 with this simple but stupid select. Anybody out there feel like testing on Ingres 2006? Create table hgstab as select table_type, dummy = null from iitables; Name: hgstab Owner: user Created: 22.03.2006 12:20:56 Type: user table Version: II2.6 Column Information: Key Column Name Type Length Nulls Defaults Seq table_type char 1 no n/a dummy varchar yes null copydb -c hgsdrop hgstab INGRES COPYDB Copyright 2003 Computer Associates Intl, Inc. Unload directory is '/users/backup'. Reload directory is '/users/backup'. E_AD2008 Datatype is variable length, but no length specification was given. There is one table owned by user 'user'. There are 0 sequences owned by user 'user'. Kind regards Henrik Georg S�rensen, Denmark -----Oprindelig meddelelse----- Fra: info-ingres-admin@cariboulake.com [mailto:info-ingres-admin@cariboulake.com] P� vegne af Paul Andrews Sendt: 22. marts 2006 11:53 Til: martin.bowes@ctsu.ox.ac.uk Cc: in...

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 [mailto:martin.bowes@ctsu.ox.ac.uk] Sent: Thursday, June 09, 2005 3:26 AM To: Kale, Mark (STP) Cc: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Re: Ingres stand-by database Hi Mark et al - gee this is getting interesting, > Jumping on on the thread late, but thought I would give a comment. > Each night we do exactly what you are saying. We do a production > checkpoint, transfer yesterday's journals and the config to the drp > server, and do a rollforward. We follow with full checksums. It is > not that hard to do. Absolutely so. But this is not a creeping or rolling = recovery. This sounds like a normal 'static' recovery to a foreign host. >=20 > We also have a custom-built Java replicator that reads yesterday's > journals from production, and applies certain table DML-only commands > on our reporti...

[Info-ingres] RES: [Info-ingres] CA World Ingres Sessions
> -----Mensagem original----- > De: info-ingres-admin@cariboulake.com > [mailto:info-ingres-admin@cariboulake.com] Em nome de David Richard > Enviada em: Friday, December 09, 2005 9:21 AM > Para: info-ingres@cariboulake.com > Assunto: [Info-ingres] CA World Ingres Sessions > Prioridade: Alta > > Hi Gang, > > Does anyone know where I can download copies of Ingres World > 2005 Ingres Sessions? Try this link: https://agendas.ca.com/sessionpresentation.asp Leandro Fava DBA-SINF-UNISC http://www.unisc.br Presidente IUG-BR http://www.iug-br.org Fone: +55 51 3717 7636 ...

Re: [Info-ingres] Re: Why Ingres?
This is a multi-part message in MIME format. --------------000509000805090406000507 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Since Postgres version 8.1 there is an autovacuum feature built into the server, so that's no longer an issue: http://www.postgresql.org/docs/whatsnew J�rgen Michael Leo <mleo@cariboulake.com> wrote: Jared Richardson wrote: [good stuff clipped] > 4) Postgres. You have to "vacuum" the database from time to time (daily or > weekly) to keep it running properly. It does have a lot of nice features, a > strong community, and it's free. > > In all fairness to Postgres, the "vacuum" thing everyone keeps mentioning isn't really any different than the MODIFYs we all do in Ingres to maintain well-balanced structures with optimal amounts of overflow. We have an internal business system the runs on Postgres. We like experimenting with products by actually using them. That REALLY tells you the story. There is no other way. This internal project is 6 years old and has seen the application and database move platforms and versions several times. For about 4 years, the "vacuuming" was not properly performed. Everything was fine, albeit increasingly sluggish. When I inherited the system (why always me?) I noticed the broken "vacuum" job and fixed it. Things were markedly better. But I ...

[Info-ingres] Re: RE: [Info-ingres] Unable to kill some sessions
Hi André, It seems not. This is the complete info from iimonitor Session 000000010ABFC580:29757 (Os_user ) cs_state: CS_COMPUTABLE cs_mask: CS_DEAD_MASK,CS_IRPENDING_MASK DB Name: Db (Owned by: dbowner ) User: dbuser (Os_user ) User Name at Session Startup: dbuser Terminal: batch Group Id: mygroup Role Id: Application Code: 00000000 Current Facility: OPF (00000004) Client user: Os_user Client host: remote_machine Client tty: remote_machine Client pid: 18831 Client connection target: node::db Client information: user='os_user',host='remote_machine',tty='remote_machine',pid=18831,conn='node::db' Description: JSQL/18831/dbuser Query: open ~Q cursor for INGSTMT0 for readonly using ~V , ~V , ~V , ~V , ~V , ~V Carlos >Is the state NOINT ? > Maybe it's rolling back. Sometimes that can take a while. >Andre >-----Original Message----- >From: <a href="javascript:sendMsg('info-ingres-admin@cariboulake.com');">info-ingres-admin@cariboulake.com</a> ><a href="javascript:sendMsg('[mailto:info-ingres-admin@cariboulake.com]');">[mailto:info-ingres-admin@cariboulake.com]</a> On Behalf Of <a href="javascript:sendMsg('izen...

[Info-Ingres] upgrade ingres to ingres 2006
This is a multipart message in MIME format. --=_alternative 005307E5C12572BA_= Content-Type: text/plain; charset="US-ASCII" who has tested ingres 2006 on hp ux 11 what are the drawbacks ? what are the compatibility issues Chris vergoote lisis 0478987106 --=_alternative 005307E5C12572BA_= Content-Type: text/html; charset="US-ASCII" <br><font size=2 face="sans-serif">who has tested ingres 2006 on hp ux 11</font> <br><font size=2 face="sans-serif">what are the drawbacks ? &nbsp;what are the compatibility issues</font> <br> <br> <br> <br> <br> <br> <br> <br><font size=2 face="sans-serif">Chris vergoote<br> lisis<br> <br> 0478987106<br> </font> --=_alternative 005307E5C12572BA_=-- ...

[Info-ingres] Ingres News :-)
This is a multi-part message in MIME format. ------_=_NextPart_001_01C6C06F.FAFB5151 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable News again - from Ingres Corp :-) Press Releases=20 August 15, 2006=20 Ingres Introduces Project Icebreaker at Linuxworld San Francisco = <http://www.ingres.com/news/2006-08-15_Icebreaker.html> =20 =20 http://www.ingres.com/news/2006-08-15_Icebreaker.html =20 Kind regards Henrik Georg S=F8rensen, Organisator, Denmark ------_=_NextPart_001_01C6C06F.FAFB5151 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)"> <style> <!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} /* 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; ...

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 have missed a point here, but... You do a backup of your production database and then only shove the journals over to the recovery host - not the checkpoint you just took. Then, after monkeying with the config file, you use the journals to do a rollforwarddb -c -b? Why? Why don't you use the checkpoint you just made on the production host, transfer those checkpoint tar files to the DR host and do a normal recovery? What have I missed? BTW. The -b flag on rollforwarddb has been subject to some bugs. Specifically relating to whether or not it represents the transaction commit time - as it is supposed to. Marty > Chloe, > > Thought I would chime in. We have a drp box configured almost > identically to production. We have a cronjob that copies over journal > files (not yet copied) every 10 minutes to our drp server. We set a...

[Info-ingres] SV: [Info-ingres] A varchar with no length
I've remember we had this issue in the year 2003 (on HP/Compaq TRU64 OSF, but can't remember if it was on 2.0 or 2.6 at that time) we're a colleque made a "Create Table" as select with one column defined as varchar(''). I've believe we've reported this issue (and later got a patch/solution). In our case we could just drop the table and re-write the specific conversion sql-script. Problem probable related to Create table new as select column1, column2, column3 = varchar("") from old; Kind regards Henrik Georg S�rensen, Denmark -----Oprindelig meddelelse----- Fra: info-ingres-admin@cariboulake.com [mailto:info-ingres-admin@cariboulake.com] P� vegne af martin.bowes@ctsu.ox.ac.uk Sendt: 21. marts 2006 14:12 Til: info-ingres@cariboulake.com Emne: [Info-ingres] A varchar with no length Hi Dudes, I'm running IngresII 2.6/0305 patch 9892 on int.lnx/00 Has anyone come across something like this before? I have a table with a varchar column but the varchar has no length. Note that its not a long varchar. eg. A help table shows... Column Information: Key Column Name Type Length Nulls Defaults Seq a1 integer 4 no no a2 varchar 40 no no a3 varchar yes null ...

[Info-ingres] SV: [Info-ingres] Invalid TID
Seems to remember i've got a similar Error-text the other day. It was caused by a update-from with a table of structure ISAM and when I 've changed that to BTREE it Showed up as Ambigious Replace, so maybe the reason is caused by that reason. Try to check out for Uniqueness of rows in a Update :-) Kind regards Henrik Georg S�rensen, Denmark -----Oprindelig meddelelse----- Fra: info-ingres-admin@cariboulake.com [mailto:info-ingres-admin@cariboulake.com] P� vegne af Laframboise Andre Sendt: 21. juni 2006 16:12 Til: 'martin.bowes@ctsu.ox.ac.uk '; 'info-ingres-admin@cariboulake.com '; 'BODH RAJ ' Cc: 'info-ingres@cariboulake.com ' Emne: RE: [Info-ingres] Invalid TID And as far as i know, only Ingres corp supply the patches.... -----Original Message----- From: info-ingres-admin@cariboulake.com To: BODH RAJ Cc: info-ingres@cariboulake.com Sent: 21/06/2006 9:58 AM Subject: Re: [Info-ingres] Invalid TID Hi BODH, Dude, what you've been given is a quick and easy workaround. You have not been given a solution. For solutions you need to pay for support from IngresCorp. Remember that in this case - you got lucky. Next time, you may not. Marty > Hi MArtin , > > Sure I will also do that !!! > > But i think i really do not require any ingres support > > when I have such nice expert helping friends on the > mailing list with all solutions for almost all > pro...

RE: [Info-ingres] RE: [Openroad-users] RE: [Info-ingres] Re: Migrating ABF code to J2EE
re: AppServer plug If anyone wants further inspiration on getting from ABF (or client server OR) to SOA and AppServer and the brave new world of clients that it opens up I did this talk at the last CAWorld (remember them?!) http://agendas.ca.com/agendas/SessionDetails.asp?SessionId=177 Whilst it over simplifies the process the reality isn't so far removed from the theory. As Paul points out, parts of the conversion can be automated; provided you use your brain to work out the tricky bits - popups in select loops, temporary tables etc - you'll be surprised at just how quickly you get results. And you can be as OO as you dare, from simple procedural services, through to a fully buzzword compliant domain/proxy/assembler/CAO/DTO/DAO/bpm/fa�ade SOA object-fest! If you pilot the approach on one functional area and move your data access plus some 'business logic' to AppServer that's a good start which enables 'quick win' web/mobile front ends which get the attention of management and hopefully the commitment to go further. For folk already in the fat client-server OpenROAD connundrum you can combine this approach with an eClient deployment of your app minus the SQL to begin with. http://www.iua.org.uk/conference/Spring2004/NeilWarnock_062004.pdf A cosmetic facelift at the same time probably wouldn't hurt, and again would get some buy-in from the bean counters et al. The devil is in the details and YMMV ...

RE: [Info-ingres] Database links in Ingres
Hi Steve, I presume you've successfully installed and started your star server and created your distributed db. Also you need a vnode pointing to the remote database (or local). Here's a simple example. createdb corp/star echo "create global connection tst mymachine wintcp II" > vnode.txt echo "create global login tst ingres mypass" >> vnode.txt netutil -file vnode.txt sql tst::testdb * create table blah (a varchar(10), b float); * insert into blah values ('abc',123); * commit; \g \q sql corp/star * register table corp_blah as link from * blah with node = tst, database = testdb; \g * * select * from corp_blah \g Executing . . . ?a ?b ? ?abc ? 123.000? (1 row) continue * If you haven't got star installed properly you may get something like this: C:\>createdb dummy/star Creating distributed database 'dummy' . . . Creating DBMS System Catalogs . . . Modifying DBMS System Catalogs . . . Creating Standard Catalog Interface . . . Creating STAR System Catalogs . . . Initializing STAR System Catalogs . . . Modifying STAR System Catalogs . . . Creating Front-end System Catalogs . . . Unable to connect to the STAR server. Please check your installation and see if a STAR server is up. Warning: Front-End catalog creation is skipped. You may use UPGRADEFE to create the Front-End catalogs for database dummy. Creation of distributed da...

RE: [Info-ingres] Ingres stand-by database
Hi Chloe, We used to do exactly this to keep our test server up to date with the data in the live environment. At no time did we intend to use the test server as a hot standby and I wouldn't recommend against it. Maybe ok if you want to allow your users to look at something in read-only mode whilst you recover the live server. It worked fairly well but it wasn't 100% and that's why I wouldn't use it. We've since turned off that functionality but it's nice to know how to do it. I'm with Marty on this one. Get some budget together to either duplicate at the hardware level or try your hand with replication. One of the posts mentions a good place to go hunting on the Newsgroup if you really want to pursue it. Regards Jon -----Original Message----- From: info-ingres-admin@cariboulake.com [mailto:info-ingres-admin@cariboulake.com] On Behalf Of martin.bowes@ctsu.ox.ac.uk Sent: 07 June 2005 10:53 To: chloe.crowder@bl.uk Cc: info-ingres@cariboulake.com Subject: Re: [Info-ingres] Ingres stand-by database Hi Chloe, There are means of doing this with rollforwarddb, I've certainly managed to make a creeping rollforwarddb, however.... Do you really want to use an unsupported means of recovering a database to make a hot standby? You would have to use your own code to support this and when you finally need the database and you find out how bad it may have been -- do you really want to go up to the bos...

[Info-ingres] Re: Ingres stand-by database
This is a multi-part message in MIME format. ------=_NextPart_000_0022_01C56C1F.7A7C2730 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I have been reading with great interest the ongoing discussion of the Stand-by Database using Checkpoints, Journals, Rollforward, Config files, etc. on a machine that is configured exactly the same as the server. We have been attempting to use one-way Ingres Replication to provide a stand-by database that is as current as possible (at the same transaction level) as the primary database server using immediate Replication Distribution (as opposed to distribution in ten minutes increments or once per day at night). Obviously this is not perfectly possible with Replication - we could always lose the "last" transaction if the network goes down at the exact point between the transaction commit on the primary server and the distribution (a separate transaction) to the target server. We are almost there with the Replication approach (not there yet), currently awaiting a CA Patch that does not take locks on the replication support tables during distribution. Yes, the Replication Server will lock certain tables causing possible conflicts (Deadlocks) with server transactions - conflicts that do not happen when the Replication Server (distribution) process is not running. We have also written an Online Replication Support Table maintenance program that hopefully...