Recently we've added information portals to the Informix® 11.70 information center. Information portals have links to key documentation both within and outside the information center. For example, we'll include links to interesting developerWorks® articles and Redbook® publications. Most of these portals are the top level nodes in the left hand navigation pane of the information center.
Here are the ones we've done so far:
Let me know if you have suggestions for additions to these portals or other portals you would like to see!
IBM® Informix® 11.50.xC9 is the ninth release of 11.50, and yet, it has new features! Here's a summary:
- Reserving memory for critical activities
- Configuring the server response to low memory
- Handle high severity event alarms
- Reserving space for BYTE and TEXT data in round-robin fragments
- Enhancements to the OpenAdmin Tool (OAT) for Informix
- IBM Informix TimeSeries Plug-in for OpenAdmin Tool (OAT)
- Application Development
- Comparing date and interval values
- Enterprise Replication
- Easier setup of faster consistency checking for Enterprise Replication
- Support for later versions of IBM Global Security Kit (GSKit)
Check out these new features in the 11.50 information center's What's new in Informix
IBM Informix 11.70.xC5 is available today! Here's a summary of the new features:
- Plan responses to medium-severity and low-severity event
- IFX_BATCHEDREAD_INDEX environment option
- Improvement to the keyword analyzer for basic text
- Increased SQL statement length
- Enhanced query performance
- The Change Data Capture API sample program
- Replication errors on leaf nodes
Global language support
- Scan strings with the ifx_gl_complen() function
Time series data
- Count the time-series elements that match expression
- Remove old time-series data from containers
- New operators for aggregating across time-series values
Informix Warehouse Accelerator
- Refresh data quickly without reloading the whole data mart
- Use high-availability secondary servers to accelerate
- New options added for the use_dwa environment variable
- Support for new functions is implemented
- Support for the Solaris Intel x64 operating system added
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:
Ever wonder what to do when you got a severity 4 event alarm? For IBM® Informix® 11.50.xC9, we added descriptions, server states, and user actions for severity 4 and 5 event alarms to the Administrator's Reference.
Look for the descriptions of the severity 4 and 5 event alarms here
. (You'll have to scroll down a bit to get to the first severity 4 alarm description.) You can see all severity 5 alarms here
. Event alarms specific to Enterprise Replication are here
The Informix® 11.70 information center
has been updated with 11.70.xC3 information!
The new features
in IBM® Informix 11.70.xC3 are:
- 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
Follow this link
to see a short description of the features and links to more detailed information.
Check out some new ideas for OAT and talk to us about how you use Informix and Informix documentation at the IIUG conference in San Diego. Alison Eckholm, the Informix usability expert, and I, the OAT information developer, are hosting a usability sandbox at the conference on April 23, 24, and 25. You can participate in any of these sandbox sessions:
- Take a sneak peek at future possibilities in IBM® OpenAdmin Tool (OAT) for Informix®. Participate and provide feedback in an interactive, small-group session.
- Help optimize the OAT experience by participating in a hands-on activity. Provide feedback on your key tasks and how you would customize OAT.
- Preview enhancements to the Informix Warehouse Accelerator. Check out some of the features being considered and influence the development of this important tool.
- Help us improve the Informix experience. Tell us how you use Informix, how you use the product documentation, and what other kinds of information you need to do your job.
Whether you attend IIUG or not, you can participate in our survey on Informix administration. We want to understand how you find information about Informix when you need it. You can help by completing the survey, whether you use the command line, OAT, or other administrative tools. Your answers will remain anonymous and confidential. To participate, go to the IBM Informix Administration Survey on the IBM website: https://www-950.ibm.com/survey/oid/wsb.dll/s/ag456
The Informix onconfig.std portal is a handy way of finding functionally related configuration parameters. The configuration parameters are listed together, in the same order as in the onconfig.std file, with links to the individual topics for each configuration parameter. You might want to bookmark this portal:
The onconfig.std portal topic is in the Administrator's Reference, in the Configuration Parameters chapter.
If your list of bookmarks is disorganized like mine, you can find the link on the home page of the v11.50 information center, or just type "onconfig portal" into your favorite search engine.
For the first time, the IBM Informix Genero documentation
is available in the Informix 11.70 Information Center. The doc is fully indexed and searchable.
See the Release Notes
for Informix Genero new feature information.
For IBM® Informix® 12.10.xC5, we rewrote the database server installation information. Previously, we had two installation guides: one for UNIX, Linux, and Mac OS X, and one for Windows platforms. For 12.10.xC5, we combined the two guides into one guide and while we are at it, we condensed the information and corrected out-of-date information.
Take a look at the new Installation Guide!
Here's a teaser: the new Preparing for installation topic:
Preparing for installation
Before you install Informix database server products, you must prepare your system and plan for choices that you must make during the installation process.
Preparing for installation includes reviewing system requirements, planning how to upgrade, deciding on the installation owner and the installation directory, reviewing installation options, and gathering information if you want to create a database server during installation. It also includes preinstallation tasks such as obtaining the software and reviewing the machine notes.
To prepare for installation:
Obtain the software. You can download the product package from Passport Advantage: http://www.ibm.com/software/howtobuy/passportadvantage.
Review the Informix components that can be installed with the database server. You can install all of them or some of them.
Ensure that your computer meets the system requirements.
Choose a user account with which to install the product. The user account becomes the installation owner.
UNIX, Linux, Mac OS X: Decide between a non-root owner and an owner with root or administrative privileges.
If you plan to install as an administrative user, decide on a password for user informix.
Choose an installation directory. If the database server is already installed, decide on the upgrade path.
Decide between a typical or custom installation.
Choose a typical installation in the following cases:
To install all database server components, IBM® Informix Client Software Development Kit, and the IBM Informix JDBC Driver.
To create a configured database during installation with connectivity for JSON applications and multiple storage spaces for data.
Choose a custom installation if you want to have any of the following options:
To install a subset of database server components.
To choose which client products to install.
In root-based installation, to set up event auditing for the security policies of your organization.
To create a configured database server during installation with one storage space for data.
To prepare a response file for a non-interactive installation.
Depending on your operating system, you can choose other types of installations that have similar options to a custom installation. UNIX, Linux, Mac OS X: You can choose the Legacy installation to prepare a script-based installation. Linux: You can choose the RPM installation to generate an RPM package.
Decide whether to create a configured database server during installation.
If you do not create a configured database server during installation, you must configure the database server and initialize disk space after installation is complete.
If you create a database server during installation, you must supply some information:
Specify information to configure the database server, such as the number of expected users.
Windows: For a typical setup, specify a password for user ifxjson. This user administers the JSON wire listener.
Log files are created during the installation process. You can use the log files to troubleshoot installation errors.
After you install the database server, you can create the demonstration databases that are included with the database server. Many examples in the documentation and in the $INFORMIXDIR/demo (UNIX, Linux, Mac OS X) or the %INFORMIXDIR%\demo (Windows) directory are based on the demonstration databases. You can use the demonstration databases to explore database server features. You can create the demonstration databases at any time after installation by running the dbaccessdemo command. See Demonstration databases.
IBM® Informix® 11.70.xC4 contains the following new functionality in the following categories.
- Enhancements to the OpenAdmin Tool (OAT) for Informix
- Enhancements to the Informix Replication Plug-in for OAT
- Informix Health Advisor Plug-in for OAT
- Dynamically change additional configuration parameters
- Compare date and interval values
- Plan responses to high severity event alarms
- Data sampling for update statistics operations
- SQL administration API command arguments for creating sbspaces
- Monitor client program database usage
- Progress of compression operations
High availability and Enterprise Replication
- Easier setup of faster consistency checking
- Handle Connection Manager event alarms
- Easier startup of Connection Manager
- Prevent failover if the primary server is active
- Configure secure connections for replication servers
- Global Security Kit (GSKit) support
- Use a file to authenticate server connections in a secured network environment
Time Series data
- IBM Informix TimeSeries Plug-in for Data Studio
- Delete a range of elements and free empty pages from a time series
- Aggregate time series data across multiple rows
- Install Informix Warehouse Accelerator on a cluster system
- Refresh data mart data during query acceleration
- User informix can run the ondwa commands
- Support for new functions is implemented
- New options for monitoring AQTs
With IBM® Informix® 12.10.xc6, you now have increased capabilities when you audit the user actions for your Informix database server with IBM Security Guardium®, version 10.0. IBM Security Guardium prevents leaks from databases, ensures the integrity of information, and automates compliance controls across heterogeneous environments. IBM Security Guardium can now mask sensitive data in Informix databases. IBM Security Guardium can now audit, and if necessary, close, any Informix connection, regardless of the connection protocol. Previously, IBM Security Guardium audited and closed only TCP connections.
After you set up the IBM Security Guardium server, you start the ifxguard utility to monitor connections to your Informix databases. You can set the logging mode and the number of worker threads to prevent heavy locking by editing the ifxguard configuration file. You can enable auditing and set the actions of the database server if the IBM Security Guardium server does not respond in the timeout period by setting the IFXGUARD configuration parameter in the onconfig file.
For more information, see Auditing with IBM Security Guardium.
Note: This description has been updated from what is currently published in the IBM Knowledge Center. The original feature description stated that the ability to use Guardium with Informix was new. Not true! Guardium has worked with Informix for many years, but the capabilities of Guardium with Informix were significantly increased with this release.
Modified on by IngeHalilovic
Informix 12.10.xC4 has some very exciting new features for JSON compatibility:
Support for CORS requests in the REST API (12.10.xC4W1)
You can now set up cross-origin resource sharing (CORS) with the REST API. To do so, set the following optional parameters that were added to the jsonListener.properties file:
Informix now supports the following MongoDB 2.4 features:
Cursor support so that you can query large volumes of data.
Text search of string content in collections and tables.
Geospatial indexes and queries.
Pipeline aggregation operators.
The array update modifiers: $each, $slice, $sort.
You can perform the following new tasks that extend MongoDB functionality in your JSON application:
Import and export data directly with the wire listener by using the Informix JSON commands exportCollection and importCollection.
Configure a strategy for calculating the size of your database by using the Informix extension to the MongoDB listDatabases command: sizeStrategy option or command.listDatabases.sizeStrategy property.
You can customize the behavior of the wire listener by setting new properties. For example, you can control logging, caching, timeout, memory pools, and the maximum size of documents.
Access Informix from REST API clients
You can now directly connect applications or devices that communicate through the REST API to Informix. You create connections by configuring the wire listener for the REST API. With the REST API, you can use MongoDB and SQL queries against JSON and BSON document collections, traditional relational tables, and time series data. The REST API uses MongoDB syntax and returns JSON documents.
Create a time series with the REST API or the MongoDB API
If you have applications that handle time series data, you can now create and manage a time series with the REST API or the MongoDB API. Previously, you created a time series by running SQL statements. For example, you can program sensor devices that do not have client drivers to load time series data directly into the database with HTTP commands from the REST API.
You create time series objects by adding definitions to time series collections. You interact with time series data through a virtual table.
See the IBM Informix JSON Compatibility Guide.
Have you ever been mystified by one of the cdr
return codes, like 174: External Sync abort required? All cdr
return codes now have descriptions and user actions that describe how to recover. For example, the explanation and user action for 174 is this:
synchronization or repair task did not complete in the timeout period.
This error can occur if the replicate being synchronized or the shadow
replicate that was created to resynchronize the data is not active
at all the participants specified in the command.
This error code is also returned when the cdr check
replicate or cdr check replicateset command
is run with the --enable option and the target
server could not be enabled and repaired in the timeout period. The
timeout period is 128 seconds or the value you set with the --timeout option.
action: Run the cdr list replicate command
to check the replicate status. If all participants are active, try
running the command again.
If the server
was being enabled, run the cdr list server command
to check the server status. If all participants are active, try running
the command again with an increased timeout value.
Check out the rest of the cdr return code explanations:
In IBM© Informix© 12.10.xC4, we added the ability to run text searches on JSON documents that are stored in Informix databases. You have three different ways of indexing and searching JSON documents:
MongoDB API command: Run the ensureIndex command and specify text as the type of index, and then query with the MongoDB $text query operator. This method is appropriate if you don't want to change your existing MongoDB application, but provides limited options for indexing and querying.
Informix extension to the MongoDB API: Run the createTextIndex command through the MongoDB API and then query with the Informix $ifxtext query operator. The createTextIndex command takes the same parameters as creating a basic text search index through SQL statements. This method is appropriate if you want to use MongoDB commands and also take advantage of the flexibility and power of Informix basic text search indexing and querying.
Informix SQL statement: Create a basic text search index with JSON index parameters through SQL statements and query with the bts_contains() search predicate. This method is appropriate if you want to query JSON documents through SQL.
When you create a basic text search index on JSON documents, you can control the following aspects of the index:
Whether to index the documents as field name-value pairs so that you can search for text by field. Enable the all_json_names index parameter to index all field names. Set the json_names index parameters to index specific field names. You have the following choices to further refine how field name-value pairs are indexed:
Whether to include JSON or BSON object paths in field name-value pairs so that you can search based on the field hierarchy in the document. Enable the json_path_processing index parameter to index paths.
Whether to index the position of values in arrays so that you can search specific positions in arrays. Enable the json_array_processing index parameter to index the position of arrays.
Whether to index as both field name-value pairs and unstructured text so that you have the flexibility to search a specific field or all fields. Enable the include_contents index parameter to include an unstructured index of field names and values.
Whether an unstructured index contains only values and no field names so that you do not receive field names in search results. Enable the only_json_values index parameter to limit the unstructured index to values.
Whether to ignore format errors for JSON or BSON documents. Enable the ignore_json_format_errors index parameter to ignore incorrectly formatted documents.
For more information, see:
The createTextIndex command
JSON index parameters
We've updated the SQL administration API quick reference card
with 11.70.xC4 content. This is the same version that was available in hard copy at IIUG.