Appropriate Content: Informix Documentation Team
jasna 110000T2XC Tags:  applications 4gl ide informix-genero genero-studio application-development 5,478 Views
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?!
With version 11.70, you can see which tables have outstanding in-place alter operations. (Tables that have outstanding in-place alter operations can cause a slight performance degradation.)
Each table with an outstanding in-place alter operation has an informative alert row in the ph_alert table in the sysadmin database. For more information, see In-place alter in the IBM Informix 11.70 Information Center, or see information on the Alerts page of the Health Center in the IBM OpenAdmin Tool for Informix .
Query Acceleration for Business using Informix Warehouse Accelerator
A draft IBM Redbooks publication (Planned Published date of November 2013)
IBM Informix Warehouse Accelerator (IWA) is a state-of-the-art in-memory database designed to exploit affordable innovations in memory and processor technology and trends in novel ways to boost query performance. It is a disruptive technology that changes how organizations provide analytics to its operational and historical data. Informix Warehouse Accelerator leverages columnar, in-memory approach to accelerate even the most complex warehouse and operational queries without application changes or tuning.
This book provides a comprehensive look at the technology and architecture behind the system. It contains information about the tools, data synchronization, and query processing capabilities of Informix Warehouse Accelerator, and steps to implement data analysis by using Informix Warehouse Accelerator within an organization.
Chapter 1. Introduction to Informix Warehouse Accelerator
IngeHalilovic 060000MPB8 Tags:  assertion_failure database error server informix corruption 3,287 Views
Did you know that assertion failures are the number one reason for calls to Informix® support? When we in Informix documentation found that out, we decided to shed some light on assertion failures.
What is an assertion failure?
An assertion failure occurs when the database server cannot continue normal processing and must shut down.
What do I do when I get an assertion failure?
If your production server is currently down, contact IBM® Software Support immediately.
To correct an assertion failure:
Tune in next week for part 2 -- how do you prevent assertion failures from happening.
IngeHalilovic 060000MPB8 Tags:  administration assertion_failure backup informix update_statistics prevention 2,980 Views
In my previous entry, I gave some tips on how to correct assertion failures in the Informix® server. Obviously, the real goal is to prevent them in the first place!
Here are some things you should do on a regular basis that might prevent assertion failures:
To find out how and why each of these tasks can prevent assertion failures, read this topic: Prevent and prepare for assertion failures.
Of course, you should always be prepared for a catastrophic failure, so make sure you backup your data, logical logs, and your database and storage spaces schemas.
Backup and restore configuration parameter reference topics consolidated into one Backup and Restore Guide chapter
In Version 11.70xC4, all reference topics on ON-Bar, ontape, and archecker utility configuration parameters are now consolidated into a new "Backup and restore configuration parameters" section of the IBM Informix Backup and Restore Guide. Additionally, duplicate topics on backup and restore configuration parameters have been removed from both the Backup and Restore Guide and the Administrator's Reference. This should make it easier to find backup and restore configuration parameter reference information. This is just one example of the kinds of documentation improvements we like to make for each new release of the Informix product.
Click Backup and restore configuration parameters to view the consolidated information in the Backup and Restore Guide.
IngeHalilovic 060000MPB8 Tags:  text bts zseries pseries json text_search search informix 2,660 Views
With IBM® Informix® version 12.10.xC5, the powerful and flexible basic text searching feature is now available for Linux on IBM Power Series and IBM zSeries machines:
If you're not already a fan of basic text search, here's some of the reasons why you should be:
Find out more: basic text searching.
Basic text searching in Informix v11.50 became more versatile, configurable, and faster. See the What's New in Database Extensions for more information.
Process Multiple Basic Test Search Queries Simultaneously
If basic text search queries are slow because multiple users are running queries at the same time, you can add more BTS virtual processors so that queries run simultaneously, each in their own virtual processor. Previously, you could only create one BTS virtual processor and queries ran serially.
Control the Results of a Fuzzy Search with the Basic Text Search DataBlade® module
You can now specify the degree of similarity of search results in fuzzy searches when using the Basic Text Search DataBlade module. Specify a number between 0 and 1, where a higher value results in a higher degree of similarity. To limit results, specify a higher number. To maximize results, specify a lower number. The default degree of similarity is 0.5.
Map Characters for Indexing with the Basic Text Search DataBlade module
You can now map characters in your data to other characters during indexing with the Basic Text Search DataBlade module. For example, you can specify that letters with diacritical marks are indexed as the same letters without marks. You can also standardize inconsistent prefixes or delete character strings from indexed text. To use character maps, include the canonical_maps parameter when you create your bts index.
Default Boolean Operator in Basic Text Search Queries
You can now change the default Boolean
operator between search terms in Basic Text Search queries from OR to AND by
using the query_default_operator parameter when you create a bts index. The default
operator is represented by a blank space between terms. Many popular end-user
search engines use AND as the default operator between search terms, where
end-users expect the search results to contain all their search terms.
Storage for Temporary Basic Text Search Files
You can now specify that temporary files used by the Basic Text Search DataBlade module are stored in a separate sbspace from the one used to store the bts index. Separating temporary files from the bts index might improve query performance.
Track Basic Text Search Query Trends
You can now track what queries are run against your bts index by including the query_log parameter when you create a bts index. You can use query trends information to provide hints to end-users on popular queries or work on optimizing the most popular queries.
Fragment bts Indexes by Expressions
You can now fragment bts indexes by expressions into multiple sbspaces instead of a single sbspace.
Basic Text Search DataBlade module Supports High-Availability Clusters
You can now use the Basic Text Search DataBlade module to perform searches on high-availability cluster servers by creating indexes in sbspaces. Previously, the Basic Text Search DataBlade module only supported the creation of indexes in extspaces, and thus could not participate in any queries on high-availability secondary servers and in backup and restore operations.
Querying XML Attributes with the Basic Text DataBlade module
The Basic Text Search DataBlade module now supports searches on XML attributes in a document repository. The new all_xmlattrs parameter enables searches on all attributes that are contained in the XML tags or paths in a column that contains an XML document.
Support added for a user-defined stopword list
You can create a customized stopword list for frequently occurring words in your data or you can use the default stopword list.
Support added for XML-structured documents
You can use Basic Text Search XML index parameters to manipulate searches of XML data in different ways.
IngeHalilovic 060000MPB8 Tags:  thesaurus database index informix analyzer stopword search text 2,544 Views
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)
jmcdavid 270003BVSW 1,432 Views
The Informix 2013 Survey is now available. Make your voice heard! Tell us how you use Informix products. Let us know how you would like to use Informix products.
Your feedback is very important. Take the time to be a part of the discussion.
Before version 11.70, database operations treated strings stored in all Informix databases as case-sensitive. For example, a query for the string "Central" returns "Central" but not "CENTRAL" or "central". Operations designed to disregard the case of text strings required a bts index or a functional index for each query.
In version 11.70, a database is still created as case-sensitive by default. However, you can use the NLSCASE INSENSITIVE option with the CREATE DATABASE statement to create a database that ignores the case of text strings. For example, querying "Central" returns "Central", "CENTRAL", and "central".
A case-insensitive database ignores letter case only on NCHAR and NVARCHAR data types, but it treats the other built-in character data types (CHAR, LVARCHAR, and VARCHAR) as case-sensitive. You cannot include both case-sensitive and case-insensitive databases in a distributed query.
For more information, see Specifying NLSCASE case sensitivity.
JohannaTuraj 0600007SU6 1,763 Views
We've made some changes to the Informix on-line notes in the 12.10.xC2 release.
Release notes are provided only in HTML format, in the Information Center and with the product. Text versions are no longer available.
We removed redundancy and the need to look in multiple files to get the information that you need.
IngeHalilovic 060000MPB8 Tags:  features time_series database fixpack informix 11.70.xc5 iwa 4,030 Views
IBM Informix 11.70.xC5 is available today! Here's a summary of the new features:
Global language support
Time series data
Informix Warehouse Accelerator
Read the full new feature descriptions with links to complete information here.
But wait! there's more! We've done some improvements to the documentation, including: