Appropriate Content: Informix Documentation Team
96QY_Pat_Smith 27000196QY 873 Visits
If you haven't already looked at IBM Informix Version 11.70, which was released last quarter, you can easily do that now, just by reading about the new features in the "What's new in Informix" topic in the IBM Informix 11.70 Information Center. You'll find that this release has many new installation, migration, administration, embeddability, Enterprise Replication, high-availability, performance, security, and warehousing features. When you open the 11.70 Information Center, expand "Product Overview" to navigate to the "What's new in Informix" topic.
An Informix customer suggested that we create a quick reference card for the SQL administration API, so we created one for 11.50.xC8.
This quick reference card shows SQL administration API task() and admin() function arguments sorted by functional category with examples of syntax. Version numbers indicate in which version of Informix each argument was introduced.
This is the last blog entry for the year: Happy New Year!
96QY_Pat_Smith 27000196QY 751 Visits
Informix Version 11.70 contains enhancements to high-availability cluster functionality. One of these enhancements lets you upgrade an 11.50 cluster to an 11.70 cluster without any downtime. For detailed information about this process, read the "Upgrade Informix high availability clusters online" developerWorks article, written by Anju Sudhakar and Sapna Ramesh. two of our esteemed Informix software engineers.
We asked IBM® Software Support about the questions they are frequently asked about Informix® and put the questions and answers in the v11.70 information center. Most questions are about installing, upgrading, and administering Informix.
Take a look at the FAQ in the information center and let us know what you think!
The 59 new oninit return codes introduced in Informix® 11.70 describe exactly why the server didn't start. We also document what your next move should be.
For example, oninit return code 175 says: The database server failed to initialize the root dbspace. What you should do if you get this return code is to check the root dbspace related parameters in server configuration file (onconfig) to make sure that the path for the root dbspace is valid.
The oninit return codes are documented in the Administrator's Reference.
96QY_Pat_Smith 27000196QY 813 Visits
Neelima Doguparthy, an IBM Informix software engineer, wrote a very useful developerWorks article about version 11.70.xC1 new features that have upgrade and reversion impact. The article is designed to help you smoothly upgrade to version 11.70.xC1 and efficiently use the new features. The article contains descriptions of new features that have upgrade and reversion impact, along with lists of new configuration parameters and information about the system catalog changes that were made for the new features.
You can also read about new features in the "What's new in Informix" topic in the IBM Informix 11.70 Information Center, and you can find information about reversion restrictions and lists of new configuration parameters, new environment variables, new keywords of SQL, and system catalog changes in the version 11.70 IBM Informix Migration Guide.
This entry is provided by Tom Houston, our esteemed SQL writer. He will be contributing the occasional entry about how to interpret syntax diagrams as they are used in IBM® Informix® documentation.
The Informix documentation uses syntax diagrams to summarize in a graphic format the syntax tokens -- the keywords, input values, delimiters, and other symbols -- and the order in which they can appear in a valid statement or command. Syntax diagrams that Informix user documents like Administrator's Reference and Guide to SQL:Syntax use a standard graphical notation that many IBM products currently use. Syntax diagrams are described in the Introduction chapter of PDF manuals and in the information centers.
The term syntax note refers to
Several instances of the same parenthetical digit (or digits) within the diagram can reference the same note below the diagram.
This blog entry addresses two potential ways to interpret a syntax note:
This diagram of the CONNECT statement of SQL (for the Informix 11.70 database server) includes two restrictive syntax notes and two cross-reference syntax notes:
1. See Database Environment
2. ESQL/C and DB-Access only
3. See USER Validation Clause
4. ESQL/C only
Here the cross-referencing note (1) that follows the Database Environment syntax segment matches the digit that precedes the
text of the "See Database Environment" note below the diagram, which is a link to the topic that shows the syntax of the Database
Environment syntax segment. Similarly, the cross-referencing note (3) that follows the USER Authentication Clause
syntax segment matches the digit that precedes the text of the "See USER Validation Clause " note below the diagram, which is a link to
the topic that shows the syntax of the USER Authentication Clause syntax segment.
The digit 2 delimited by parentheses (2) preceding the optional USER Authentication Clause syntax segment matches the digit that precedes the "ESQL/C and DB-Access only" syntax note text, restricting that clause to IBM Informix ESQL/C routines and to scripts of the DB-Access utility. This note implies, for example, that the database server will throw an exception if you attempt to run an SPL routine that attempts to connect to a database by using a CONNECT statement that includes this clause.
Similarly, the digit 4 delimited by parentheses (4) preceding the optional WITH CONCURRENT TRANSACTION keywords matches the digit that precedes the "ESQL/C only" syntax note text, restricting that clause to IBM Informix ESQL/C routine. In this diagram, the optional TRUSTED keyword is outside the scope.of syntax note (4), because a CONNECT statement that omits the WITH CONCURRENT TRANSACTION keywords can reach the TRUSTED keyword without following a path that syntax note (4) restricts.
In both instances, the restrictive syntax notes appear immediately above the path of the syntax tokens that the syntax note references, and to the left of those tokens. Syntax notes do not refer to the path above the digit that identifies the note. To apply the same syntax note to several independent paths in a diagram, the parenthetical digit that identifies the syntax note must be repeated for each path.
In an SPL routine, the following SQL statement fails with an error:
CONNECT TO DEFAULT WITH CONCURRENT TRANSACTION TRUSTED;
Even if a default database environment is defined for the current session, this statement fails because CONNECT statements that include the WITH CONCURRENT TRANSACTION keywords are not supported in SPL applications (unless the SPL routine invokes an ESQL/C routine to issue the CONNECT statement).
In summary, a cross-reference syntax note
A restrictive syntax note
Simplify the process of adding storage space by configuring for the automatic expansion of the space
96QY_Pat_Smith 27000196QY 767 Visits
If you upgrade to version 11.70, you can configure Informix to automatically expand an existing storage space when the space is full. You can also configure Informix to expand the space before it is full, when its free pages fall below a specified threshold. When you enable and configure automatic storage provisioning, you do not need to manually add storage space to avoid out-of-space errors. Even if you prefer to add space manually, automatic storage expansion greatly simplifies the process of adding space, because you do not need to determine where to get the space.
IngeHalilovic 060000MPB8 Tags:  configuration quick_reference informix onconfig onstat 1,310 Visits
The Quick Reference Cards for onconfig.std and onstat have been updated for Informix 11.70. These cards are designed to be printed double-sided on legal-sized paper (8.5" by 14") and folded into a four-sided pamphlet. They look best printed in color, especially the onconfig.std card, which shows version numbers in red.
IngeHalilovic 060000MPB8 Tags:  highlights 11.7 database features information_center information informix 1,512 Visits
Do you want to know exactly what's new for IBM® Informix® 11.70? Visit the new v11.70 information center.
For highlights of Informix 11.70, short descriptions of all the new features, and links to where the features are described in detail, see What's new in Informix.
Don't forget to subscribe to the RSS feed so that you'll know when we update the information center.
The v11.70 information center has the same collaboration features as the v11.50 information center. Find out how to comment on, rate, and watch topics.
The v11.70 information center works best with these browsers: