Informix Users heads up! In March 2019 Informix 14.10 has been released! Informix 14.10 is the first major release since 2013. It will succeed Informix 12.10 which has been onto the market for 6 years. That is why you can expect a lot of new and enhanced features in the fields of Performance, Security, Administration, Monitoring and IoT.

Furthermore there are some changes in licensing – to the benefit of the Informix user. Features, which have been liable for costs recently, are now included in some versions. Additionally hardware and memory limits for specific versions have been elevated.

Below you find the most essential news at a glance:

  • Up to 10% faster for standard OLTP transactions from previous IFX versions
  • Up to 5x improvements in replication log replay enables near
  • zero latency allowing faster recovery time objective in desaster
  • Automated setup Enterprise Replication between two servers
  • Increased security for encryption keys and Transport Layer Security
  • New graphical tool that elevates administration and monitoring (IFXHQ)
  • Enhanced NoSQL-Support (Mongo & REST listener)
  • Enhanced options - Workgroup edition offers higher hardware limits
  • storage optimization is now available in Enterprise Edition at no extra Charge

 

Details:

https://www.ibm.com/support/knowledgecenter/en/SSGU8G_14.1.0/com.ibm.po.doc/new_features_ce.htm#concept_v1410xc1__cdrmigrate

 

Informix plays a key role for companies active in all branches – worldwide. You will find the IDS in retail, in banks, in the public sector, in logistics but also in the energy, telecommunication, aerospace and industrial 4.0 environment. Informix 14.10 will make it’s contribution to this development.

And what does Informix 14.10 means for you? Rethink you Informix environment – not only technical but also taking into consideration the TCO. Check your requirements regarding memory and hardware limits, benefit from the new included features and softened limits, does it make sense to replace your Informix Enterprise Edition by using the enriched Workgroup Edition? Do you still need the Informix Enterprise Advanced Edition or does the regular Enterprise Edition, including the data compression feature from now on, fits? Do NoSQL and TimeSeries become more important for you in the future?

Contact us. Together with you we will check what your best option. If required we will support you in the implementation of Informix 14.10, too.

Contact: +49 40 875 00 589, This email address is being protected from spambots. You need JavaScript enabled to view it.

Informix Users heads up! In March 2019 Informix 14.10 will be released! Informix 14.10 is the first major release since 2013. It will succeed Informix 12.10 which has been onto the market for 6 years. You can expect new features in the fields of Performance, Security, Administration and Monitoring. An essential enhancement will be InformixHQ. InformixHQ is the logic progression of the IBM OpenAdmin Tool (OAT). InformixHQ is a modern web console for visualizing, monitoring, and managing your Informix server instances. Informix HQ provides critical performance management capabilities, monitors key performance metrics and tracks how efficiently Informix is running your workload. With InformixHQ you can manage and monitor as many Informix database server instances as you need. It is manageable and accessible from any desktop, laptop, or mobile device. InformixHQ is the path forward for an easy to install, use and comprehensible graphical monitoring, alerting, and administration of your Informix database servers.

We keep you informed! 

Contact: +40 875 00 589, This email address is being protected from spambots. You need JavaScript enabled to view it.

 

 

 

New: Informix Release 12.10xC12

In July 2018 IBM has released the new Informix Fixpack 12.10xC12.

The new release does not contain new features. It is a bug fix exclusively. IBM provides periodic fixes for Informix release 12.10. The following list is the most recent report of fixes for customer-reported defects in versions 12.10.xC12:

https://www-01.ibm.com/support/docview.wss?uid=ibm10717445

 

Don’t forget: in April 2018 Informix 11.50 was discontinued! From this point on there is no product support of IBM even if you have a contract. If assistance is required it is liable for costs!

We suggest updating your Informix database server as soon as possible to Informix 11.70xC9 or, more suitable, straight to Informix 12.10xC11.

You need consultancy regarding the most suitable Informix edition? You prefer support while migrating from an old Informix version to the new 12.10xC12?

 

Contact: +40 875 00 589, This email address is being protected from spambots. You need JavaScript enabled to view it.

 

 

