IIUG Insider (Issue #231) October 2019

by

Highlights: Informix for the Future – 14.10 and Beyond

Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.

Contents:

1) Editorial

2) Highlights

  2.1 Informix for the Future – 14.10 and Beyond

3) RFE Corner

  Modernize dbexport/dbimport and control them from HQ

4) Informix Corner

  4.1 PHP Informix Driver in RHEL 8

  4.2 Compare the IBM Informix v.14.10 editions

5) Events

  5.1 IBM Informix Roadshows

6) Informix Resources

  6.1 Informix Blogs and Wikis

  6.2 Social Media

  6.3 Forums, Groups, Videos, and Magazines

1) Editorial

Informix is doing well. Version 14.10 xC2 has been out for a while. It is stable and has new cool features.

InformixHQ is great. But there is no news. You may say no news is good news but as a newsletter editor I would like to see more action.

I went to our forum at http://www.iiug.org/community and there were 117 register members.

Come on. We can do better. Joining the forum is more than just helping yourself it is helping others.

A live forum means a live product. So please go ahead and join. If you have questions or answers post.

Gary Ben-Israel

IIUG Insider Editor

IIUG Board of Directors

gary@iiug.org

2) Highlights

2.1 Informix for the Future – 14.10 and Beyond

You can find the following blog by Isaiah Brown and much more at http://www.iiug.org/community

In today’s world, companies need to be able to derive insights from their data no matter where it is – and that’s what Informix is all about. No matter the complication, Informix is built to be your partner on the journey towards maximizing your data. The Informix partnership between HCL and IBM is built to ensure Informix remains great at what it does best, while simultaneously pushing the product into the future and supporting it for the long term. Towards this commitment to development into the future, the first major release of Informix (14.10) was released in March this year – the first such release in five years. With this push into the future, some of the past must be let go, and accordingly, both 11.15 and 11.70 have already gone out of support.

The goal is to maximize this renewed attention to the product and to continue pushing it further. Though the product already has a strong base in retail, manufacturing, telecom, and IoT, the aim is to continually attract more customers from even more industries to utilize the power and potential of Informix. From a strategy perspective, this means a focus on a strong and detailed roadmap for future development based on customer input. This includes a stronger focus on the cloud, making it easier to manage Informix environments, graphing capabilities, and much more.

In 14.10 particularly, an emphasis has been put on the speed of the product. As no one uses a database in isolation of other products and systems, intense focus has been put into increasing the speed within solution stacks. Secondaries have been severely sped up to catch up with primaries, with secondaries displaying speed improvements of 500%. But the speed injection doesn’t end there:

  • Single system processing up 10%
  • Java UDR up 40%
  • JSON and REST APIs up 200%
  • JDBC driver up 60%
  • Login replay performance for RSS, SDS, and HDR secondary servers up 500%

As data protection continues to rise to the forefront of politics around the world, many countries today no longer want their data being moved out of their home countries, forcing some businesses to keep their data where it originates. As a sign of this progress and attention to the future, the next release of Informix is set to include the ability to scale to many nodes – so even when data must stay at its original source, users can run transactions across hundreds of thousands of nodes without data movement.

Further down the line, releases will include learning resources to make the product more user-friendly and updates more accessible. Additionally, means for user feedback will be built directly into the product to allow users to give recommendations based on how they use it. Machine learning capabilities will also be added to make the system easier to manage and quicker to meet business needs.

Gary Ben-Israel

3) RFE Corner

IBM has created a new RFE – Request For Enhancements website.

https://ibm-data-and-ai.ideas.aha.io/?project=INFX

Please visit this site to vote for your favorite enhancements and place new requests.

As you can see, it is a new RFE site. It is friendly and has a nice look and feel.

Recent

Modernize dbexport/dbimport and control them from HQ

dbexport and dbimport are useful tools, very easy to use and straight forward. but as the database are growing exponentially, the tool is showing its limitations and a workaroud must be generally be applied, which are kind of time consuming to write them.

Votes: 6

Created: November 2, 2019

Status: Needs review

Popular

Backup from RSS or HDR Secondaries using ontape, onunload, onbar, dbexport

In HDR environments, being able to backup or export databases from and HDR, HDR read-only, or an RSS secondary server is critical. Programs like ontape, onunload, dbexport, and onbar generate locks on tables during backups and data-exports. This creates problems while applications and users using Informix try to use the system during backups in 24 x 7 x 365 production environments. Being able to backup or export data on secondary systems is critical for compliance and backup integrity.

Votes: 86

Created: December 24, 2018

Status: Future consideration

Obtain the query plan of a running query

Many times a DBA is called to check upon a slow process. Most of the times those processes are running a slow query.

Sometimes it’s hard to know if the query is using the best query plan or not. A DBA can reproduce the query, but it it was prepared without values or if the statistics were changed after it started there is no guarantee that the query plan seen by the DBA is the same as the running query.

We have “onstat -g pqs” which sometimes can give us a clue, but it’s mostly cryptic and undocumented. If a user has X-Windows he can try xtree, but it’s a bit strange for todays standards.

We also have SQLTRACE, but if it was not set when the query was launched it will not capture the info (and besides, due to the circular nature of the buffer it may not be there at the time we need it).

A simple pseudo-table in sysmaster could probably implement this with ease.

It could also be extended to support the “last” query plan making it easy to get the query plan in any tool

Votes: 70

Created: December 24, 2018

Status: Future consideration

SQL interface to obtain the temporary space usage (tables, hash, sorts…)

A DBA and possibly a programmer needs an easy way to monitor who is responsible for the temporary space usage.

Currently it’s possible a user may be consuming a lot of temporary space and impacting other sessions, without the DBA being able to quick and easily identify the session responsible.

Other reports (from IIUG mailing list) and another RFE (36245) mentions the need for programmers to be able to find out the current session’s temp tables (onstat -g ses shows this).

The definitive solution for this should be an SQL interface showing:

– session ID

– object name

– object type (explicit temp table, implicit temp table, hash join, sort …?)

– used space

– chunk/dbspace being used

– owner nam

– ??? (PID and others, but probably thos can be gathered with joins)

This should supersede RFE ID 36245 and this includes the request for that RFE and more.

Votes: 64

Created: December 24, 2018

Status: Future consideration

Backup Individual database, not entire instance

Need a mechanism, similar to ontape, to backup a live database (as opposed to entire instance), without locking it.

Votes: 59

Created: December 24, 2018

Status: Future consideration

Informix should be able to change owner on tables and any other objects

If user=informix creates all database and all tables, then programmer creates table but user=informix cannot change it. Only drop it.

Votes: 58

Created: December 24, 2018

Status: Future consideration

Gary Ben-Israel

4) Informix Corner

4.1 PHP Informix Driver in RHEL 8

http://www.iiug.org/en/2019/10/07/php-informix-driver-in-rhel-8/

4.2 Compare the IBM Informix v.14.10 editions

Learn the differences in features, functions, and pricing models across all IBM Informix v.14.10 editions

http://www.iiug.org/en/2019/10/08/compare-informix/

5) Events

5.1 IBM Informix Roadshows

2019 IBM Informix Roadshow – 14.1 Frankfurt

November 6 – November 7

IBM Office Frankfurt, Wilhelm-Fay-Straße 32, 65936 Frankfurt am Main, Germany
Frankfurt, Germany + Google Map

Find out more »

5.2 WAIUG Meeting

December 2019 Meeting

Tuesday, December 3, 2019

McLean, VA

6) Informix Resources

IIUG website
www.iiug.org

IBM Informix home page
www.informix.com or directly at: http://www-01.ibm.com/software/data/informix/

IBM Informix community
http://www.iiug.org/community

6.1 Informix Blogs and Wikis

Blogs and Wikis that have been updated during the last month

More Blogs and Wikis

6.2 Social Media

Linkedin: https://www.linkedin.com/groups/25049

Twitter : https://twitter.com/iiug

Facebook : https://www.facebook.com/IIUG.Informix

Informix IoT Channel : https://ibm.biz/BdH2nm

6.3 Forums, Groups, Videos, and Magazines

Closing and Credits

The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG’s membership database now exceeds 25,000 entries and enjoys the support and commitment of IBM’s Information Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.

Sources: IIUG Board of Directors

IBM Corp.

Editor: Gary Ben-Israel

For comments, please send an email to gary@iiug.org

Leave a Reply

Your email address will not be published. Required fields are marked *


PageLines