Let us know if you like it!
Appropriate Content: Informix Documentation Team
Happy new year!
The Informix documentation team has already fulfilled one of our new year's resolutions: to make it easier to find the latest version of the 11.70 product manuals in PDF format. Check out this document, which links to the most recently published version of each of the 11.70 manuals, including translated versions of the manuals.
Let us know if you like it!
During my commute to work today, I heard on the radio that October 30 is Checklist Day. So I decided to do my part by reminding you about the Pre-migration checklist for diagnostic information. Use this checklist before you migrate to Informix® 12.1 to gather diagnostic information that you can use to verify database server behavior after migration. This checklist is useful especially if you have large, complex applications.
Have you made or found a checklist that helps you to take care of things in your Informix environment, or to avoid problems? If so, we'd love to hear about it. Also, let us know if you would like a checklist to help you as you work with Informix. Send your thoughts to email@example.com, or add a comment below.
As for me, I can check off one item from my to-do list:
IngeHalilovic 060000MPB8 Tags:  tasks administration scheduler informix server database automatic oat 1,623 Visits
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.
IngeHalilovic 060000MPB8 Tags:  storage compression timeseries management hertz database informix 1,620 Visits
IBM® Informix® version 12.10.xC3 has a couple of new options for efficiently storing time series data:
If your time series data is recorded at a regular subsecond frequency, you can define a hertz time series to store the data efficiently, up to 255 data points per second. The way the hertz data is stored can save about 10 bytes per record.
If your time series data is recorded at a regular frequency and all the time series values are numeric, you can define a compressed time series to store the data efficiently. You can choose the type of compression and the margin of error. The compression ratio of the rest of the time series data varies depending on the type of data and the compression definitions. For example, you can compress an 8-byte BIGINT value down to 1 byte, with some loss of precision.
See Packed data for more information.
IBM Informix Survey for Continuous Availability White Paper
Complete the Survey to win an Apple iPad! - 1 week left
Every response matters. - Start Survey here!
IBMR Informix is the database software voted #1 in customer satisfaction.
Clients choose Informix because it is reliable, low cost, and hassle free.
Solution providers choose Informix for its best-of-breed embeddability.
Yet, there are some people that still don't 'get' Informix, or realize the
many benefits of deploying it. Help us gather data to support this claim.
- Informix is exceptionally hardware efficient, which means that (in the
REAL world) you need to spend MUCH less on hardware to get the same
performance as other products.
- Informix is exceptionally reliable, which means that (in the REAL world)
you don't need to pay lots of people to make sure it stays 'up'.
- Informix is exceptionally scalable, which means that (in the REAL world)
it can be idling one moment and then processing thousands of transactions
the next with no apparent stress.
Advanced DataTools is working with Oninit, to gather data about what happens
in the REAL world to support these assertions with empirical evidence in the
The data collected will be used to compile a report that will be made
available to every CTO, IT Director and IT Manager. Along with this, they
will receive a list of all the major application vendors that are now
porting their applications to Informix V11.5 and a document outlining the
key reasons to choose Informix.
Every response matters. - Start Survey here!
Win an Apple iPad. One randomly selected participant in the data collection
phase of this research will win an Apple iPad, provided by Advanced
DataTools Corporation, an Advanced IBM Informix Business Partner.
Note: Public Sector Employees are not eligible
IngeHalilovic 060000MPB8 Tags:  performance warehouse search database oat install informix 1,609 Visits
The Informix® 11.70 information center has been updated with 11.70.xC2 information!
The new features in IBM® Informix 11.70.xC2 are:
Read the What's new in Informix topic in the information center for a short description of each new feature and links to where they are documented in detail.
The IBM® Informix® Virtual Appliance is a pre-configured virtual desktop environment that is managed using tools from VMware. It contains Informix Developer Edition and is available for free on the IBM Virtual Appliance web site: http://www.ibm.com/developerworks/wikis/display/im/IBM+Virtual+Appliances
The Informix Virtual Appliance provides several tutorials that you can do within the appliance:
Basic text searching
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.
Today I learned about a Google search option that helps me view websites on my smartphone. Next to a search result I just click Options -> Mobile formatted (IMAGE 1). Simple, eh? The page loads rather quickly and is optimized for viewing on my teeny, tiny screen.
I can see this option being useful for viewing the IBM® Informix® information portals, such as the onconfig portal (IMAGE 2) that we've heard customers like. You can search for "onconfig portal 11.70" or you can start at the Informix information center (IMAGE 3) and select the portal that you want to use. If you try this option with our documentation let me know what you think by posting a comment to our blog. Now you can take Informix documentation "to go".
Even though the IBM Knowledge Center contains the technical product documentation for thousands of IBM products, you can easily and quickly get information about only the products and topics that you are interested in.
To reduce the number of results returned about a particular subject area, you can refine your search by using the intitle operator. The intitle operator restricts results to words or phrases that appear only in the title of a topic. Use this operator when you are looking for the main topics about a subject area. For example, compare the following two searches for Informix 12.1:
1. basic text search error
2. basic text search intitle:error
You can also search for a phrase in the title. For example:
IngeHalilovic 060000MPB8 Tags:  spatiotemporal backup informix timeseries oat mongodb rest bson upgrade nosql java json installation jdbc 1,517 Visits
Here is the list of new features for IBM® Informix® 12.10.xC5!
What's new in IBM Informix version 12.10.xC5
Go to What's new in Informix for links.
IngeHalilovic 060000MPB8 Tags:  thesaurus database index informix analyzer stopword search text 1,493 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)
IngeHalilovic 060000MPB8 Tags:  openadmin_tool administration installation oat database informix 1,491 Visits
Before IBM® Informix® 11.70.xC4, you had to download and install the IBM OpenAdmin Tool (OAT) for Informix separately from the Informix product. Now, when you install IBM Informix Client Software Development Kit, or when you install the IBM Informix software bundle and select Client SDK or IBM Informix Connect, you can install OAT. This option is available on Windows 32-bit, Linux 32-bit and 64-bit, and MAC OS 64-bit operating systems.
Note that OAT is not installed with Client SDK by default--you have to choose to include OAT.
Here's more information from the IBM Informix Client Products Installation Guide.
Informix was recently ranked as number 10 in the top 20 in-demand mobile skills by job search site Dice.com. The site listed the top 20 search subjects that hiring managers and recruiters use when they request people with mobile experience (http://www.zdnet.com/top-20-mobile-skills-in-demand-7000023318/). This may be surprising news to some, considering that Informix is known for being a traditional RDBMS. However, with the introduction of Informix JSON support in 12.10.XC2, aimed specifically at mobile development support that leverages the MongoDB API, Informix is stronger than ever!
To learn more the Informix JSON capability, see these resources:
fwelsch 06000203CP Tags:  informix_connect installation installer informix client_sdk 1,431 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!