In May 2018 IBM has released the new Informix Fixpack 12.10xC11. Besides the usual bug fixes, Informix 12.10xC11 includes new features in the fields of administration and security. What can you expect? A selection as follows:

  • Online schema changes - Loopback replication - xC11 provides support for zero downtime table reorganization, as well as simpler code set conversions.
  • Large table reorganization - Enhancements include fragmentation strategy changes and the ability to perform slow alters.
  • Dropping offline empty chunks - Database administrators can now drop offline empty chunks without having to call IBM Support.
  • TEMP DBspaces - TEMP DBspaces are now as resilient during restart as TEMP SBspaces.
  • UTF8 to UTF8 GLU Migration - When using a UTF8 database, newer emoji characters are no longer rejected even if they are not in the unicode BMP.

IBM provides periodic fixes for Informix release 12.10. The following list is the most recent report of fixes for customer-reported defects in versions 12.10.xC11:

http://www-01.ibm.com/support/docview.wss?uid=swg27051181&myns=swgimgmt&mynp=OCSSGU8G&mync=R&cm_sp=swgimgmt-_-OCSSGU8G-_-R

Don’t forget: in April 2018 Informix 11.50 was discontinued! From this point on there is no product support of IBM even if you have a contract. If assistance is required it is liable for costs! We suggest updating your Informix database server as soon as possible to Informix 11.70xC9 or, more suitable, straight to Informix 12.10xC11.

 

 

What is InformixHQ?

InformixHQ is a modern web console for visualizing, monitoring, and managing your Informix server instances. It is easy to use, scalable and optimized for DevOps needs. Informix HQ provides critical performance management capabilities, monitors key performance metrics and tracks how efficiently Informix is running your workload. It's monitoring system feeds directly into a customizable alerting system so you can be immediately alerted via email, Twilio, or PagerDuty whenever an issue occurs on one of your Informix database server instances. With InformixHQ  you can manage and monitor as many Informix database server instances as you need. Moreover, it's a tool that can be shared by the DBAs, the app developers, the ops engineers. It is managable and accessible from any desktop, laptop, or mobile device. InformixHQ is the path forward for an easy to install, use and comprehensible graphical monitoring, alerting, and administration of your Informix database servers.

Watch demo videos on YouTube at https://www.youtube.com/watch?v=PcEIrnOcuG0

Download the product binaries from Maven Central at https://mvnrepository.com/artifact/com.informix

InformixHQ is the logic progression and complement of the IBM OpenAdmin Tool (OAT).The OpenAdmin Tool for Informix is a web application for administering and analyzing the performance of IBM Informix database servers. You can administer multiple database server instances from a single OAT installation on a web server. You can access the web server through any browser to administer all your database servers.

In November 2017 IBM has released the new Informix Fixpack 12.10xC10. 

Besides the usual bug fixes, Informix 12.10xC10 includes new features in the fields of administration, performance and time series. Personally we would like to point out the enhancements in performance – specially in the data compression.

What can you expect? A selection as follows:

  • Partition blobs in a compressed table will now be compressed during insert and those inserts will be replicated by ER
  • BLOBspace blobs are now compressed, and will replicate with ER
  • When auto-compress is triggered, the result will be that all rows in the table are compressed
  • Ability to compress TimeSeries data in a row that contains strings, improving compression ratio for those rows


Details:

http://www.informixcommunity.com/blogs/whats-new-in-informix-1210xc10

  
Fix list for Informix Fix Pack 12.10xC10:

http://www-01.ibm.com/support/docview.wss?uid=swg27049837

  
Don’t forget: in April 2018 Informix 11.50 will be discontinued! From this point on there is no product support of IBM even if you have a contract. If assistance is required it is liable for costs! 

We suggest to update your Informix database server on time to Informix 11.70xC9 or, more suitable, straight to Informix 12.10xC10.

In September IBM has released the new Informix Release 12.10xC9W1. The new release is a so called Post Interim Drop. PIDs are thoroughly tested, cumulative releases based off of the latest quality assured Fix Pack version. PID releases are versioned with a trailing ‘W’. Each subsequent PID builds on the one before until the codeline ultimately becomes the next commercial Fix Pack release. Therefore, if a defect fix is included in W1, it will be in all subsequent PID releases as well as the next Fix Pack unless the fix itself introduces problems. Please have a look at the fix list forInformix 12.10xC9W1:

http://www-01.ibm.com/support/docview.wss?uid=swg27049836

