Tag Archives: informix

No more a rumour: Informix 12.10 available on the cloud!

  We had heard rumour a few months ago: this is no more a rumour. IBM announced days ago the official launch of Informix 12.10 on the cloud! If you had concerns with using Informix for staging environments, hosting a temporary system for a time-limited project development, or even test a functionality on production-like environment without […]

Leave a comment Continue Reading →

Informix on the Cloud: rumours seemed to be justified!

      Some rumours have been heard within the Informix microcosm related to the implementation of Informix on the Cloud. Those rumours also were kind of justified by a series of new features that made Informix really ready for the Cloud. I really think that, if this  subject has some interest for you, you […]

Leave a comment Continue Reading →

This survey that is making non-informix users very curious about IBM Informix

    < = >   ?   It is amazing how ‘non-informix-converted’ people get surprised when they listen to the voice of real life Informix users. We are used to hearing things like: “Oh! I thought Informix died in 2001”, or even “Informix? say again? oh yes! isn’t this a cousin of the Gaulish […]

Leave a comment Continue Reading →

Where are you at with your Informix 4GL application documentation?

  If you feel concerned in any way by that question, you should read this article. As a big fan of Informix 4GL language, I have been considering this matter for almost 30 years now, and I think I found the best possible answer. Do not miss this reflexion about the Application documentation question and […]

Leave a comment Continue Reading →

About IIUG Conference in San Diego: a few reasons to register

We are almost there, only a few weeks missing: the event will begin on April 25 in the evening, to conclude on April 29th in the evening. This year is going to be somewhat different than other years:  first of all IIUG will blow its 20 candles. 20 years of supporting the worldwide Informix community, […]

Leave a comment Continue Reading →

New Gartner analysis talking about ‘legacy’ databases retirement

Mr Donald Feinberg is a vice president and distinguished analyst in Gartner Intelligence in the Information Infrastructure group,  and responsible for Gartner’s research on database management systems and data warehousing infrastructure. Concerned by a recent analysis stating that so-called legacy DBMS like Sybase and Informix would retire in 2015, he brings in this document a […]

Leave a comment Continue Reading →

Breaking News!!! Informix to become the national DBMS in China!!!

This sound perfectly incredible, but this is the pure truth: IBM Informix has been chosen as the national Database Management System in China. Here is the Press Release from IBM: GBASE and IBM to collaborate on locally innovated database in China IBM (NYSE: IBM) and General Data Technology Co.,Ltd, known as GBASE announces an agreement […]

Leave a comment Continue Reading →

Internet of Things and Informix Warehouse Accelerator

In building a set of messages towards the upcoming IBM Insight (formerly IOD) conference, this blog entry is being written as part of that effort (in collaboration with IBM Marketing):

The Internet of Things is changing our…

Leave a comment Continue Reading →

Informix in IT schools ? In France ? Of course this is possible!

On june 17th, I had fun animating an initiation to IBM Informix session in the facilities of EPITECH, a french IT engineering school which is famous for the quality of its training cursus and the level of its students. Located in Marseille, south of France, but also in 11 french cities, this school had proposed […]

1 Comment Continue Reading →

Version 12.10.xC4 is out! / Saíu a versão 12.10.xC4

This article is written in Englsih and Portuguese (original version here)
Este artigo está escrito em Inglês e Português (versão original aqui)

English version

I’m lagging behind on my objective of a post per week, but as usual… work… But I couldn’t let this opportunity pass by. The latest Informix fixpack is out, and the online documentation was updated and the new PDFs are also available. Everything at once as it should be. Apparently this is becoming an habit, and although this would be expected, it didn’t always happen, so I must say I’m happy it’s happening now.
I’ll repeat myself, but being true, I don’t see why I shouldn’t say it again: Once more we have a fixpack full of features. I honestly think the majority of our customers don’t realize the changes the product have been going through… By changes I mean new features, as the “old” ones are still around. But on every fixpack it seems the possible usages and potential users are getting larger and larger. IBM is extending Informix to completely new areas, and I dare to say no other “traditional” RDBMS has seen such a transformation, or better saying adaptation to new requirements and new realities as Informix. As usual I’ll pick up the official new feature list and I’ll add my comments:

    • Migration
      • Server changes * Enterprise Replication conversion and reversion requirements * JSON compatibility conversion and reversion requirements
        Just a few notes you should consider when doing upgrades/downgrades
      • Easier to import tables with large rows
        A feature that tries to avoid getting too large extents while importing tables with large LVARCHAR columns. With the new option “-D” the extents will be 16KB. If I was asked I’d say I would prefer to let the user to specify the value… Although I understand the issue, 16KB may be too little…
    • Installation
      • Easier installation of 32-bit programs on Windows 64-bit operating systems
        No more need to alter the PATH before installing a 32 bit program in 64 bit Windows
      • Uninstall Informix programs on Windows from the Control Panel
        More convenient
    • Administration
      • Multitenancy in Informix
        Ok… this one deserves a post by itself. You may notice that one of our competitors created a large fuss around something very similar, and that was the big feature of a major release. We introduce it in a discrete fixpack. This fits perfectly in the overall picture of Informix vs other RDBMS. Basically we’re build upon the concept of database inside an instance, something we’ve always supported (as well as in DB2 for that matter). In this fixpack we can now specify a class of CPU VPs and associate it with a “tenant” (CPU resource control), define the number of locks per session on that database, and associate a set of regular and temporary dbspaces for it. No objects from other databases will be allowed on that set of dbspaces, and that database objects can’t be created outside of those dbspaces. Temporary dbspaces can however be used by different tenant sessions.
        If you think about it, this looks a simple extension to the database concept. But if you think a bit further you can easily find more things you’d like to do with these new tenants… Some can be “emulated” (I’m thinking about sessions per tenant). Others no, but I’d bet money on the idea that this will be continuously extended in the future
      • Enhancements to OAT
        As usual, new engine features force new functionalists in OAT. Tenant management, in place alter elimination (provided through a task) and a few more
      • Easier removal of outstanding in-place alter operations
        A new SQL Admin API function to eliminate existing in-place alters. This may help avoid more work during the DML operations on tables with these alters. As mentioned before OAT can be used to configure this
      • Limit the size of extendable storage spaces
        Set up a limit for auto expansion of dbspaces/chunks. Useful in any case, but particularly needed for tenants
      • Limit the number of locks for a session
        Finally this undocumented feature becomes officially. Can be set through $ONCONFIG or SET ENVIRONMENT….
      • New default mode for the VP_MEMORY_CACHE_KB configuration parameter
        This parameter specifies the amount of memory cache each CPU VP can use. It was recently extended to have a second option (STATIC, DYNAMIC) do define if it would automatically grow. Now the default changed from DYNAMIC to STATIC
    • Replication
      • Enhancements to the Enterprise Replication apply process and memory pool allocation
        A new CDR_MEM parameter controls the way memory for enterprise replication is allocated. Two new methods are provided for a trade off between memory consumption and performance
      • Replicate hertz and compressed time series data
        ER now allows the replication of both hert (sub-second frequency) and compressed Time Series data. This means these can be used in ER and GRID environments
      • New event alarm for blocked replication transactions
        A new event alarm can now be triggered if transactions are being blocked because a table is in ALTER mode
    • Performance
      • Faster storage optimization
        The compress, uncompress, and repack operations can now be done in parallel by using that option in the commands. It’s allowed both for tables and indexes
      • Faster queries with UNION ALL views
        An optimiz…
    Leave a comment Continue Reading →