This article is written in English and Portuguese
Este artigo está escrito em Inglês e Português

English version:

The documentation team is asking for our input. It's just a brief survey that will take no longer than 5m to answer.
The survey address is:

https://www.ibm.com/survey/oid/wsb.dll/s/ag506
Please take a few minutes to help them improve the documentation and define future priorities.

I came across an issue when I was trying to run Informix 4gl programs (7.50FC6X1) on an Informix 12.10FC1 engine.

The error I received was "Please install an INFORMIX-4GL Run Time Facility and run this program again".

The only thing I did was to upgrade Informix from 11.70FC7 to Informix 12.10FC1.

After working with tech support, I found out that there were some message files for 4gl that were not in Informix 12.10FC1.

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

To acquire the isolation level the following store procedure will return a number representative the isolation level in the table below.

CREATE FUNCTION Get_Isolation_Level()
RETURNING INTEGER

RETURN (SELECT isolevel
FROM sysmaster:sysrstcb R, sysmaster:systxptab T
WHERE R.sid = DBINFO(“sessionid”)
AND T.address = R.txp);

END FUNCTION;

EXECUTE FUNCTION Get_Isolation_Level();

If a user wants to ensure a log is closed after a specific duration, the following procedure and database scheduler task will accomplish this task.

This redbook will be published later this year.  We'd like to invite comments/requests for topics.

Here is the draft table of contents.    Checkout the available Informix redbooks at: http://www.redbooks.ibm.com/redbooks.nsf/searchsite?SearchView&query=informix&SearchOrder=4&SearchFuzzy=

I will be co-sponsoring a Big Data Customer event in NYC with one of our key business partners, Axeor. David Laverty, VP Worldwide Marketing for Information Management at IBM, will share his insights on Marketing in the age of Big Data.  Come learn how to make Big Data work for your company. If you are a top-level executive in your company and are in the NYC area on June 19, 2013; please join IBM and Axeor Solutions at this exclusive event.  Space is limited so please register now at:

Blog Content/Topics List

This article has been written based on experience with version 11.70.FC5W1 and assumes some knowledge of stats and distributions and how they affect query optimisation. I appreciate any feedback in the comments section on my WordPress blog.

Auto update stats was introduced in 11.50.xC1 and, while being partly aimed at the embedded market, meant for the first time there was a complete solution to gathering database statistics bundled inside the product.

Title: Primary Storage Manager (PSM) a parallel backup alternative to ontape
Date: Tuesday, May the 30th
Time: 10:30 AM PST
Duration: 60 Minutes
Registration: Primary Storage Manager (PSM) a parallel backup alternative to ontape
Speaker: Gustavo Castro - Software Engineer (IBM)