In July 2017 IBM has released the new Informix Fixpack 12.10xC9. 

Besides the usual bug fixes, Informix 12.10xC9 includes the new “Push Data Feature”. It is a Smart Trigger which enables the Informix database server to inform automatically and directly the application about changes in the database. The precondition is that trigger criteria have been defined in advance. This is done by simple SELECT statements and WHERE clauses. If changes in the database match with the defined criteria Informix “pushes” this information directly from the database server to the client. 

For those who would like to know more:

http://www.informixcommunity.com/blogs/introducing-informix-smart-triggers

Fix list for Informix Fix Pack 12.10xC9:

http://www-01.ibm.com/support/docview.wss?uid=swg27049826

The new Informix release 11.70xC9 has been released in April 2017. The focus of the latest Informix release is on bug fixing only. 
You are interested to get details from the Fix list of Informix 11.70 xC9? Please click here:

http://www-01.ibm.com/support/docview.wss?uid=swg27049414

The Fix list shows you the corresponding Authorized Program Analysis Reports (APARs) sorted by numbers.

Starting May 1, 2017 IBM and HCL agreed a cooperation regarding Informix. The goal  is to strengthen and accelerate the technical development of the Informix Database Server and to improve the market presence. The signal for customers and partners is clear: Informix is a reliable and stable investment for the future.

First, we all need to understand IBM has not sold Informix. This is an Intellectual Property and Licensing agreement between IBM and HCL. HCL is a major worldwide company with offices in 30 countries and 110,000 employees. Hence, it is not a sale or an acquisition. This agreement stands for 15 years and it is automatically renewed after that period.

HCL has a lot of experience in the industrial environment offering products and solutions where Informix fits perfectly with its key benefits in the field of TimeSeries, integration into applications and with the small footprint enabling lots of use cases in the Internet of things and Industry 4.0 issues.

IBM is responsible for the strategy of Informix, HCL will realize it. IBM is responsible for the offering management and the marketing - development and support staff is reinforced and partly move to HCL.

Nothing changes for IBM customers and partners – eg contact points for product support, corresponding procedures, resources and existing standards will continue – the same to existing license agreements.

This partnership is a business commitment for continued growth of Informix to make it more competitive in the market! Fifteen years is a lifetime in the tech world, making this is a major positive

In December 2016 IBM has released the new Informix Fixpack 12.10xC8. 

Besides the usual bug fixes Informix 12.10xC8 includes a lot of enhancements in the fields of Security, Application development und JSON compatibility. Additionally there are also some new features in Informix Time Series. Altogether it is a remarkable release which, besides all improvements in the NoSQL areas includes a variety of important improvements for the average user. 

Security: after configuring a new parameter DISK ENCRYPTION new dpspaces will be encrypted by default. This is completely transparent for the application. Existing dbspaces can be encrypted by usage of backup/restore. Space usage will not increase

Time Series: new functions enable analyzing time series data for pattern or abnormalities

JSON: several improvements in MongoDB API clients (eg. a new listener parameter)

JDBC: improved compatibility of the IFX native driver

Enterprise Replication: improvements setting up test environments or moving into production using “cdr list catalog”

 
Further information about new features you will find here:

http://www.planetids.com/content/informix-1210xc8-out-informix-1210xc8-sa%C3%ADu

In July 2016 IBM has released Informix 12.10xC7. Just a couple of weeks after the regular fix pack 12.10.xC7 IBM launches 12.10.xC7W1. Due to this some customers assumed that the fix pack is buggy. But this is definitely not the case! Instead the PID refers to COGNOS - offering specific requirements which had to be implemented into Informix which is the embedded database. Probably IBM will provide customers with more PIDs in the future.

Important: if you have already installed Informix 12.10xC7 it is not necessary to install the PID afterwards. The fixes will be reconsidered in the next fix pack 12.10xC8.

The new fix pack can be called an I(nternet)o(f)T(hings)-Release. It comprises mainly enhancements in the field of JSON/BSONSpatial Data and TimeSeries. Informix can now receive data via MQTT protocol and put in into the database directly. This is Important to allow sensors and other endpoint devices to send data to repositories or message brokers. 

Finally there is something new from the Informix Warehouse Accelerator (IWA). From now on you can install the IWA also on IBM POWER8. So far installation was possible only on Intel processors (x86).

