- Automatic read-ahead operations
- Configuring the server response to low memory
- Reserving memory for critical activities
- Connection Manager enhancements
- Enhancements to the OpenAdmin Tool
- Managing message logs in embedded and enterprise environments
- Built-in SQL compatibility functions for string manipulation and trigonometric support
- Client SDK includes the DB-Access utility
- High availability clusters and Enterprise
- Automatically connecting to a grid
- Code set conversion for Enterprise Replication
- Enhancements to the Informix Replication plug-in for OAT
- Non-root installations support shared-memory and stream-pipe connections
- Retaining numbers for audit log files
- Restrict operating system properties for mapped users
- Time Series data
- Simplified handling of time series data
- Informix TimeSeries plug-in for OAT
Appropriate Content: Informix Documentation Team
IngeHalilovic 060000MPB8 Tags:  informix oat memory enterprise_replication utf8 warehouse connection_manager dbaccess readahead grid low_memory audit timeseries 2,050 Visits
The Informix® 11.70 information center has been updated with 11.70.xC3 information!
I recently looked through the list of new DeveloperWorks articles and discovered an excellent article about how to use fragment-level statistics. Fragment-level statistics, which are a new IBM Informix version 11.70xC1 feature, affect the way UPDATE STATISTICS MEDIUM and HIGH operations gather data and generate column distributions on fragmented tables. For information on the circumstances under which you might want to use fragment-level statistics as well as details about setting up your system to use fragment-level statistics, see:
Incidentally, the DeveloperWorks article includes the following code example for forcing the use of fragment-level statistics. This example includes the new STATLEVEL property of a fragmented table. See the DeveloperWorks article and the Informix documentation for more details about the code:
CREATE TABLE tab1(col1 integer, col2 char(10))
96QY_Pat_Smith 27000196QY 797 Visits
You can use MQ messaging functions to enable Informix applications to exchange data directly between the application and IBM WebSphere MQ. Applications can send and receive messages from local or remote queue managers that reside anywhere in the network and participate in a transaction.
IBM Informix Version 11.70 includes several new MQ messaging functions, which simplify administrative tasks and reduce the number of WebSphere MQ licenses that are needed.
For more information, see What's new in Database Extensions for IBM Informix, version 11.70 in the Database Extensions Users Guide.
IngeHalilovic 060000MPB8 Tags:  thesaurus database index informix analyzer stopword search text 1,515 Visits
In IBM Informix 11.70.xC2, you have many more option for customizing basic text searching for your needs.
See the What's New for links to each of these features.
Here are a couple of examples:
The following example creates a bts index on two XML fields and uses a different analyzer for each field:
CREATE INDEX boats_bts
The following example creates stopword list of am, be, and are for all fields except the fields author and title, which have their own stopwords, and the field edition, which does not have any stopwords.
CREATE INDEX books_bts ON books(book_data bts_lvarchar_ops)
Each version of Informix supports new SQL keywords that are reserved words. The use of these words in your applications might affect the migration of your applications when you upgrade to a new version of Informix. If you haven't migrated to the new version and would like to see the new keywords, you can find them listed in the following IBM Informix Migration Guide appendix: New keywords of SQL
The Version 11.70 IBM Informix Guide to SQL: Syntax contains an alphabetic list of all keywords.
Howard Glaser will be handing out printed copies of our version 11.70 Quick Reference Cards at IIUG next week, including the new SQL administration API card:
fwelsch 06000203CP Tags:  informix_connect installation installer informix client_sdk 1,461 Visits
As an information developer who has documented and completed numerous Informix® installations in GUI mode for over 4 years, I've really liked how the installer has evolved. First, with version 11.10, the custom setup of the installer let you peel away the features of the database server that you did not want. This functionality, known as the deployment wizard, helps you save on disk space when you want to minimize the footprint of the installation. The revised interface also provided a short description of each feature—just enough information to let you know whether or not it was a component that you needed.
Client SDK and Informix Connect are fully integrated into the IBM® Informix Software Bundle version 11.70 installer in such a way that there is no need for separate standalone and bundle media. The major client programs appear in the feature tree in custom setup, so that in one step of the installation process you can exercise your right to exclude whatever client programs and whatever base server features that you don't need. (See the IBM Informix Software Bundle screen capture below.) Unlike previous versions, there is one unified interface after launching the installation of the Informix server with either Client SDK or Informix Connect. No more watching installers of separate products open and close.
Right after you select products and features, the installer puts you back in the driver seat again. You can choose whether the installer should automatically create a working instance of the database server—and if you do, you can opt to specify major configuration parameters yourself or let the installer calculate working configuration settings based on the host environment.
And perhaps the best part is that you can still complete a product installation with the media in less than 30 minutes!
Did you know that the IBM Informix Version 11.70 Information Center contains a "Troubleshooting and support" section?
This section includes:
The last three items are also available in the "Troubleshooting and Support" section of the Version 11.50 Information Center.
If you run warehousing queries with Informix, you need to find out about Informix Ultimate Warehouse Edition, which includes Informix Warehouse Accelerator. The accelertor plugs into Informix, either on the same computer or a different computer, and automatically runs warehousing queries at speeds many times faster than Informix alone. After you set a few configuration parameters and define data marts with the accelerator, whenever you run a query, the Informix query optimizer determines if the accelerator can run the query. If the accelerator can process the query, the query is sent to the accelerator automatically. That means you don't need to make any changes to your application to take advantage of the accelerator. It runs invisibly--the only indication you'll see when the accelerator runs a query is that the query results appear surprisingly quickly.
Check out the Warehousing portal in the 11.70 information center and read the Informix Warehouse Accelerator blog.
jasna 110000T2XC Tags:  applications 4gl ide informix-genero genero-studio application-development 2,949 Visits
There's much excitement around here now that IBM® Informix® Genero® is generally available. In fact, you might want to mark your calendar for the April 21 "Chat with the labs" to hear Jerry Keesee and Shawn Moe describe the new Informix Genero offering, including packaging, sales, and technical support.
During the development phase, I installed the product to verify some installation instructions. The installation went smoothly and was very quick and easy to do -- I just followed the prompts on the installation application and, voila, in minutes I had the integrated development suite on my laptop.
I thought I'd explore the graphical Form Designer in Informix Genero Studio. A form is the user interface for Informix Genero applications. For example, forms allow application users to query a database or to make changes in the rows of a database table. Adding widgets to the form was simple. With a few clicks, I selected the fields that I wanted to add and then I typed labels for them. From the Genero Studio workspace, I could customize the form. I simply grabbed the fields to make them longer or shorter. I selected items from the form structure list, deleted them, and then they disappeared from the rendered image. Oh the power! Hmm, maybe in my next life I should be a developer?!