The next Informix Chat with the Lab is on September 8th at 8am Pacific, 11am Eastern, with replication architect Madison Pruet talking about continuous availability in IDS 11.5..
Informix Chat with the Lab, Monday, September 8th 8 AM Pacific, 10 AM Central, 11 AM Eastern, 4 PM London, 5 PM Paris
IDS 11.5 Continuous Availability Feature (MACH 11)
The Continuous Availability Feature of IDS 11.5 offers easy and seamless deployment of applications on cluster solutions, providing a rich set of options for high availability (HA) with seamless scalability and lower hardware costs. Cluster nodes can be added dynamically, on demand, as workload increases on the cluster with client connections routed dynamically to any node in a cluster. Configuring, managing and adding cluster nodes are simplified with enhancements to the Open Admin Tool (OAT) that was discussed in the August Chat. Our speakers will be Jerry Keesee, Director of the Informix Lab and Madison Pruet, Senior Technical Staff Member and Informix Replication Architect.
RSVP for this Chat at: https://ww4.premconf.com/webrsvp/register?conf_id=4569387 For assistance by phone, call 800-289-0579 and refer to confirmation number 4569387.
Questions, comments, or to be removed from this distribution: lspina _at_ us.ibm.com[Read More]
Administrating and Developing with Informix
Since there is no command line finderr program supplied with IDS on Windows, and since the GUI finderr program supplied with CSDK doesn't work on Windows Vista or Windows Server 2008 without having to download extra files (we're working on that), here's a cheap and cheerful Windows batch file that will return the error description for an error number passed to it on the command line.
It takes advantage of one of the SQL Admin API commands introduced in IDS 11.10, PRINT ERROR, which will print the text for any error numbers:
Make sure IDS is online and grant connect permission to the sysadmin database for any user who runs it. Here are some examples of calling it:
If that doesn't cut it and you want more fancy search capabilities, consider using the BTS extension.[Read More]
Currently in week 2 of a Redbook residency in San Jose, working with a small team on the subject of "Embedding IDS".
IDS has some key features that lend itself to embedability, for example a small footprint, stability, low administration needs, the ability to run unattended for long periods of time, scalable performance. IBM has a significant number of partners, ISV's and customers who embed IDS in their applications, and we're seeing increasing interest in learning more about it, including best practices and how others are embedding IDS.
It's always good to get comments and opinions from people with experience in embedding IDS.. what do you think are the strengths of IDS in the embedded database market? What should we improve?[Read More]
There is a trend within IBM to move to using DVD as the standard software install media.
There has been talk about doing this within Informix before, partly because we're close to the maximum CD size on some platforms (where more than one copy of Java Runtime needs to be on the CD for example).
One advantage moving to DVD would provide is the ability to bundle additional components, for example Data Server Driver, which provides the Comment Client API's to connect to IDS via the DRDA protocol. Currently if you want components like this you would have to download them separately.
Once concern that has been raised is could this lead to bloating of IDS? E.g. if we're not so concerned about space might the install footprint go up? We would certainly have to be very careful about what is installed by default if we were to add components to the bundle.
Would anyone be inconvenienced if the IDS install media was no longer available on CD? If you see a problem with that please leave a comment or contact me. I am also curious as to what percentage of people download all their products electronically.[Read More]
There are some impressive new features coming into the next version of OpenAdmin Tool. Here's the blurb for a Chat with the Labs taking place on August 20th where the new features will get their first airing..
Informix Chat with the Lab - Wednesday, August 20th
8 AM Pacific, 10 AM Central, 11 AM Eastern, 4 PM London, 5 PM Paris
What's New with the OAT (OpenAdmin Tool), a graphical administration for IDS
Join one of our most popular speakers, John Miller, as he explores the capabilities and architecture of OAT, the OpenAdmin Tool. This will be an overview of the capabilities of OAT, highlighting such things as SQL Explorer, Performance History Graphs, Auto Update Statistics, and Space Management along with many other capabilities. Highlights of the architecture and what open source components are utilized within OAT conclude this talk. Jerry Keesee, Director of the Informix Lab will introduce the call and John Miller, Senior Technical Staff Member, will be our technical speaker.
You may RSVP for this call at: https://ww4.premconf.com/webrsvp/register?conf_id=4679866.
For assistance by phone, please call 1 - 800-289-0579 and reference confirmation code 4679866.
Questions, comments or to be removed from this distribution: lspina _at_ us.ibm.com
Just back from vacation and am now spending a couple of weeks working in San Jose on an IBM Redbook, where compared to Portland at least, it's hot.[Read More]