A question recently came up on the Ingres forums regarding the ability to query IMA to get a count and list of out bound sessions in the GCC servers. The former can be done using an existing IMA table, ima_gcc_info, like so: The latter is a bit more involved as there is no IMA table [...]
For those of you interested in learning how to use the Ingres Ruby driver I’ve uploaded a demonstration application to http://esd.ingres.com. The demo, entitled “Frequent Flyer” demo, is a stand alone application that uses the TK GUI controls via RubyTK bindings to provide the visual interface with the Ingres Ruby driver used to connect to [...]
Last week I pushed out a minor update for the Ingres Ruby driver to address issues seen in a soon to be published demo (more about that in another post). The changes in this new release are as follows: Fix #656 – getProcedureName() returns a non-NULL terminated procedure name Fix #653 – Update s.date dynamically [...]
As noted elsewhere this week saw the relaunch of the Ingres documentation site http://docs.ingres.com. At last we have the ability to deep link into the documentation without having to do acrobatics to extract links in the docs, for example http://docs.ingres.com/Ingres/9.3/Database%20Administrator%20Guide/largedataloadswsetnologgingstatement.htm has become http://docs.ingres.com/ingres/9.3/database-administrator-guide/1757-large-data-loads-with-the-set-nologging-statement To get the URL for the first required some navigation of the [...]
Over the last couple of days I’ve done couple of Ingres installations using the latest, bleeding edge, RPMs and have come across a change in behaviour that might catch you out, as indeed it did me. What follows is a more or less verbatim copy of the output from an install of the latest SVN [...]
(Picked up from the forums). Ingres are broadcasting live webinars for Ingres VectorWise, starting this week. The first is entitled ‘Welcome to Ingres VectorWise” Join our Ingres System Engineers as they share a high-level overview of the Ingres VectorWise technology including a demonstration of the product. Find out more about this new feature and to [...]
Thanks to Andrew Ross and FOSSLC, the Ingres VectorWise demo from this year’s UK IUA conference can be seen below or via Vimeo.com (Flash is required).
History what? For some time the Ingres terminal monitor has had the, slightly cryptic (to me at least), flag “-history_recall”. This flag allows you to use the cursor keys within a terminal monitor session to scroll through previous queries and edit them in-line. Users of Ingres on Windows have been able to do this by [...]
For new users to Ingres quitting from the Ingres terminal monitor, tm or sql, just got easier. With change 2901 the terminal monitor has gone from this: to: No more ninja skills needed for executing a query or to escape from the terminal monitor.
Ingres’s OpenAPI C interface can be challenging at times especially when it comes to debugging or reading an API trace. For example, right now I’m trying to debug a problem in the PHP driver for Ingres. For some reason during the tear-down of the request the driver is unable to close a statement. Turning to [...]
Ingres Newsgroup Community Forums