Appropriate Content: Informix Documentation Team
IngeHalilovic 060000MPB8 Tags:  text bts zseries pseries json text_search search informix 6,297 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.
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
Check out this teaser video for the NoSQL meetup at the IIUG next week!
jasna 110000T2XC Tags:  informix_4gl informix openadmin_tool demos informix_warehouse_accele... videos 6,189 Views
Consider subscribing to the following Informix channels on YouTube to learn more about our technology and how you can benefit from it.
Can't remember which onstat command shows you the information about the server that you are looking for? Try the onstat portal.
The onstat portal organizes onstat commands by functional area, with links to the individual topics for each command.
The onstat portal topic is in the
IngeHalilovic 060000MPB8 Tags:  database area perimeter latitude esri coordinates measure informix distance longitude round-earth spatial geographic 6,124 Views
For version IBM® Informix® 12.10.xC3, we've enhanced our support for spatial data. The most exciting enhancement is support of the round-Earth model. Basically, you can put in two sets of longitude and latitude coordinates and get out a distance or area in meters (or whatever linear unit you want). Here's the official description:
You can now calculate the distance and area for data that is based on the round-Earth model. If your geometries have a spatial reference system that is based on angular units, you can calculate distance and area in meaningful linear units. Specify the appropriate unit of measure to convert angular units to linear units in the ST_Area, ST_Buffer, ST_Distance, ST_Length, and ST_Perimeter functions. You can specify predefined units of measure or define your own units of measure. The SE_Nearest function calculates distance between geometries that are in geographic coordinate systems by applying the linear unit of measure of meters.
Also, we've included the following enhancements:
See the Spatial Data User's Guide for details.
IngeHalilovic 060000MPB8 Tags:  informix database environment onstat onconfig administration configuration monitor 6,098 Views
Quick Reference Cards are meant to be printed in color to provide a handy reference (and enhance the decor of your office).
We've updated the following Quick Reference Cards with IBM® Informix® 12.10.xC4 content:
In a little under two weeks, I’ll head down the coast for San Diego and IIUG. I’m seriously looking forward to meeting Informix customers and developers from around the world, and running sessions in the Informix Usability Sandbox.
The sessions we have lined up are going to be good ones, and I can’t wait to sit down with other IIUG members and hear what they have to say about the new 12.10 release, and where they would like to see Informix go in the future.
Sessions will include:
Usability testing of the new Mobile OAT application, fresh off of the 12.10 release. Users can try Mobile OAT out and tell us what they think, and show us how we might make improvements in the future. We’ll also be discussing the latest changes to OAT, and what might be done for any future development.
Discussions on Informix-related media. When does the Info Center work for users, and when does it not work? How about videos? How about these blog posts? We want to figure out the best ways to connect users to the information they want and need.
Informix and mobile. The singularity might or might not be coming soon, but either way, Informix is going places. We want to figure out where untethered Informix might end up. It’s going to be an excellent opportunity for Informix users to shape the development conversation.
For those of you attending, I’ll be in (the room) Santa Fe 3, April 22-24th, for scheduled sessions between the hours of 9am and 5pm each day. Otherwise, I’ll be out shaking hands and meeting other IIUG members. Sign up for a session and/or be ready to shake my hand.
IIUG members will be able to sign up for sessions at the
conference IBM Information Table. But anyone can also drop me a line (firstname.lastname@example.org) to set up
some time to talk. Comments or conversations,
all are welcome!
One of the great features of the IBM Knowledge Center is that you can create PDF versions of any documentation you want. First you create a collection of topics that you want to be in the PDF.
To create a PDF from the Knowledge Center:
1. Sign in to the Knowledge Center with your IBM ID. The Sign In button is in the upper right corner of the black title bar.
2. In the navigation pane, click the topic that you want to add to a collection. The subtopics are also added to the collection, but you can edit the collection to remove the topics that you don't want.
3. Choose an option from the Add to collection menu, in the upper right above the topic:
4. If you chose a new collection, enter a name. Otherwise, choose an existing collection name.
5. Click My Collections at the bottom of the navigation pane to see your collections.
6. Select the collection in the navigation pane and click Create PDF File. Note: Only the first 1000 topics are included in the PDF.
The PDF is created. You have about an hour to download it before it disappears.
IngeHalilovic 060000MPB8 Tags:  assertion_failure database error server informix corruption 6,009 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.
Joel_SF 110000ECNB Tags:  informix json nosql internet-of-things ids12 informix-roadshow 12 5,957 Views
Gartner recently released its 2014 Hype Cycle report, showing the Internet of Things (IoT) at the peak of the Hype Cycle. The Hype Cycle report tracks emerging technologies from infancy to widespread adoption. With IoT at peak hype, companies must be ready to hit the ground running with this technology.
A huge amount of data is already being generated by IoT devices, and much of this data is unstructured. IBM Informix can natively handle NoSQL and structured data simultaneously, providing the enterprise-level capabilities of an structured database system. The capabilities offered by IBM Informix include transaction support, backup and recovery, high availability, compression, enhanced scalability, security, and access control.
To learn more about IBM Informix, JSON/NoSQL, and the Internet of Things, you can:
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.
If you like to keep your bookmarks and links up to date, the following information centers have new URLs:
IngeHalilovic 060000MPB8 Tags:  tasks administration scheduler informix server database automatic oat 5,901 Views
One of the great things about IBM® Informix® is how many tasks are done automatically. Many of the automatic tasks are done by the Scheduler.
Here's the documented definition of the Scheduler:
The Scheduler is a set of tasks that execute SQL statements at predefined times or as determined internally by the server. The SQL statements can either collect information or monitor and adjust the server.
The Scheduler has been around in Informix for quite a while, but Informix development adds new tasks fairly frequently. And, of course, you can add your own tasks. Check out the blog posting from the IDS Experts on how to create your own Scheduler tasks.
To view all the Scheduler tasks, either query the ph_tasks table or look at them in the OpenAdmin Tool for Informix (OAT), on the Task Scheduler > Scheduler page.
Don't forget that you can customize existing tasks, even built-in ones. For example, you can change the threshold or when the task runs. See the The Scheduler topics in the information center for all your options.