Details:   

http://www.planetids.com/content/informix-1210xc7
http://www-01.ibm.com/support/docview.wss?rs=630&uid=swg27021332

IBM has discontinued the Informix Database Server Release 11.50 to 30.04.2018! This includes all Informix Editions (Express, Growth, Enterprise). The “end of support” announcement (eos) means that Informix 11.50 is officially not supported any more beyond the eos date – even if a valid Informix maintenance contract is existing.

If you are still using Informix 11.50 we recommend updating your database server to the actual available and supported release 12.10 as soon as possible. You will safe costs and benefit from the advantages in the fields of performance and security the newer release offers to you.

You are interested to migrate from Informix 11.50 to Informix 12.10 – and you will do it soon and not at the last moment? May be you are already planning changes and enhancements in your Informix environment? We guide you informing about the most attractive ways to license, purchase and configure the new Informix software which is most suitable for you by avoiding compliance and liability risks.

Manufacturing, IT and Internet melts increasingly. Factories become “smarter”. This means people, machines and products exchange information in real time in order to optimize production flows, quality and costs. Automatically software analyzes data in real time, identifies specific error patterns and locates problems. This kind of interaction between different fields of activity is known under “Industry 4.0“. Which role plays Informix in this context? Informix offers the base for the activity analysis by delivering Informix TimeSeries!

Example: You are a producer. You have to avoid downtime of your machines because of financial losses. Consequently you have to collect the machine data steadily and maintain your infrastructure predictive. To realize this goal you have to gather your data in real time, completely and reliable. Informix is perfect for this. Why? Informix offers a unique selling point – compared with other competitors Informix offers a specific data type managing time series data – the feature Informix TimeSeries!

 Benefits:

  • Extreme fast data access
  • Optimized storage of data specially for TimeSeries because of a specific data type - in contrast to eg oracle you avoid time intensive indices for data access
  • Significantly reduced need of space (-60 % compared with SQL access)
  • Informix supports TimeSeries operations which can't hardly programmed with SQL
  • Interfaces for developers
  • Informix TimeSeries is included in every actually offered informix Database Edition - no extra costs

If you offer measurement and control technology, or collect and analyze production-, machine-, and energy data or check materials and qualities then Informix TimeSeries is a "Must" for your company!

Further information:

Tel.: +49 40 87500589 or via contact form

Informix offers the benefit of the so called „small footprint“. You can install and run Informix on very small servers or use it with mobile devices. Only the server architectures limit the scalability. Informix 12.10 eliminates this scalability limit using “Sharding”.

Sharding spreads OLTP queries across several servers in order to improve performance and scalability. The most essential features are already available with Informix 12.10. Additional features will be added steadily. User capabilities will be enhanced. But what is “Sharding” and which are the benefits of using it?

  • Sharding is a type of data partitioning
  • data is divided into parts (Shards)
  • and spread across multiple computers
  • in combination with Informix Enterprise Replication every Shard is replicated on every replication server. Every server owns a copy of Shards
  • this results in a flexible, fault tolerant and fast system
  • which can run on cost effective hardware

Further benefits:

  • Sharding runs with SQL, TimeSeries and NoSQL
  • Sharding runs with different hardware and operating systems
  • Sharding runs with different Informix release versions

As of Informix 12.10xC6 „sharded queries“ are executed parallel. This means minimized response time, less memory and reduced network traffic.

If your system environment is characterized by:

  • high performance requirements
  • lots of data
  • wide spread (server)locations
  • heterogenous environments

Informix "Parallel Sharding" is a must for your business!

Not a moment too soon before christmas the new Informix Release 12.10xC6 has been released. Besides the elimination of bugs included in the previous Informix release the new version offers a variety of enhancements – there is something for everyone! In the following we concentrate on improvements in the fields of Administration, High Availability and Performance. If you are more interested in TimeSeries, Warehousing or SQL you will be well served, too. In the following a selection of the latest features of Informix 12.10 xC6:

  • Faster communication between HA Servers because of reduced latency
  • Accelerated index transfer to the Secondary (HDR/RSS) using light scans wherever possible
  • Easier cloning of databases using a new parameter
  • Priorization of automatic Update Statistics
  • Optimization of restore processes by defining prallel processes while running a backup

Important information for users who want to be up to date using the latest operating system versions: Informix 12.10xC6 is supported for UBUNTU 14.04. LTS, RHEL 7.1 and SuSE SLES 12.

Here you find an overview about all new features of Informix 12.10xC6:

http://www-01.ibm.com/.../.../...23newxc6__xc6_smx?lang=en

A few days ago (23.03.2015) IBM has released the new Informix v12.10 xC5 version which was normally foreseen for the 4th quarter 2014.

The focus of the new release is on Time Series and JSON Compatibility. Furthermore there are some new features and/or enhancements in the fields of migration, administration and warehouse issues. Finally bugs of the former version 12.10 xC4 have been fixed.

In the following a selection of the most important new or enhanced features:

  • Rolling Upgrades for High-AvailabilityClusters
  • Limit Session ressources
  • Larger maximum tape sizes for Backups
  • Warehouse Accelerator enhancements
  • Time Series & JSON Compatibility

We recommend updating to the actual Informix release.

The complete list of new features you find here: 

https://www.ibm.com/developerworks/community/blogs/

idsdoc/entry/informix_12_10_xc5_fixpack?lang=en 

Informix data replication enables a reliable and powerful data synchronization taking into consideration meanwhile updated data. In most use cases High Availability Data Replication (HDR), Continuous Log Restore (CLR) and Enterprise Replication (CDR/ER) meet the requirements regarding speed and reliability perfectly. But there are some scenarios where HDR, CLR und CDR/ER are not or less suitable for moving data from one server to another. 

IBM InfoSphere Data Replication (IBM InfoSphere Change Data Capture), in short named CDC, is a log based replication which unburdens the source database server. CDC is capable to exchange data in heterogeneous environments between different databases or to replace Informix replication (HDR, CLR, CDR/ER) used for high data volume if availability and performance is a problem. Your applications have not to be changed. 

IBM Infosphere Data Replication offers a broad range of replication optionsPerformance-Monitoring for source and target server is possible. Potential bottlenecks are shown as alerts.

IBM Infosphere Data Replication is installed and licensed on processor basis on the source and targetdatabase server. 

You are interested to know more about IBM InfoSphere Data Replication?

Contact us! We support you in:

Contact: Oliver Hesse, via contact form, Tel.: +49 40 875 00 589

In June 2014 IBM has released the new Informix v12.10 xC4 version. This release offers a broad range of new or/and enhanced features in the fields of Installation, Administration, High Availability Clusters/Replication and Performance. In the following a selection of the most important new or enhanced features:

  • OAT enhancements
  • Enterprise Replication enhancements
  • New event alarms for blocked replication txn
  • Faster storage optimization
  • Faster Queries with UNION ALL views

We recommend updating to the actual Informix release.

The Fix list for Informix 12.10xC4 you find here:

http://www-01.ibm.com/support/docview.wss?uid=swg27041877

In March 2014 IBM has released the new Informix v12.10 xC3 version. This release offers a broad range of new or/and enhanced features in the fields of Installation, Administration, High Availability Clusters/Replication und Informix Data Warehouse. In the meantime the Fixpack 12.10xC3W1 was released. This Post Interim Drop includes bug fixes of the previously released major Informix Release. In the following a selection of the most important new or enhanced features:

  • Automatic resource tuning for performance
  • Automatic location and fragmentation
  • Easier configuration and cloning of a server for replication
  • Improvements to Connection Manager
  • Shard data across Enterprise Replication Servers
  • Accelerate warehouse queries in-memory

We recommend updating to the actual Informix release.

The Fix list for Informix 12.10xC3 / Informix 12.10 xC3W1 you find here:

http://www-01.ibm.com/support/docview.wss?uid=swg27041211

Informix v12.10 offers a new feature in the Data Warehouse environment. new Stored Procedures support you administering the Informix Warehouse Accelerator (IWA) and the setup and handling of Data Marts.

This makes administration of the Informix Database even faster and easier than before. The latest Informix release v12.10 xC2 additionally offers new SQL routines for the integration of Time Series Data.

Further details: IBM Informix Warehouse, Accelerator Administration Guide, SQL administration routines

For all those who are not working with the latest Informix 12.10 version there is an important news: the new Informix release 11.70xC8 is available for all actual Informix Edtions and platforms and has been released in January 2014. The focus of the latest Informix release is on bug fixing only. 

