Informix News

invispix 10x10

IBM User Group Day - May 19 & 20, 2020

IIUG International Informix Users GroupHello IIUG Members and Informix Enthusiasts!

You are invited!

Join IBM for User Group Day, a unique virtual experience. IBM is uniting over a dozen IBM User Groups for a 2-day virtual conference with 6 tracks each day featuring user groups, offering management, developers and support staff with expert advice, lessons, demos, keynotes, feedback sessions, and more. Learn more about the technologies you use every day, start a conversation, ask questions, or find new User Groups to connect with.

Technical sessions, more than 15 different areas, ranging from AI, Automation, Cloud Integration, Cloud Pak for Data, Cognos, DataOps, Data Science, Db2, IBM Z, Informix, Maximo, Netcool, Netezza, Open Source, Planning Analytics, Public Cloud, Security, Storage and Websphere and more. This may be the largest IBM Community Virtual event all year! No matter your technology, tool, or proficiency, you will find something here to grow your skill set.


  • There are four very good Informix sessions scheduled for May 19 from 12:30 PM to 4:30 PM Eastern.
  • There are other sessions of interest to all especially Informix world from Open Source.
  • Guardium (one of the best Database security tools).
  • Cognos (we all need reports).
  • An announcement of a new AI product, Public Cloud and many more points of interest.
  • This event also features two keynotes from IBM Senior Vice Presidents Tom Rosamilia (May 19) and Rob Thomas (May 20).

Live sessions will be from 8 AM (08:00) to 4:30 PM (16:30) Eastern Time US and replays of all sessions will be available.

Please share this event and leverage your co-workers, friends and online social channels to help us promote IBM User Group Day.

Get the full IBM User Group Day agenda and register for free visit here!

View link for registration ...

Informix 14.10 Now Supports Common Table Expressions!

Informix 14.10. WebcastsIBM Community Informix Webcast:
Tuesday, May 26, 2020, 19:00 (CEST) / (01:00 PM EDT)


Common Table Expressions (CTE) are a SQL standard feature, CTE simplify queries and make queries more readable. Use recursive CTE to query hierarchical data, and tree/graph structured data. Also, you can do programming tasks with CTE.

Join this session to hear more about and see a demo with Informix 14.10 release support of:

  • Non-recursive CTE
  • Recursive CTE
  • Nested recursive CTEs in one query
  • CTE with Insert, Update, Delete statements


Jinming Xiao
Informix SQL/Optimizer Engineer
HCL Software

Jinming Xiao joined Informix on 1999, has been working on different Informix components like security, networking, and SQL/optimizer.

View link for registration ...

Informix RoadmapInformix Roadmap

IBM Informix Release Roadmap – Update March 2020

Planning for Q2 and the second half of 2020

  • Informix 14.10 for IBM Cloud Pack available
  • 14.10.xC4 Fixpack with improved backup functions for secondary’s
  • LinuxONE Platform Support
  • Last cumulative fix release for Informix 11.70
  • ...

Innovations for 2021 (under investigation)

Continue Reading

IBM Sub-Capacity licensing for Informix and Db2

Processor-based licensing with full- and sub-capacity in virtual environments

processor sub-capacityIf Informix or DB2 are to be used in virtual environments, the question of how to calculate licenses quickly arises with processor-dependent licenses. Is a calculation based on logical resources sufficient or must the physical hardware be fully licensed?

IBM offers two concepts for this: Full-capacity for the licensing of the entire physical resources, sub-capacity for licensing using the resources of a virtual environment.

This article is a brief summary of the various IBM sources for licensing Informix or Db2 in virtual environments. It introduces the common processor-based licensing and the associated definitions for full- and sub-capacity. This article also provides a summary of the general requirements and important information about the verification requirements when using sub-capacity licensing.

  • Introduction Processor Core

  • VPC - Virtual Processor Core licensing

  • PVU - Processor Value Unit licensing
    PVU - licensing with full-capacity
    PVU - licensing with sub-capacity

  • LUS - Limited Use Socket licensing
    LUS - licensing, full- and sub-capacity

  • Sub-capacity licensing, general requirements and important verification requirements

Continue Reading

More Articles ...

invispix 10x10

News categories / back to overview ...

News OverviewNews Overview

News Overview

Informix NewsInformix News

Informix News

IBM Db2 NewsIBM Db2 News

IBM Db2 News

Scout NewsblogScout Newsblog

Scout Newsblog

Our NewsletterOur Newsletter

Our Newsletter

News ArchiveNews Archive

News Archive

invispix 10x10
OEM/ESA licensingOEM/ESA licensing

IBM OEM licensing

Informix for purchaserInformix for purchaser

Informix for purchasers

IBM Db2 for purchasersIBM Db2 for purchasers

IBM Db2 for purchasers

Service und SupportService und Support

Service and Support

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.