Re: IDS Next Version - features wanted.
k, one thing at a time - your post seemed to imply that IDS could not access from remote IDS instances and that federation would be the feature to implement in order to achieve this: this is not the case, and V7 can do 2PC across instances (or just databases) as it is, while DB2 requires federation to achieve this - Yes I was referring to Informix Enterprise Gateway - XPS has external tables, which essentially is a mechanism to access to files of various descriptions. the syntax allows to fragment external tables across multiple streams, etc: look at it as HPL, the XPS way. The feature is in fact more flexible than HPL, in that is purely based on SQL - VTI/VII: as Jean Sagi said, the down side is that you have to write the access methods yourself (I would have thought this to be an advantage?! as in, the engine doesn't do what you want, so go and write it yourself, and you have no excuse to complain about open source/licensing issues, $$$, and hey! you could even make a few $$$ yourself?!) - however the feature is rather powerful: eg you could write an access method that lets you see a process as a table, through say some IPC. then use insert triggers to notify the process of database activity, and select from the virtual table to get responses from the process. you could even use select triggers to (say) monitor who's done IPC with that particular process, and when.... of course you could just write a UDR to achieve most of that, but the above is more elegant and flexible. manuals here http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp (under Developing/Developing extensions to IDS) or here http://www-306.ibm.com/software/data/informix/pubs/library/list5.html#V an example of a flat file access method here http://www-106.ibm.com/developerworks/db2/zones/informix/library/demo/ids_ffvti.html gsturkenboom@lic.co.nz wrote: > You're right. I'm on IDS V7 - don't ask! > > Perhaps you would be good enough to point me at some documentation which > describes how I can do something like ... > > Select a.*, b.*, c.* > from <informix table> a, <oracle table> b, <db2 table> c > where a.col3 = b.col1 > and a.col4 = c.col1; > > Is this the Informix Enterprise Gateway product? If so I find it somewhat > invasive on the external environment. > I have'nt looked at XPS. Does this do it? > The virtual table/index interface sounds promising. Where can I get info on > that? > > > > > > > Marco Greco > <marco@4glworks.c To: gsturkenboom@lic.co.nz, informix-list@iiug.org > om> cc: > Sent by: Subject: Re: IDS Next Version - features wanted. > owner-informix-li > st@iiug.org > > > 01/06/2005 20:52 > > > > > > > you obviously haven't gone beyond a standalone online 5? IDS v7 has had 2PC > > (to and from any informix version, including xps, of late) since 1995 or > there > about, and with none of the federated complexity - you just do it without > having to create anything. > And you could do that kind of stuff with online 5 too, if you bought the > I-Star addon.. > > XPS has had external (as in file system, and multiple formats supported) > tables since day one, while V9 has had a virtual table interface and > virtual > index interface since 97 I believe. you can create table representation of > > just about anything:- from directory structures, to pipe delimited files, > to > cisam files, to oracle databases, to ... you name it, it can be done. > True, you don't get that many prebuilt access methods, but that doesn't > mean > to say that a very powerful feature isn't there... > > And gateways have been around for quite some time, anyway > > gsturkenboom@lic.co.nz wrote: > >>Federation as per DB2. The ability to access external databases such as >>other Informix databases on different instances, and oracle, DB2 > > databases > >>etc. Also the ability to access flat files and spreadsheets. This is done >>in DB2 II with federated objects such as wrappers, servers, user mappings >>and nicknames. Refer to DB2 Information Integrator (DB2 II) > > documentation. > >>After all they (Informix and DB2) are both owned by the same company. >> >> >> > > >> Jonathan Leffler > > >> <jleffler@earthli To: > > informix-list@iiug.org > > >> nk.net> cc: > > >> Sent by: Subject: Re: IDS Next > > Version - features wanted. > >> owner-informix-li > > >> st@iiug.org > > > > >> 31/05/2005 17:53 > > >> Please respond to > > >> Jonathan Leffler > > > > >> >> >> >>gsturkenboom@lic.co.nz wrote: >> >> >>>Federation. >> >> >>Please define what you mean by that. >> >> >> >> >>>david@smooth1.co.uk wrote: >>> >>>What features do you want for the next version of IDS? >>> >>>The Key Features in IDS Version 10.00 by Jerry Keesee >>>mentions... >>> >>>- Smooth Upgrade of HDR >>>- Online table re-org >>>- Dynamic Reconfiguration >>>- Auto Update Stats >>>- Auto Disk Mgmt >>>- RAS >>>- Autonomics >>> >>> >>>a) What does Smooth Upgrade of HDR mean? >>> >>>b) What else do people want as features? >> >> >> >> >>-- >>Jonathan Leffler #include <disclaimer.h> >>Email: jleffler@earthlink.net, jleffler@us.ibm.com >>Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/ >> >> >> >> >> >>sending to informix-list >> > > > > -- > Ciao, > Marco > ______________________________________________________________________________ > > Marco Greco /UK /IBM Standard > disclaimers apply! > > Informix faq > http://www.iiug.org/techinfo/faq/informix.htm > 4glworks > http://www.4glworks.com > Informix on Linux > http://www.4glworks.com/ifmxlinux.htm > > sending to informix-list > > > > > > sending to informix-list > -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Informix faq http://www.iiug.org/techinfo/faq/informix.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm sending to informix-list