You are interested to get details from the Fix list of Informix 11.70 xC8? Please click here:

http://www-01.ibm.com/support/docview.wss?uid=swg27040228

The Fix list shows you the corresponding Authorized Program Analysis Reports (APARs) sorted by numbers.

In September 2013 IBM has released the new Informix v12.10 xC2 version. This release offers a broad range of new or/and enhanced features in the fields of Installation, Administration, Backup/Restore, Performance, Replication and Informix Data Warehouse. In the following you find some of the features:

  • New event alarms for network failures
  • Dynamic private caches for CPU virtual processors
  • Enhanced support for IBM Tivoli features
  • Simplified changes for replicated tables
  • Control the replication of large objects
  • Load data from external tables into data marts

IFX 12.10 xC1 version have been fixed. Therefore we recommend updating to the actual Informix release 12.10 xC2.

The Fix list you find here:

 http://www-01.ibm.com/support/docview.wss?uid=swg27038362

Your company

  • has a lot of database transactions (txn) still growing?
  • suffers from a poor database performance because of heavy I/O load?
  • uses Informix Performance Features (eg. Compression, Parallel Data Query, Fragmentation)?
  • runs a cost intensive, highly upgraded hardware with lots of cpu and hard disk drives?
  • suffers, despite of all improvements, from poor response times?

If so think about the usage of Solid State Drives (SSDs). They will accelerate your Informix database performance.

It is for sure: a single SSD is faster than a disk drive under any circumstances! In average by factor 10–100. But how fast it is, depends from a variety of parameters.

  • How many txn are handled?
  • What is the size of the txn?
  • Which type of data are handled?
  • What about the way of the data access?
  • and in which intervals?

Many well known soft- and hardware producers recommend to use SSDs for shifting existing performance levels – but despite of this: most important for the success of the SSD usage is your individual Informix requirement and the needs of your clients!

It is not a question if SSDs can speed up your Informix database performance (of course they will do) – you have to decide if it is worth to invest your money by factor x into SSDs in order to gain performance improvements by factor y. Costs and value have to be in due proportion.  

What’s the difference between SSDs and Disk drives? Which benefits a SSD offers? What about it’s lifetime? Are there different qualities of SSDs? Which data should be put on a SSD? Are there specific configuration requirements? What about the price? All these questions have to be answered before.

hamburg data helps you. We:

  • analyse your database environment
  • define your suitable operation areas for SSDs
  • inform you about technology & different qualities of SSds
  • provide you with SSDs & flash storage arrays
  • implement, configure and adjust your
    • storage arrays
    • Informix database 

Success stories and tests prduce the evidence: 

Informix runs great on SSDs!

Further information: 

Tel: +49 40 875 00 589 or via contact form

On 26 March 2013 IBM has announced the new major release Informix v 12.10. It is now available for purchase and usage and offers a plenty of new and practical oriented features in the following fields:

  • Application Development
  • Administration/Open Admin Tool
  • Enterprise Replication
  • High Availability
  • Informix Warehouse Accelerator
  • Time Series

One highlight of Informix 12.10 are the long awaited enhancements in compression. From now on Informix offers “Index Compression” and “BLOB Compression”. This leads to significant reduction of I/O and disk space. You can consolidate free space in indexes (repack) and return free space to the dbspace (shrink). Furthermore you can benefit from an automated table compression.

These features are liable for costs (as it was before) and are offered in the “new” Informix Enterprise Edition (which was named Ultimate Edition before). The new Informix database top version “Informix Advanced Enterprise” comprises the compression features without extra costs. 

Besides this good news there is also one drop of bitterness: IBM has increased prices by 5 % in average.

In addition to technical enhancements there are changes in the Informix packaging. Editions, licensing and hardware/software limits have been modified partly. Eg. the Choice Edition was withdrawn, Informix Express Version has been enriched, database server editions have been renamed (Workgroup/Enterprise) and limits are hardcoded. 


In general: licensing issues and analysis will become more important but if you pay attention to this matter you will save a lot of money.

Contact us in case of technical or license terms regarding Informix 12.10.

We will support you

  • in license analysis & cost reduction
  • in the introduction of Informix 12.10
  • in consultancy
  • Informix support
  • Informix training

Please contact: Tel: +49 40 875 00 589 or via contact form

If you plan to run Informix Warehouse Accelerator (IWA) on a virtual machine it is mandatory to allocate CPUs and RAM exclusively to the specified VM. This can be done configuring the Virtual Machine Manager (VMM). To swap the memory of IWA (to get more space for another VM) has to be avoided in any case. To reload the data means additional I/O and an decreasing performance of the database.

The new Informix release 11.70xC7 has been released in December 2012. The focus of the latest Informix release is on bug fixing only. For this reason the new fix pack has been realized a little bit earlier than already scheduled.

You are interested to get details from the Fix list of Informix 11.70 xC7? Please click here:

http://www-01.ibm.com/support/docview.wss?uid=swg27036092

The new Informix release 11.70xC6 has been released on 23 Oct. Right on time before the new Informix Mayor Release will take over next year. The focus of the latest Informix release is on bug fixing – nevertheless there are some remarkable enhancements/features Informix users should know for their practical work. A brief overview you will find here:

  • Enhancements to the OpenAdmin Tool (OAT) for Informix

  • Easier failover configuration for Connection Managers in a high-availability cluster

  • Coordinating transactions within a high-availability cluster

  • SPL routines for application compatibility

  • Load time series data faster through a virtual table

  • Performance improvement for the virtual table interface for TimeSeries containers

You are interested to get details from the Fix list of Informix 11.70 xC6? Please click here:

http://www-01.ibm.com/support/docview.wss?uid=swg27036092

Product support for INFORMIX Server Edition 11.10 running on all available platforms officially ends 30.09.2012. This refers to Enterprise, Workgroup and Express Editions of Version 11.10 and means that support even if covered by maintenance contracts as yet is not available any more. In order to avoid extra costs in support cases we suggest migrating to Informix11.70 xC5. Informix Edition 11.10 was already released in 2007. Since this time lots of new features have been developed – for this reason a migration to Informix 11.70 is a safe investment.

Starting on 01.01.2013 IBM lifts up the prices for IBM/Informix software by 3 % in Germany. This refers to license purchase from new, reinstatements and maintenance. If you plan to invest money into Informix software in the near future, we suggest buying Informix licenses still in 2012 in order to benefit from lower price levels.  

If you need consultancy migrating from Informix 11.10 to Informix 11.70 or an attractive offer for an Informix software purchase, please feel free to contact us!

The new Informix release 11.70xC5 has been released on 21st May. The focus is on bug fixing – nevertheless there are some very practical enhancements/features Informix users should know for their practical work. Improvements in administration, security und performance have been realized – also effecting Informix Time Series and Informix Data Warehouse functionalities. A brief overview you will find here:

Plan responses to medium-severity and low-severity event alarms - You can plan responses to severity 3, 2, and 1 event alarms for alarms with documented explanations and user actions.

Increased SQL statement length - The maximum length of SQL statements and SPL routines is 4 GB. The only exception is the length of the CREATE VIEW statement, which is restricted to 2 MB in length. The extended length is valid when using Client SDK 3.70.xC5 and JDBC 3.70.xC5. Previously, SQL statements were restricted to 64 KB in length.

Partition Refresh in DWH/IWA – The new Partition Refresh Feature enables the user to renew single partitions (fragments) in the data mart. In case of changes within the Informix database only the modified or added data have instead of the complete data volume have to be loaded into the data mart. Because of the specific selection of the renewed the loading time is reduced significantly.

Here you find an overview about the fixed bugs:

http://www-304.ibm.com/.../docview....mync=R

A high quality data management as a base of leading to competitive advantages are top priorities for companies. Due to this challenges in the business world take the chance to know how you can accelerate your data warehouse queries by multiple factors using the most important feature of the new released Informix Warehouse Edition: the Informix Warehouse Accelerator (IWA).

In this course you are instructed in the fields of conception, structure, installation, configuration and usage of the Informix Warehouse Accelerator (IWA). You will learn to create, define and administrate data marts by using the Smart Mart Analytics optimizer Studio and benefiting from the performance optimization techniques of the IWA

Place: Hamburg or your company

Duration: 1 day

Time: flexible

Costs: starting from 650,00 EUR

 

Further information:Trainings/Workshops

Please contact us: tel.: +49 40 875 00 589 or via contact form

To refresh the data in a data mart of the Informix Warehouse Accelerator, the data mart must be loaded with a new set of the complete data. This can be done by dropping the existing data mart, re-creating it and then loading it with the new data. This means that the data mart is not available during the load process of the new data. For this, a second data mart with the same definition, but a different name, needs to be created and loaded. While this new data mart is being loaded, the old data mart is still available for query acceleration.

So far so good - but with Informix version 11.70.FC4 you benefit from the following:

As soon as loading of the new data mart is complete, the new data mart will become automatically active! From that moment onwards it will be utilized for the acceleration of newly arriving queries. This switch over to the new data mart happens automatically in the optimizer of the Informix Server, where it is decided, whether a query can be accelerated. As soon as the last query utilizing the old data mart has completed, the old data mart can be dropped manually.

This method will lead to easier database administration, save time and enables the ever fastest possible provisioning of actual date for company based data management processes.

It should be noted however, that this method of data refresh requires the double of the memory space needed normally for the data mart, though only for a short time. Therefore the size of the shared memory available for the worker nodes may need to be adjusted accordingly.

 

Informix Ultimate Edition (UWE)/Growth Edition (GWE) were the starting point of a new era of Data Warehousing. Due to the IWA tool broad data analysis can be executed within seconds – calculable, reliable and full automatically. UWE & IWA are definitely a must for companies which need to analyze huge amounts of data in a time and cost efficient way. But lately there is an even better way to optimize your data:

From Informix Ultimate Warehouse Edition 11.70 FC3 (Linux x86 64-bit, AIX 64-bit, Solaris Sparc 64-bit und HP IA 64-bit) on, you can use the new implemented “SmartMart” Feature for speeding up analyzing processes.

Using a script it is possible to analyze user defined sql statements and to generate a definition of a data mart in order to accelerate the requests.

If you are using a well configured Informix database, benefiting from the performance and memory optimizing data compression you are well positioned.

If you are interested to get more information about Informix Warehouse Accelerator, “SmartMart” Feature, Data Compression and how to configure Informix databases in an optimal way, please contact us.

Already in spring 2011 IBM had offered the Ultimate Warehouse Edition representing the new „top of the line“ product of the IBM Informix Server portfolio. Since November 2011 also small and medium sized companies have the opportunity to benefit from warehouse data evaluation within seconds by using the Informix Growth Warehouse Edition.

The already known limits of the Growth Edition (GE) regarding sizing and hardware environment are still valid. The following limits have to be taken into consideration using the Informix Growth Warehouse Edition:

  • Max. 16 Cores and max. 48 GB Shared Memory
  • Platform: only 64bit for AIX, Solaris, HPUX and Linux
  • no data compression available

Because of the missing data compression IBM Informix Growth Warehouse Edition can be used for a database size up to 250 GB. If you manage more data you should use the IBM Informix Ultimate Warehouse-Edition for benefiting from good performance.

IBM IFX Growth Warehouse Edition is available on PVU-basis only from 142,00 EUR/PVU on. This is approximately one third of the costs of IBM IFX Ultimate Warehouse Edition.

Since November the new Informix-Release 11.70xC4 is available. Besides fixing the bugs of the previous release there are a lot of enhancements and new features in the field of administration, high availability, security and time series data. Some remarkable improvements you will find below:

  • OpenAdminTool (OAT) is now delivered and installable with CSDK for WIN, LIN and MAC operating systems
  • Informix Health Advisor examine a great number of metrics and configuration details, warning you of anything not within the recommended settings and/or defined thresholds
  • Easier startup and handling of Connection Manager
  • Better overview about the progress of compression operations
  • Easier setup of faster consistency checking using Enterprise Replication (ER)

Do you want to know more details? Please contact us

  • hamburg data GbR
  • Jörg Kleinitzke & Oliver Hesse
  • Oehleckerring 43
  • 22459 Hamburg

loation and how to find us  How to find us

  • Tel.:+49 (0)40 875 00 589
  • Fax.:+49 (0)40 875 01 968
  • eMail: This email address is being protected from spambots. You need JavaScript enabled to view it.
  • Contact form
  • VAT.-Id.-No.: DE277820876
  • Taxl office: Hamburg Nord