Administrating and Developing with Informix
The IDS 11.50.xC6 virtual appliance is now available to download here:
This can be a very useful environment to test IDS 11.50.xC6 features since IDS is pre-installed and configured. It is also a ready to use development environment - the tools you need to do development are installed (CSDK, Data Server Drivers (incl JDBC, ODBC), PDO. Optim Data Studio.
IDS 11.50.xC6 had several new features you can become familiar with using this virtual appliance. A good place to see a summary of the 11.50.,xC6 IDS features is from a write-up that appeared in the Informix Zone blog: http://www.informix-zone.com/node/912
Note that several different editions of the virtual appliance are created, all are currently based on SLES 10 SP2 and all are free.
The choices are: 32 bit vs 64 bit. VMware Workstation format vs ESX. Self-extracting executable for Windows or Gzipped tar file.
Make sure you download the right one.
If you're a Java developer and you need JDBC 4 features like auto-loading, SQL exception handling enhancements, XML support, DataSet implementation of SQL, it makes sense to use the JDBC 4 compatible IBM Data Server Driver with IDS instead of the Informix JDBC driver. There are various other good reasons for switching to this driver, and the Feb 24 Chat with the Lab, starring the IBM JCC Development Manager Satheesh Bandaram, will look at the top 10. Below are the details..
Early Validation Program (EVP) releases of the next major release of IDS will be available to test soon. If you want to keep up to learn about and prepare for the very latest features this is a good opportunity to participate.
Here is the IDS Early Program announcement:
Also for more information about the program go here:
HP have released a new white paper entitled: HP Integrity Virtual Machines Online Migration with IBM Informix Dynamic Server 11.50 .
HP Integrity Virtual Machines provide the ability to migrate a running virtual system from one Integrity machine to another, keeping the application, workload, and operating system running on the system. This can be done on all Integrity servers and allows for (among other things) a very flexible operating environment, high availability and rapid provisioning.
This white paper takes you through the basics of Integrity VM, Online migration, IDS and what you need to know in terms of setting it up. It also takes the reader through a series of 9 test scenarios, including high availability scenarios such as HDR and IDS clustering technology (MACH11).
It's been a while since I've worked with the ZK programming language (or Rich Internet Application framework) so it was nice to get an opportunity to play around with the latest release. To ease myself back in gently I wrote a simple letter frequency analyzer to help with solving ciphers (note this post is not Informix-related for a change)..
The current release of ZK is 5.0 RC2, and I notice it is now split up into a free community edition, and commercial professional and enterprise edtions. The free edition no longer includes JFreeChart but fortunately it does include FlashChart which provides basic charting capability and is very easy to use. (Click on the image to view it full size):
The program is only about 40 lines so all the code can be self-contained in a single .zul file to be deployed under an app server such as Tomcat.
First I'll write the presentation layer which consists of a text box, a button and a chart:
Next comes the Java code that is executed when the "Calculate" button is clicked. This reads the text in the "targetText" texbox, counts the frequency of different letters and feeds it into a chart which is associated with the "chart" FlashChart:
That's it. In my case I created a "freq" directory under my Tomcat webapps path, copied the above code in as index.zul and created a WEB-INF sub-directory as per the ZK Quick Start Guide.
Overall I like the look and feel of ZK 5, it is smoother, faster and slicker looking than earlier editions.
Two useful IDS security resources have recently been published..
1. developerWorks Article:
Protect your data with Secure Sockets Layer support in Informix Dynamic Server, Part 1: Setting up SSL support in IDS by IDS security engineers Manoj Mohan and Lynette D. Adayilamuriyil .
This article takes you through the basics of setting up encrypted database communcation using Secure Sockets Layer (SSL), which begins with requesting a Digital Certificate. The digital certificate is used to exchange keys at the beginning of an SSL connection, after which a random symmetric key is generated. The article also has a section on troubleshooting SSL in IDS.
Update: The article is here.
2. Audio replay and slides available for IDS Security Best Practices chat with lab.
IDS Security Architect Jonathan Leffer presented this topic at the Chat with Lab series on December 16th. The audio replay and slides are now available here: http://www.ibm.com/informix/labchats
Happy 2010 (I need to get used to writing that so my checks don't bounce). The new decade brings new resolutions, including of course a forlorn hope of updating the blog with greater frequency.
HDR is a powerful Informix availability solution but it is important to set it up correctly and get reliabiliity without compromising high performance.
Lurking in my distended email inbox is an invite to the upcoming Chat with the Lab on Jan 20th, where tech support engineer Ron Privett talks about HDR Best Practices and Performance Tuning.
Below are the details on how to attend..
gbowerman 100000B5T0 3,856 Views
Adria Informix User Group Meeting 11/17/09
The Adria IUG president Hrvoje Zokovic sent me a note reporting on the 1st Adria Informix User Group Meeting..
Stockholm Informix User Group Meeting 11/16/09
After a busy week of meetings in the UK and Ireland I went to Stockholm to talk at the Stockholm Informix User Group meeting. I was a bit disappointed that it wasn't snowing but you can't have everything. The meeting started with an introduction from IBM Sweden's Information Management sales manager Fredrik Prien, followed by me presenting the IDS roadmap, then discussing embeddability, virtualization and cloud computing. Next up was Rickard Linck with a very detailed and informative talk on recent IDS features, followed by Ulf Åkerberg with an interesting talk on High availability demands at the Swedish Migration Board.
Speaking at this event turned out to be a lucrative endeavour, with all presenters receiving some bottles of Schnapps, Schnapps glasses and a scarf. Forgetting that the Schnapps was in my hand luggage and going through 3 sets of airport security to get home was challenging, but somehow I managed to bring them home without needing to drink them on the spot.
After the user group meeting most attendees decamped to a very pleasant Swedish restaurant for nourishment and bibulation..
One thing I like about Ubuntu is that everything is easy to install. Installing software, in the vast majority of cases, should be as simple as running a single command.
These packages have been developed for the Ubuntu 8.04 LTS (Long Term Support) release, but can be installed on the latest 9.10 as well (see below).How to add the Ubuntu partner repository as a source (Ubuntu 8.04)
I typically just vi /etc/apt/sources.list and uncomment the line for the partner repository. Then run "apt-get update" to retrieve the new packages lists. A more graphical way is to run the Ubuntu Package Manager and add a repository (click on these images to view larger versions)..
Once the partner repository is enabled you can see the Informix packages in the GUI Ubuntu Package Manager and install them directly:
Alternatively just use the commnand line. E.g. "sudo apt-get install informix-ids":
How to install on Ubuntu 9.10
Being lazy I am copying Alexander Koerner's 9.10 instructions from his Facebook entry (thanks Alex)..
In order to install IDS in Karmic Koala (9.10) you need to a) manually download and install the libstdc++5 from here http://packages.ubuntu.com/jaunty/i386/libstdc++5/download and b) add the Ubuntu 8.04 partner repository (deb http://archive.canonical.com/ubuntu hardy partner) to your preferred Ubuntu installer (e.g. Synaptic). Then select e.g. informix-ids-demo, start the installation and relax... ;-)
I've converted a laptop to Ubuntu 9.10 and like how easy installation and set-up was. I don't miss the early days of Linux when you needed to know about device drivers (ok I do a bit).
If you're going to learn about about HDR and RSS, you might as well learn it straight from the horse's mouth. The horse in this case being our resident high availability STSM Madison Pruet...