IIUG Insider (Issue #237) April 2020

by

Highlights: IBM Virtual User Group Days

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 IBM Virtual User Group Days

3) IBM Informix Forum Corner

   Who is BeMyApp? Targeting members of IBM forums?

   Promoting RSS nodes

   DELIMIDENT

   Long Running Purge Script

4) RFE Corner

5) Informix Corner

5.1 Informix 14.10 Now Supports Common Table Expressions Webinar

6) Events / Surveys

   6.1 Think Digital Event Experience

   6.2 IBM Virtual User Group Days

7) How to

8) Informix Resources

   8.1 Informix Blogs and Wikis

   8.2 Social Media

   8.3 Forums, Groups, Videos, and Magazines

1) Editorial

I’m still in lock down due to the COVID 19 Corona virus.

Only virtual events are taking place. And work for many of us has slowed down or stopped.

It will take a while until things will return to normal.

I wish good health to all.

IMPORTANT: We need you to help show your love of Informix. DBTA has opened up their Annual voting for information management solutions, products, and services. Hurry a place you vote, voting closes Wednesday, May 8th. Thanks for your support. URL: http://www.dbta.com/ReadersChoice/2020/

Stay safe.

Gary Ben-Israel

IIUG Insider Editor

IIUG Board of Directors

gary@iiug.org

2) Highlights

2.1 IBM Virtual User Group Days

Join other like-minded users for this unique 2-day virtual experience. Learn about new and existing technologies for products you love from a company you know. Choose from several sessions presented by IBM professionals, partners, customers, and users from around the world who want to share their knowledge and experience with you.

Join us May 19th & 20th, 2020 from 8:00AM to 4:30 PM (ET) at ibm.biz/usergroupday.

This time, users take the stage for this 2-Day Event Featuring 96 Hours of Content.

We are uniting over a dozen IBM User Groups for a 2-day virtual conference with 6 tracks each day featuring lessons, demos, keynotes, feedback sessions, expert advice, and more. Choose from a comprehensive selection of sessions presented by IBM professionals, partners, customers, and users from around the world who are excited to share their knowledge and expertise with you. Learn more about the technologies you use every day, start a conversation, ask questions, or find new User Groups to connect with. No matter your technology, tool, or proficiency, you will find something here to grow your skillset. Join us on May 19 & 20 for the free, live event!

NOTE: The official schedule is on yet completed. Keep checking the User Group Day website for the full schedule. Informix sessions are scheduled for some time during the afternoon of May 19.

#IBMUserGroupDay

Thank you for supporting IBM Virtual User Group Days!

3) IBM Informix Forum Corner

Join and visit the IBM Informix community forum at http://www.iiug.org/community

Recent posts

Who is BeMyApp? Targeting members of IBM forums?

Promoting RSS nodes

DELIMIDENT

Long Running Purge Script

Gary Ben-Israel

4) 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

Add SQL-statement COMMENT ON as in Oracle or PostgreSQL

Votes: 1

Created April, 27 2020

Status: Needs review

Allow partial indexes in all editions

Votes: 8

Created April, 22 2020

Status: Needs review

PN_STAGEBLOB_THRESHOLD – Set to 1Mb when first table containing BYTE or TEXT is partitioned by Round Robin

Votes: 1

Created April, 15 2020

Status: Needs review

Add function LISTAGG like DB2 and Oracle

Votes: 9

Created April, 14 2020

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: 97

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: 82

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: 66

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: 65

Created: December 24, 2018

Status: Future consideration

Gary Ben-Israel

5) Informix Corner

5.1 Informix 14.10 Now Supports Common Table Expressions Webinar

Informix 14.10 Now Supports Common Table Expressions Webinar

May 26 @ 1:00 pm – 2:00 pm

6) Events / Surveys

6.1 Think Digital Event Experience

Accelerate essential recovery and transformation

https://www.ibm.com/events/think/

May 5–6, 2020

6.2 IBM Virtual User Group Days

May 19 @ 8:00 am – May 20 @ 5:00 pm

URL: ibm.biz/usergroupday

7) How to

Calculating the difference between datetime columns

select (((t2 – t1)::interval second(9) to second)::char(10))::int

8) Informix Resources

IIUG website
www.iiug.org

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

8.1 Informix Blogs and Wikis

Blogs and Wikis that have been updated during the last month

More Blogs and Wikis

8.2 Social Media

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

Twitter : https://twitter.com/iiug

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

8.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

PageLines