Please note the new Flash Alert on the IDS Support website reporting security vulnerabilities addressed in the recent interim releases of Informix Dynamic Server.
The end results of an investigation by Next Generation Security Software (NGSS), who provided IDS Tech Support and Development sufficient time to fix all the issues they found before making any announcements, are tested and toughened interim releases of IDS across all current code branches (7.31, 9.40, 10.0). Upgrading to the latest interim is, needless to say, recommended.[Read More]
Administrating and Developing with Informix
Back in May I mentioned there may be a tech fair in Menlo Park later this year. I was a few miles out but if you're based in the California Bay Area mark your calenders for September 14th - the Bay Area Informix Tech Fair is going ahead in San Jose. This is an opportunity to spend a day learning about Informix topics from Advanced Support and Development engineers and meet other Informix users in the area. If you'd like to attend or have questions please RSVP..
FREE Informix Tech Fair
IBM Informix Advanced Support & Development Speakers:
Ajay Gupta, Guy Bowerman, Joaquim Zuzarte, Santosh Sajip, Suma Vinod,Vijay Lolabattu
Come and see demos integrating several application technologies.
Having a problem or question about Informix? Talk to an engineer and get free advice about your specific issue. Time is limited.
WHEN: September 14, 2006 9:15am - 4:30pm
4400 N 1st St, Suite 100
San Jose, CA 95134
A while back I briefly discussed how to set up High-Availability Data Replication (HDR) on a single Windows machine for testing purposes. One of my compadres has just written a much more in-depth guide to doing this which was published today - see: Setting up HIGH AVAILABILITY DATE REPLICATION (HDR) on a single installation of IBM Informix Dynamic Server on Windows.
If you prefer to do your HDR testing on UNIX try this older article instead: Setting up HIGH AVAILABILITY DATA REPLICATION (HDR) and ENTERPRISE REPLICATION (ER) on a single installation of IDS 9.40 for testing purposes.[Read More]
Received a speaker marketing kit for the IDUG 2006 Conference in Vienna today so now might be a good time to post a flyer for it. Note there is a chance to win a free registration on the website.
There's a diverse range of sessions listed. I'm signed up to deliver five presentations - IDS Internals for Windows, Application Performance, and three talks on Informix and Java - JDBC, JSP and J/Foundation - what was I thinking?
Conference aside, it's always a pleasure to take in some Austro-Hungarian architecture and a litre or two of Gold Fassl.[Read More]
A few months ago I logged a bug requesting that Solano be documented.
Solano has been in Informix Dynamic Server since around 9.30 and is the best IDS feature that no-one has heard of. (Ok there may be lots of better features no-one has heard of but lets not get bogged down in epistemology.) I wasn't holding my breath since I didn't provide a business case or customer request, just the argument that it's a potentially useful feature people should know about.
When a new interim version of IDS is released I'm sure the first thing you do is check the Documentation Notes for the J/Foundation Developer's Guide right? but for some reason I only just noticed that a reference to Solano makes an appearance in the 10.00.xC5 docnotes...
Dynamic Server has the ability to host a JAVA application server, such as an EJB container or custom HTTP server,within the database server by using a Solano-style database server connection string. For example:
So what does that mean?
It means that you can use Krakatoa (aka J/Foundation) to run a Java application that doesn't return, such as a webserver or application server, inside IDS. For example if you define a Java method that launches your app server and map it to a user defined routine, you can execute that routine to start the server and the application can listen on its own port, running in the IDS address space, and make internal database connections to the database of its choice. Another method (or the same one with a different argument) can be mapped to shut the server down.
This may not appeal to application developers used to the 3 tier client - app server - db server model but in some circumstances it can be useful. For one thing network overhead between the application server and data server is eliminated. Deployment can be simplified; you can write a self-contained application that can be installed by running an SQL script, rather than relying on installing and maintaining a third party application server. Security can be improved, for example you could reduce possible attack vectors by disabling socket connections into the data server and having all database access go via the Solano application which makes internal database connections. The most obvious disadvantages to this kind of application would be that you may not want to write your own application server, and having all your client network connections going to the data server may not fit your performance model, scalability is untested as far as I know.
At this point I should probably come up with some example code to show how this works, and contribute to the official documentation to make it more expansive. Will endeavour to do both of these in the near future.[Read More]
Was pleased to find another Informix blog, the Unofficial oninit blog.
You might want to learn some Japanese before reading it though. Being somewhat linguistically challenged I didn't understand much, but I understand a gargoyle saying "GA-HA-HA!!" when I see one. Or is that an Onigawara..
Update 7/20/06: I get it now, it's a Shisha![Read More]
Here's a 3rd revision of an ESQL/C script for Cygwin GCC on Windows. It's a bit neater with a case statement and some basic error checking thanks to some feedback from Jonathan Leffler. His feedback went much further in error checking, including calling an ESCAPE routine, for which he provided the source. For now I've left it as a standalone script with limited error checking but accept that a more production-ready version should have better error checking. If you're curious about the ESCAPE code, Jonathan will shortly be uploading it to IIUG.
This version adds support for some more ESQL/C arguments, and makes it easier to add new ones as required.
if [ $# -lt 2 ] ; then echo "$USAGE" exit 1fi
if [ -z $INFORMIXDIR ] ; then echo INFORMIXDIR not set exit 1fi
for i in "$@"do case "$i" in -ansi|-thread|-n|-nowarn) # pass some flags to pre-processor ECFILES="$ECFILES $i";; *\.ec) # select .ec file arguments for pre-processing BASE="$(basename "$i" .ec)" CFILES="$CFILES $BASE.c" ECFILES="$ECFILES $i";; *) OTHERARGS="$OTHERARGS $i";; # other arguments go to compiler esacdone
# pre-process .ec fileseval esql -p $ECFILES || exit 1
# pass processed files to compilereval $CC -I$INFORMIXDIR/incl/esql $CFILES $OTHERARGS \ $INFORMIXDIR/lib/isqlt09a.lib $INFORMIXDIR/lib/igl4n304.lib \ $INFORMIXDIR/lib/iglxn304.lib $INFORMIXDIR/lib/igo4n304.lib -mno-cygwin
There have been a few new Informix developworks and support articles in the last month or three. Here are my favourites: