IIUG Insider (Issue #239) June 2020

by

Highlights: IIUG Survey 2020 – Your voice needs to be heard!

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.

<HTMLTEXT LINK>

Contents:

1) Editorial

2) Highlights

  2.1 IIUG Survey 2020 – Your voice needs to be heard!

3) IBM Informix Forum Corner

4) RFE Corner

5) How To

6) Informix Corner

  6.1 Informix 1410xc4w1 Rocks! New great top feature available

  6.2 Informix – new release available

7) Events

  7.1 Upgrade with Success from Informix 11.70 to Informix 14.10

  7.2 Creating Databases, Tables and managing Security

  7.3 Informix Database Server Monitoring

8) Informix Resources

  8.1 Informix Blogs and Wikis

  8.2 Social  Media

  8.3 Forums, Groups, Videos, and Magazines

Editorial

Still recovering from eye surgery. Work is hard but I’m doing my best for you guys.

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.

Stay safe.

Gary Ben-Israel

IIUG Insider Editor

IIUG Board of Directors

gary@iiug.org

2) Highlights

2.1 IIUG Survey 2020 – Your voice needs to be heard!

Dear Informix friends,

It has been some time since snapshots regarding the state of Informix and the means of representing Informix users were taken. For that purpose, the IIUG (International Informix Users Group) Board of Directors has devised a short survey regarding those two subjects. The idea behind this survey is to better shape the collective voice of the Informix Community and increase ways for IIUG to serve this Community.

Completing the survey will take no more than 10 minutes of your time and it would mean a lot to us and the future of Informix. The survey can be accessed via: https://www.surveymonkey.com/r/HSRBWXN. Please find some time in your busy schedule to complete the survey. Feel free to share this with your relevant coworkers, customers, etc.

Thanks in advance,

IIUG Board of Directors

Cindy Lichtenauer – IIUG President

3) IBM Informix Forum Corner

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

Recent posts

Informix 12 or 14 on Centos 8

A bit of reverse engineering on oncmsm

Release 14.10xc4

Adding primary to a table having duplicate rows

534 error occurs when executing set explain on

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

Clear Indication when RSS_FLOW_CONTROL or SDS_FLOW_CONTROL is actively applied

Votes: 1

Created June, 25 2020

Status: Needs review

Add configurable per session/per PDQ thread log cache similar to Sybase user log cache

Votes: 1

Created June, 19 2020

Status: Needs review

Improve performance on multifact query on an informix database

Votes: 3

Created June, 16 2020

Status: Needs review

Make onstat -g rss log buffer(s) size configurable

Votes: 4

Created June, 4 2020

Status: Needs review

Add readahead per sessions/sql counters

Votes: 5

Created June, 4 2020

Status: Needs review

Allow placement of tablespace BYTE and TEXT data in a separate dbspace from the table’s base row data

Votes: 16

Created June, 2 2020

Status: Needs review

255 rows/page limit should be addressed

Votes: 13

Created June, 2 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: 102

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

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

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

Created: December 24, 2018

Status: Future consideration

Gary Ben-Israel

5) How To

Checking table authorization

Checking programmatically if a user has permission for a table is not easy. The permission scheme is hierarchical. For instance, if

role_2 has select permission on table table_1 and role_1 is the

grantee for role_2 and user_1 is the grantee for role_1 we need to go down the tree to determine if user_1 has select permission for table_1.

Lucky for us Informix has a connect by select statement that can deal with hierarchy.

This stored procedure’s parameters are table name, user name and permission type It returns true or false.


create function check_tab_auth(t_nm nvarchar(128), u_nm varchar(16))
returning boolean
define r_nm char(4);
define t_role nchar(32);
foreach
select b.grantee
into t_role
from systables a, systabauth b
where a.tabname = t_nm
and b.tabid = a.tabid
and b.tabauth[1] = 's'
if t_role = u_nm then
return 't';
end if
if (select count(*)
from sysroleauth a
where a.rolename = t_role
start with grantee = u_nm
connect by prior rolename = grantee) > 0 then
return 't';
end if
end foreach
return 'f';
end function;

6) Informix Corner

6.1 Informix 1410xc4w1 Rocks! New great top feature available

After the 14.10.xC4 embargo, finally, Informix Dynamic Server 14.10.xC4W1 has been released.

This new version includes tons of bug fixes as usual. You can check the list of the customer reported bugs fixed at: https://www.ibm.com/support/pages/fix-list-informix-server-1410xc4w1-releases…

Vicente Salvador

Read the entire article

6.2 Informix – new release available

Hello! Informix 14.10.xC4 release was launched

Check here a small briefing of new features.

  • Informix .NET Core

Starting with CSDK 4.50.xC4, Informix .NET Core Provider compatible with .NET Core SDK/Runtime v3.1 is shipped for Windows x64 and Linux x86_64 platforms….

Alexandre Marini

Read the entire article

7) Events

7.1 Upgrade with Success from Informix 11.70 to Informix 14.10

July 14 @ 10:00 am – 11:00 am

Are you running IBM Informix Dynamic Server (IDS) 11.70? Join this session to help with your plans to migrate from Informix 11.70 to Informix 14.10 with ease. Please note that Informix 11.70 will reach End of Service (EOS) on September 30, 2020.

https://www.iiug.org/event/upgrade-with-success-from-informix-11-70-to-informix-14-10/

7.2 Creating Databases, Tables and managing Security

July 23 @ 2:00 pm – 3:00 pm

How do you build databases and tables in Informix? We will discuss best practices for creating and managing databases and tables, partitioning, and database security.

https://www.iiug.org/event/creating-databases-tables-and-managing-security-by-lester-knutsen/

7.3 Informix Database Server Monitoring

August 20 @ 2:00 pm – 3:00 pm

How do you use the command-line utilities to manage and monitor an Informix Server? We will discuss onstat, oncheck, and the new InformixHQ to manage your server.

https://www.iiug.org/event/informix-database-server-monitoring-webinar-by-lester-knutsen/

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