If you usually check the Informix blogs, you've probably notice that IBM will present a virtual event on February 25th. This event is about Information Management, not necessarily focused on a specific product. Accordingly to the announcements you'll have the opportunity to chat with several specialists. You can see more information on Guy Bowerman's blog. The event registration can be found here.
Meanwhile, a colleague from France, Laurent Valenza is involved in the proof of technology that will take place in Paris on March 12. It will include hands on tutorials, and presentations about migration, MACH 11 and Open Admin tool. Please check the detailed agenda and the confirmation email at IIUG's page: http://www.iiug.org/news/announcements/pot_12mar2009.php
I had the pleasure to meet Laurent in 2008 and I'm sure his contribution will make this event worthwhile.
To finalize this post, a reference to a document Eric Hebert posted on his Informix Zone site. It's a translation to English of an interview of Jerry Keesee to Czech ComputerWord.
Please check it at: http://informix-zone.com/node/678.
If you prefer the original version, check it here
Sunday, February 8, 2009
Sunday, February 1, 2009
Informix academic initiative...
I've just received the IIUG Insider and one of the subjects that caught my attention was the news about Informix on Campus Academic Initiative.
A few people related to IIUG and some IBM staff are working together to bring Informix into the Academic community. Many people believe a software product needs to gain traction in the Academic world. The basic idea is that we all tend to work with what we know. And the Academic environment is an excellent place to learn about products.
IBM has programs for showing it's products to the Academic community but Informix has not taken advantage of this yet.
These people is working to change this. To start with, they put up a public and free (no registration needed) survey. If you're interested in this topic, please take five minutes to answer it (it really won't take more than this). You can give your opinion, suggest institutions to participate (if you have their contacts), and you can even volunteer yourself to help!
A few people related to IIUG and some IBM staff are working together to bring Informix into the Academic community. Many people believe a software product needs to gain traction in the Academic world. The basic idea is that we all tend to work with what we know. And the Academic environment is an excellent place to learn about products.
IBM has programs for showing it's products to the Academic community but Informix has not taken advantage of this yet.
These people is working to change this. To start with, they put up a public and free (no registration needed) survey. If you're interested in this topic, please take five minutes to answer it (it really won't take more than this). You can give your opinion, suggest institutions to participate (if you have their contacts), and you can even volunteer yourself to help!
Tuesday, January 27, 2009
Be the first to check 11.50.xC4
After a long time without posting (usual lack of time) I decided to take five minutes to make an echo of some nice news. I already heard about plans for IDS 11.50.xC4 around April this year, but nonetheless I was surprised by today's IIUG's announcement.
Accordingly to this news, any customer wanting to get in touch with the next release of IDS will be able to do so, after agreeing to the usual conditions.
In the announcement we can see the major features for this new version:
Stay alert and consult the IIUG (International Informix Users Group) site for more information.
Once again IIUG shows great collaboration spirit with IBM on promoting IDS.
You should also take a look at the next Chat with the Labs (January 29). Jerry Keesee, Director of the Informix Lab, will talk about recent Informix activities and also about the roadmap for 2009.
To register go to:
https://ww4.premconf.com/webrsvp/register?conf_id=4834295
Accordingly to this news, any customer wanting to get in touch with the next release of IDS will be able to do so, after agreeing to the usual conditions.
In the announcement we can see the major features for this new version:
- Compression
- Easy administration, setup & monitoring of Enterprise Replication with the Informix OpenAdmin Tool
- Improved embedability
- Support for the Amazon EC2 computing environment
- Support for VMWare Virtualization Infrastructure and Desktop solutions
Stay alert and consult the IIUG (International Informix Users Group) site for more information.
Once again IIUG shows great collaboration spirit with IBM on promoting IDS.
You should also take a look at the next Chat with the Labs (January 29). Jerry Keesee, Director of the Informix Lab, will talk about recent Informix activities and also about the roadmap for 2009.
To register go to:
https://ww4.premconf.com/webrsvp/register?conf_id=4834295
Friday, October 31, 2008
11.50.xC3: another pack of features...
IBM has just made available IDS 11.50.xC3. Traditionally, fix packs include bug fixes and eventually some minor improvements. I believe the concept of "minor" may have to be revised when it comes to IDS fix packs. Let's see what the good fellows of R&D decided to put into this release:
I look forward to the next release/fix pack which I bet will bring some more great improvements!
- MAX OS X improvements:
- Silent installation
- Ability to create Data Source Names (DSN)
- Enterprise Replication improvements:
- Dynamically change Enterprise Replication (ER) configuration parameters in the Onconfig file
We can now do this using commands like cdr add onconfig, cdr change onconfig, and cdr remove onconfig - Improved Consistency Reporting after Enterprise Replication Repair Operations
The repair jobs have an option that forces the retrying if inconsistencies are found at the end of the jobs - Administering and Monitoring Enterprise Replication with SQL Admin API
The SQL admin now allows us to run cdr commands through SQL - Ability to change ONCONFIG parameters with SQL Admin API
SET ONCONFIG for session change and SET ONCONFIG PERMANENT for Onconfig and session change (session here means the current instance configuration and not client session) - Three new dynamically changeable ONCONFIG parameters:
LTXEHWM, LTXHWM, and DYNAMIC_LOGS - Improved SQL Tracing with the SQL Admin API
From now on we can define which databases, sessions and users will be traced. This gives higher control on the SQL tracing facility. We can also suspend and resume the SQL tracing (without loosing previously set specifications) - Changing the Size definition of the First Extent of a Table
Now we can establish a new definition for the first extent size of a table. Note that this will not change it's physical layout. It will be used if you extract the table schema, rebuild the table (by specifying a new fragmentation clause) or if you truncate the table with the reuse clause - Implementation of SAVEPOINTs
SAVEPOINTS are an SQL standard that allows the programmer to establish some points after the begin of a transaction to where he can ROLLBACK. Imagine that you're running a batch file, processing several customers in a FOREACH cycle. You may want to do all the customers as a unit, so you would COMMIT at the end. But also consider you want to do several DML operations for each customer and that you accept that you can skip a customer, but not one or more operations within a customer. To put it simpler, if one operation on a customer fails you want to skip it, but continue with the transaction. With this feature it's possible. You just have to set a SAVEPOINT after each customer. If something goes wrong in the next customer, you can ROLLBACK WORK TO SAVEPOINT and continue with the next customer (maintaining your main transaction open). - Basic Text Search DataBlade Module Supports High-Availability Clusters
In previous versions, the indexes created by the BTS needed to be created in external dbapces. This would mean that you couldn't use BTS searches on secondary nodes unless you used some (officially unsupported) external way of synchronizing these external spaces within the cluster hosts. Now, you can create these indexes in smart blob spaces, which can be logged, and thus can be replicated to all the cluster nodes - Querying XML Attributes with the Basic Text DataBlade Module
BTS now supports another index creation parameter that specifies that the XML attributes (on XML tags) should be indexed (and thus become available for searches) - Setting the Frequency of Error Checking for Smart Large Object Transmission
A new environment variable called IFX_LOB_XFERSIZE was introduced to specify the interval (in bytes) that will trigger error checking for SLOBs. After this amount of bytes the data will be checked for transmission error (between client and the database server). If it finds any errors it aborts with an error. Without this variable the checking is made only after the end of the transmission
- An RSS feed with updates to the Information Center
- Search engine add-ons for browsers, so that you can directly search on IBM Informix Information Center for your specific version
- An extended section with links for community sites. This includes forums, general sites, wikis and blogs about Informix. The Informix-Techonology blog is one of the additions to this list. I face this as an honor and a great responsibility. It's also a great incentive to keep the work that I started more than one year ago.
I look forward to the next release/fix pack which I bet will bring some more great improvements!
Tuesday, October 28, 2008
Encryption: All your (data) base are NOT belong to us!
If you were growing up during the personal computer boom you may notice that the title of this post is a joke with another joke. For details on that check the Wikipedia or the flash animation.
This is just a pretext to introduce a very serious subject. You probably know that Informix IDS can encrypt column data, but you may also know that it has some disadvantages (you cannot index encrypted data, you may have to change the applications etc.). There's nothing wrong with column encryption, but as with most of the features is has advantages and disadvantages.
Another option for encryption is to encrypt the files containing the data (chunks in IDS language). This brings up several questions:
IBM has just released fixpack 1.1.3 of this product, which is the first version to support IDS (versions 11.10FC2 and 11.50). You can get more info about it at the product page ( http://www.ibm.com/software/data/db2imstools/database-encryption-expert/ ).
Up to now, it was certified for use with DB2, so it's probable that you find several references of the two products together. One of them which I find interesting, is a video showing it working with DB2, by Belal Tassi, a colleague from IBM Information Management:
As you can see from the product page, the fixpack Readme and the video above, it's transparent for the database, for the application and it can be setup to be safe even from root. It's also able to encrypt backups (it would be a breach of security to have your data encrypted and keep your backups without encryption). Hint: Version 11.10 introduced backup and restore filters...
The platforms supported at the moment are:
This is just a pretext to introduce a very serious subject. You probably know that Informix IDS can encrypt column data, but you may also know that it has some disadvantages (you cannot index encrypted data, you may have to change the applications etc.). There's nothing wrong with column encryption, but as with most of the features is has advantages and disadvantages.
Another option for encryption is to encrypt the files containing the data (chunks in IDS language). This brings up several questions:
- Performance
If you're doing data encryption you're consuming CPU cycles - Ease of use
Is it transparent to the database? And to the application? - Privilege users access
Can root work around the encryption? Usually, being root is like being God...
IBM has just released fixpack 1.1.3 of this product, which is the first version to support IDS (versions 11.10FC2 and 11.50). You can get more info about it at the product page ( http://www.ibm.com/software/data/db2imstools/database-encryption-expert/ ).
Up to now, it was certified for use with DB2, so it's probable that you find several references of the two products together. One of them which I find interesting, is a video showing it working with DB2, by Belal Tassi, a colleague from IBM Information Management:
As you can see from the product page, the fixpack Readme and the video above, it's transparent for the database, for the application and it can be setup to be safe even from root. It's also able to encrypt backups (it would be a breach of security to have your data encrypted and keep your backups without encryption). Hint: Version 11.10 introduced backup and restore filters...
The platforms supported at the moment are:
- AIX (64-bit):
- Linux (64-bit): Red Hat Advanced Server 4.0 Update 4
- Solaris 9
- Solaris 10 update 2
- Windows
Supported file systems
- Windows: NTFS
- AIX: JFS, JFS2, NFS, VxFS
- Solaris: UFS, NFS, VxFS
- RedHat: EXT3, NFS, VxFS
Labels:
Database Security Expert,
encryption,
informix,
PCI,
PCI DSS,
Vormetric
Monday, October 27, 2008
Too many subjects...
Yes... Fortunately it's true: I can't keep up with everything that's been hapening....
In this post I'll mix a lot of topics. They've been covered elsewhere, but for the record, a few comments:

In this post I'll mix a lot of topics. They've been covered elsewhere, but for the record, a few comments:
- Carlton Doe, a well know name within the Informix community, has published a new book. It's called Administering Informix Dynamic Server: Building the Foundation. You can find it at Amazon. I don't have a copy yet, but I look forward to check on the contents. Given the author's history on Informix and previous work this book should be a safe investment
- IBM has made available an Informix Virtual Appliance. This is essentially a virtual machine pre-configured with a lot of Informix software (IDS of course, Client SDK, JDBC driver, Spatial Datablade, Open Admin Tool, Data Server Drivers - JDBC/ODBC, and finally Data Studio). All running on top of SUSE Linux Enterprise Server 10 SP2. All you need to run it is a copy of one off the VMWare players. You can get a complete explanation and download instructions on Guy Bowerman's site
- IBM started another initiative. It's called the Data Champion Program. The idea is to publicly recognize individuals who have made strong contributions to the Data Management community. The program website is located at http://www.ibm.com/software/data/champion. Today, Mr. Arvind Krishan announced at IBM Information On Demand 2008 conference (IOD) the inaugural champions.
I'd like to congratulate all of them, with just one special note to Eric Herber for his wonderful job at Informix Zone ( http://informix-zone.com).
You can nominate other champions on the program's website above until January 31, 2009. - Speaking about IOD, the IBM Information On Demand 2008 conference, it started yesterday and you can expect some important news. For now, on the light side, there are a lot of Informix tattooed people there... Take a look at this photo for example, courtesy of Jean George Perrin, showing a familiar face for the Portuguese Informix community, with a "quality stamp on the forehead" :)

- One of the IOD news is about SolidDB. As you probably already know, Solid was acquired by IBM, and produces a product called SolidDB that can act as a cache for DB2 and Informix. SolidDB is an in-memory database, meaning it can speed things quite a bit. In this press release, IBM announces that it now supports RDBMS from other vendors. Specifically, SolidDB cache now supports DB2, Informix, Oracle, Sybase and in a near future SQL Server
- And finally, an announcement from Exact, about plans to support for Informix in two products: iReplay (capture and replay SQL), and iWatch (SQL monitoring). You can check the press release here: http://www.exact-solutions.com/aboutus/news/386
Friday, October 17, 2008
Informix at VendorRate
If you follow some Informix blogs, groups or sites, you probably already know that Informix earned Top Customer Satisfaction Score on VendorRate survey in Q3. If you're into press releases you can learn more at Business Wire. If you prefer to check the report directly you can find it here.
Informix received the maximum score achieved by any vendor (91) and was rated by more than 120 organizations accordingly to the study. "O"ther RDBMS vendor got 81. The rating covers several aspects (Recommend, Integrity, Communication, Timeliness, Usability, Reliability, Customer Service, Budget, Expertise and Effectiveness). Informix got 9 in all of them except for Reliability (10) and Budget (8).
This rating reflects customer opinions. They are not marketing, although they're probably be used for marketing... I can't say I'm surprised. We all know that Informix customers are loyal, and they're loyal simply because they know they're using a solid product.
Obviously, we tend to compare "our" goods with the competition. And to be honest, we can't say the competition looks bad. As expected, a vendor who has the largest market share is well rated in general... But being a curious fellow I decided to dig a bit deeper... And if you follow me you can also check interesting points:
Then, and just for fun, I decided to dig even deeper... I noticed that VendorRate was at the biggest competitor conference and issued a report based on data collected there.
Looking at this report we can also find very interesting (if not amusing) points:
Informix received the maximum score achieved by any vendor (91) and was rated by more than 120 organizations accordingly to the study. "O"ther RDBMS vendor got 81. The rating covers several aspects (Recommend, Integrity, Communication, Timeliness, Usability, Reliability, Customer Service, Budget, Expertise and Effectiveness). Informix got 9 in all of them except for Reliability (10) and Budget (8).
This rating reflects customer opinions. They are not marketing, although they're probably be used for marketing... I can't say I'm surprised. We all know that Informix customers are loyal, and they're loyal simply because they know they're using a solid product.
Obviously, we tend to compare "our" goods with the competition. And to be honest, we can't say the competition looks bad. As expected, a vendor who has the largest market share is well rated in general... But being a curious fellow I decided to dig a bit deeper... And if you follow me you can also check interesting points:
- In the small companies category Informix is even better positioned. The direct competitor gets a lower rating than in the general rating. It doesn't even show on the table.
This is not surprising considering the ease of administration and low total cost of ownership (TCO) of Informix - Informix continues to achieve top score in the medium size companies. In this category, the second RDBMS place doesn't belong to the biggest competitor
- In the large enterprise category Informix still scores top ratings. The biggest competitor is in a close second place
Then, and just for fun, I decided to dig even deeper... I noticed that VendorRate was at the biggest competitor conference and issued a report based on data collected there.
Looking at this report we can also find very interesting (if not amusing) points:
- Informix was rated exceptional by the attendees (page 5)
- Informix was rated 2 points (93) above the quarterly VendorRate ratings (91) (page 10)
Subscribe to:
Posts (Atom)