Highlights: IBM CEO Ginni Rometty is stepping down, Arvind Krishna to take over
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:
2.1 IBM CEO Ginni Rometty is stepping down, Arvind Krishna to take over
4.1 IIUG Announces First in Series of Worldwide Informix Tech Day Events to take place in India
4.2 February 2020 Webcast – Easy Replication from On Prem to Cloud
4.3 Coming in 2020 – Free Informix Tutorials Webcast Series!
5.1 IBM Think 2020 – San Francisco
6.3 Forums, Groups, Videos, and Magazines
Table of Contents
Editorial
My dear friends at the IIUG.
This editorial is personal.
After 27 years as CIO at the National Institute for Testing and Evaluation I am retired.
Informix will still be a major part of my professional life.
I will continue working as an independent consultant doing Informix database administration and database architecture.
I will continue contributing to Informix and the Informix user community as a board member the Insider editor and an active IIUG member. Having more free time I will do much more helping you guys and Informix. So feel free to contact me and I’ll do my best to help as I always did.
Looking forward to this new phase in my life.
Cheers.
Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
gary@iiug.org
Highlights
IBM CEO Ginni Rometty is stepping down, Arvind Krishna to take over
https://www.cnbc.com/2020/01/30/ibm-ceo-ginni-rometty-steps-down-arvind-krishna-to-take-over.html
When the IIUG board first met Arvind he was a VP in charge of databases under Ambuj Goyal who was the director of data management.
For many years, Arvind always supported Informix and the IIUG. In his new role, Arivind will not be dealing with specific products, but it is good to know that the CEO of IBM is someone who knows and appreciates Informix and has been a friend and supporter of the IIUG board for many years.
We all wish him luck and success in his new position.
Gary Ben-Israel
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
Informix HQ monitoring of raw disks
At the moment the Informix HQ product tries to monitor the storage using a “df -k” command
This will not work though when Informix is running on raw disks.
Votes: 1
Created January, 23 2020
Status: Needs review
Add at the ‘DEFRAGMENT’ SQL Api , the option to defragment an entire dbspace.
We have set in our environment tables and partitions with historical data, so, they are tables or partitions who have any changes (include/excluded data).
Most of them are set in the same dbspace and from time in time, we remove the oldest, opening a few gaps of free space over the firsts chunks of the dbspace. These dbspace are made of few chunks and we want to move all data to the firsts and remove the last chunks to recover disk space.
Votes: 1
Created January 10, 2019
Status: Needs review
Popular (Over 50 votes)
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: 93
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: 79
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: 65
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: 63
Created: December 24, 2018
Status: Future consideration
Gary Ben-Israel
Informix corner
IIUG Announces First in Series of Worldwide Informix Tech Day Events to take place in India
The IIUG is excited to announce the first in a series of Worldwide Informix Tech Day Events.
The IIUG will be coming to you in 2020!
The first two locations are:
March 24 – Bengaluru, India
March 26 – Chennai, India
EXPAND YOUR HORIZONS
Take control of your data, gain new insights from it, and drive digital transformation and innovation across your business! Come spend a day with the IBM and HCL Informix teams during this technical exchange covering the unmatched capabilities of Informix. Learn new ways to deliver significantly greater business value and operational efficiency from our experts.
Clients and partners interested in IBM Informix, or looking to address data management challenges, are invited to this event.
FOR MORE INFORMATION AND TO REGISTER CLICK HERE
4.2 February 2020 Webcast – Easy Replication from On Prem to Cloud
With minimal or zero downtime to your applications, with simple command or using a phased approach, automate data migration across operating systems/platforms, setup replication between on-prem Informix instance to a cloud database instance.
Nagaraju Inturi
Software Engineer
HCL Software
4.3 Coming in 2020 – Free Informix Tutorials Webcast Series!
Advanced DataTools are pleased to announce a 2020 Webcast series for Informix DBAs: “Informix Tutorials”. They will discuss configuration, disk layout, backups, performance tuning, and high availability disaster recovery implementation. The Informix Webcasts are based on over 30 years of experience managing and tuning database systems. The webcasts will be presented by Lester Knutsen, Art Kagel, Tom Beebe, and Mike Walker – all IBM Informix Champions from Advanced DataTools.
You will need to register for each Webcast separately.
For more information – https://advancedatatools.com/tech-info/next-webcasts/
Events
IBM Think 2020 – San Francisco
May 4, 2020 – May 7, 2020
Moscone Center – SF, 747 Howard St
San Francisco, CA 94103 United States + Google Map
Informix Resources
IIUG website
www.iiug.org
IBM Informix community
/community
6.1 Informix Blogs and Wikis
Blogs and Wikis
-
Art Kagel http://informix-myview.blogspot.co.il/
-
Andrés Repossi https://andreserepossi.wixsite.com/hablemosinformix (In Spanish)
Social Media
Linkedin: https://www.linkedin.com/groups/25049
Twitter : https://twitter.com/iiug
Facebook : https://www.facebook.com/IIUG.Informix
6.3 Forums, Groups, Videos, and Magazines
- The IIUG old forums at /forums/technical.php *** NO LONGER ACTIVE ***
- Informix Marketing channel on YouTube http://www.youtube.com/user/informixmarketing?feature=results_main
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
