|End of Support Dates|
Highlights: Compare the Informix Version 11 editions
Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.
The summer is coming to its end. In Israel it is hot and dry. Hurricanes and tornados are not part of our life. Unfortunately we have enough problems of our own.
My best wishes to all Informix users in the US and to those who are not YET Informix users as well. Informix is beta testing 11.7 xc4 - one more step towards the next major release.
Activity round Informix is growing. Not as much as we would like it too though. The next IBM Data Management Event is the Information On Demand conference. This year it will take place in Las Vegas, as it did last year, and the year before that, and before that. The IIUG board will have its next meeting at the IOD conference. If you are there, look us up. We are always happy to meet our Informix friends.
The IIUG 2012 Informix Conference is moving to California!
The IIUG Board of Directors is pleased to announce that the IIUG 2012 Informix Conference will be held at the San Diego Marriott Mission Valley, April 22 - 25, 2012. This hotel features the same number of guest rooms as the location for the 2011 Conference, but with 40% more meeting space available surrounding a spacious outdoor pool area. Upgraded wireless Internet is available throughout the facility. Although pricing is not available at this time, we expect the pricing to be in the same neighborhood as the 2011 event for both attendees and sponsors.
The IIUG Conference Planning Committee is proud, committed and will continue to provide a quality conference containing cutting edge Informix sessions and showcasing quality Informix vendors. Sunday's kickoff will feature several informative tutorials and the Conference's three-day agenda will feature over 80 technical sessions. Hands-on labs will be offered again in 2012. All sessions will be conducted by leading Informix users as well as IBM Informix experts from around the world.
For more information on the facility, see the hotel website at:
Important dates to watch for include:
For more details continue to watch next month's issue of the IIUG Insider or check out the IIUG official Conference Web Site at http://www.iiug.org/conf.
Compare the Informix Version 11 editions
IBM Informix is a premier database for high volume online transaction processing (OLTP) as well as integrated applications. Informix has built an incredible reputation over time as the database server that "just works!" Informix has kept pace with its customers as they've grown and expanded without costing them a fortune for ongoing maintenance and administration. In most cases, these companies have grown without requiring significant infrastructure upgrades because Informix is so efficient. In turn, customers have responded by rating Informix as #1 in customer satisfaction for several years.
Customers choose Informix because of its reliability, flexibility, ease-of-use, and total cost of ownership. In simple terms, this means Informix works without a problem or major administrative issues regardless of the operating system Informix is running on, so you can manage your application needs as your business dictates. Informix is available across a broad range platforms and operating systems including AIX, HP-UX, Sun Solaris, Macintosh OS X, Linux, System i, System p, System x, System z, and Windows.Not all customers need the same database features and functionality though. In some cases, this is a technological decision; for example, a customer may not be using Enterprise Replication or some of the advanced backup and recovery features. In other cases, licensing requirements and the expenses involved drive these decisions. From a product licensing perspective, Informix is well attuned to both cases.
Informix has recently made some dramatic and significant changes to the licensing model including "for-purchase" and "free" editions that can be downloaded and used in production. These editions are tailored from a price and functionality perspective to a specific market segment. The Informix purchased editions offer some sub-capacity pricing models, giving you the flexibility to buy just what you need to support your data services requirements without having to worry about the total processing power of the hardware on which Informix is installed. All editions may be deployed in "virtual" environments, giving you additional deployment flexibility. Finally, for the ultimate in flexibility and pricing convenience, you can take advantage of new "pay-as-you-go", ready-to-use cloud computing technologies featuring Informix through vendors such as Amazon Cloud Computing and other providers.
In March 2011, Informix introduced significant new function that dramatically enhanced its ability to serve as a data warehouse or data analysis server. The new Informix Warehouse Accelerator (IWA) technology uses compression and a columnar approach to storing and accessing data in-memory as opposed to the row-based approach used in most database engines. This new in-memory approach enables Informix to provide virtually unlimited data warehouse growth while providing data response times that are hundreds of times faster than conventional systems. Informix Ultimate Warehouse Edition can be used in combination with other advanced Informix technologies, including high-availability clustering, Informix Flexible Grid, spatial analysis, and advanced access control, to build a robust, scalable data store that can resolve the most demanding and difficult business issues.
For the full article got to:
Turn Insight into action at the Information on Demand 2011
Turn Insight into action at the Information on Demand 2011 global conference October 23-27, 2011 at Mandalay Bay, Las Vegas Nevada. Experience proven technologies and meaningful business insights to improve performance while reducing costs. Choose from three technical forums that give you in-depth education including hands-on labs and usability sand boxes, and the thought-provoking forum for Business Leadership.
Registration is now open for IOD 2011:
Advanced DataTools Advanced Informix Training (Online and in-person)
September 26-29, 2011 - Advanced Informix Performance Tuning Course
Learn how to become the FASTEST Informix DBA from Lester Knutsen and Art Kagel!
Do you want to learn how to be the FASTEST Informix DBA? This is the course our Fastest Informix DBA contest was developed from. It will increase your database performance tuning skills.
This 4-day course focuses on techniques for optimizing an Informix Database. Labs will demonstrate more than 100% performance improvement. Each student will have a 4-core Linux server with Informix 11 and a large dataset for benchmark exercises and labs. Attend the class in person or online via our Web Training Center. Both Art Kagel and Lester Knutsen will be teaching the Advanced Classes together. All courses may be taken online from your desk or at our training center in Virginia. To take a class online, all you need is a web browser and a SSH client (like Putty) to connect to the training lab.
This course is for database administrators and application developers who will be responsible for managing, optimizing, and tuning an IDS database server. The focus is on skills, procedures, and scripts to improve the performance of your database server. The course will provide a toolkit of scripts and utilities to start monitoring and optimizing your IDS database server. (Cost $2,000 USD)
For information and to register visit http://www.advancedatatools.com/Training/InformixTraining.html or call (703) 256-0267 Ext.101.
The best database for every purpose!
As a consultant I often am asked "What is the best database for everything we do?" Unfortunately, there is no easy answer for that, and I know this is not the response you all expect from me. Bear with me on this and I will explain.
The best database, and to be clear by 'database' I mean Database Management System, is not MySQL, PostGreSQL, Ingres, Oracle, Sybase, IBM DB2 branded products, IBM's Informix branded products, Voltdb, OpenSQL, Berkeley DB, Progress, Unify, or any of the literally hundreds of other RDBMS products on the market whether they are free or for-cost. No single database product can serve all of the needs of any large organization nor for most smaller organizations. That's a fact! While I think that IBM Informix Dynamic Server Ultimate Edition is the cats meow of RDBMS products - the performance, feature, and innovation leader in my book - it is not best for every purpose in every organization.
So, the question remains out there: "What is the best database for ...", what do I recommend? Because if my clients have to use a different database server product for each group of applications that fit best, or even groupings that are sometimes second best, they are still going to have to maintain and be able to manage and tune several products from several companies won't they? The list of skill sets that their DBAs will need will be very broad and I will have to hire more DBAs than I might need if I could just use one product.
I've been thinking about this for a while, and I keep coming back to the marketing presentation I made to IBM two years ago and to how appropriate that was to this question even more so than to the question of how IBM should market its database products. If my clients could get the "right" database, or close enough, for every situation from a single vendor, and if that vendor could make the skills needed to manage all of those database products they market sufficiently portable, that would reduce my clients' costs of ownership substantially making this single vendor solution even more attractive.
OK, so what product lines are out there? Oracle effectively has MySQL for very small projects and their Enterprise Class Oracle server in its various "editions". Sybase has an Enterprise class server and a mobile server. Ingres has only an Enterprise class server but not much third party software support left. Progress is a good SMB server only. Same with Unify. PostGreSQL has many nice enterprise class features but not all and many organizations won't bet the ranch on an open source product that doesn't have corporate support behind it. That brings us to IBM which, as I pointed out two years ago, has a plethora of database management systems appropriate for any size organization and any task:
So is IBM missing anything? Yes! It is missing a unified structure of management and maintenance tools that can cross and span the entire range of database products so that an organization's DBA skills can also span the product line. Put that in place and two things happen:
I have the answer to my clients' questions and
Instead of producing a white paper entitled "Six reasons to move from Oracle to IBM" which should really have been entitled "Six reasons to move from Oracle to IBM DB2" they can produce a white paper entitled "Sixty reasons to move from Oracle to IBM" that can highlight all of the benefits of using a unified database product line within your organization. This makes IBM a one-stop-shop and makes my life as a consultant a whole lot easier.New in DeveloperWorks
Perform case-insensitive queries in Informix
Integrate the rich Internet application framework ZK with Informix to build real-world applications
Use Informix ODBC Driver with an ODBC Driver Manager
IIUG user view: Happy 10th anniversary to IBM and Informix
Informix DBA: Informix Warehouse Accelerator
Newsbytes: IBM Data Management magazine, Issue 3, 2011
Informix Warehouse Accelerator: Using SmartMart (1)
For more information go to DeveloperWorks - Informix: http://www.iiug.org/url/devworks.html
PreferredPartner, an IBM Premier Business Partner specializing in IBM software solutions and IT services, announced today the general availability of Analytics Accelerator : a new datawarehouse solution that bundles IBM's Informix Ultimate Warehouse Edition and off-the-shelf hardware with targeted technical consulting services http://conta.cc/PPRInfmx.
Oninit and Traak Systems partner to help transform real-time data into actionable insights
Oninit and Traak Systems partner to help transform real-time data into actionable insights : Oninit Consulting, the IBM Informix services company and Traak Systems, which provides predictive analytic solutions, have announced a partnership which will see them jointly develop solutions for the energy, renewable energy and utilities marketplace. Read the complete article here http://bit.ly/PROnInf.
Informix Web Cast in Portuguese by Miguel Carbone
What UPDATE STATISTICS command should you run?
We all know how critical it is to keep accurate and up-to-date database server statistics. Update statistics are key part of getting consistent performance. It is a very common question to ask: What UPDATE STATISTICS command one should run?
The following SQL script offers a way to generate list all necessary UPDATE STATISTICS commands for a database. You just need to replace the "<Database Name>" string with an appropriate database name. It will create an output file call 'update_stat_cmd.sql' in the current directory.
You can run the above SQL script against sysadmin database to generate UPDATE STATISTICS commands according to Informix guideline. It goes by the following guidelines.
The above SQL script has dependencies on syadmin database and database scheduler. SQL script will fail if the database scheduler turned off.
- Sanjit Chakraborty
New BP Exclusive Forum on IIUG
A new exclusively discussion forum hosted by the IIUG has been set up for business partners to use as a mechanism to collaborate with each other. This forum is only visible and accessible to business partners who sign up for it. Membership is open to any IBM Informix business partner (we will verify your business partner status) and you must also be an IIUG member. To sign up for access, please email Ted Wasserman (email@example.com) or Gary Proctor (firstname.lastname@example.org) and provide the main email address in your IIUG member record, or the SIGs email address in your Member record (Under the Membership button). You will be sent a confirmation email when your access has been approved.IBM Smart Metering Data Summit
IBM Invites you to the Smart Metering Data Summit 2011
Thursday, 15 September, 2011 8:00 AM - 3:00 PM
Wednesday, 14 September, 2011 6:00 PM - 9:00 PM
Registration Link: http://bit.ly/IBMSMDSInformix Dynamic Server 11.50 Full High-Availability Clustering
An IBM Proof of Technology
Date: September 14, 2011
In mid-2007, IBM unleashed the fastest cat in the data server world with Informix Dynamic Server 11. The release strengthened and enhanced Informix Dynamic Server's legendary ease of use with a wide range of additions to its autonomic system-management capabilities; a new, flexible, and extensible system-monitoring and administration tool; a new command-line administrative API to further increase system security; bundled DataBlades for increased application capability with reduced complexity; and much, much more.
The crown jewel of this release was the increased capability added to Informix Dynamic Server's High-Availability Data Replication (HDR) technology. With this new functionality, now called Informix Dynamic Server High Availability clustering (Informix Dynamic Server H/A clustering), you can use additional secondary instance types to create an "availability fabric" to safeguard your Informix Dynamic Server data and provide uninterrupted data services through any type of manmade or natural outage. The simplicity of operations and ease of setup for this clustering technology is outstanding and completely unheard of in the data server market today. As those who use IBM Informix like to say about it, "It just works!" Customers around the world are using the technology and are benefiting from the flexibility and enterprise-quality stability that Informix Dynamic Server H/A clustering provides.
IBM Informix Dynamic Server development has continued to enhance and bring new functionality to the Informix Dynamic Server H/A clustering suite of technologies. In this Proof of Technology, you will create and use the latest version of the Informix Dynamic Server H/A clustering technologies to create a cluster of instances that can provide virtually uninterrupted data services to your environment.
In this Proof of Technology, you will create and use the full spectrum of Informix Dynamic Server H/A clustering technologies including updatable secondary instances, the Online Connection Manager and Server Monitor agent, Service Level Agreements, delayed application of transactions for protection against SQL errors, and the Failover Arbitrator to create a cluster of instances that can provide virtually uninterrupted data services within a business environment.
AudienceThis Proof of Technology is specifically targeted for Application and Data Architects, Database and Informix Dynamic Server Administrators as well as Line-of Business owners who are evaluating architectural and data server solutions for their environments. It is also of great value to ISV's, IBM Business Partners and others who are looking for the best data server to integrate into their solution for resale to others. Some prerequisite knowledge of IBM Informix Dynamic Server is very helpful but not required. It is recommended that participants have an understanding of data server technology, data server administration as well as general data programming. The labs will be executed in a Linux environment so a basic fluency in Linux/Unix commands, including the vi editor is helpful.
AgendaThe class includes an educational presentation explaining the Informix Dynamic Server H/A clustering technology in detail. Business and technical use cases are included to provide a real-world reference point on how the technology can be applied in a customer environment. This is followed by an indepth, hands-on experience where the student will apply and use all the concepts taught during the educational portion of the class. By the end of the day, the student will have created and used the full spectrum of Informix Dynamic Server H/A clustering technology to create a cluster of instances that can provide virtually uninterrupted data services within a business environment.
CostThis session is offered free of charge. Complimentary refreshments including continental breakfast and lunch will be provided. However, participants are responsible for their own business travel expenses.
ScheduleFor your convenience, registration and continental breakfast will begin at 8:00 AM. The session will start at 8:30 AM and end at approximately 4:00 PM.
Contact for information
To enroll in this Proof of Technology, please contact: Brian Mealman, 612-397-5468, email@example.comIBM Webcast: Data Management for a New Generation with IBM Informix.
Date: Sep 8, 2011
This session is designed to help you learn about why Informix still is the best solution - from the most mundane of data needs, all the way to your largest of systems. We will show examples where Informix is better than any other technology when you combine all of its capabilities.
Come listen to what your competition is telling your customers about 3rd Generation database in-memory technologies and find out how IBM - Informix can deliver unprecedented query response times in a completely integrated, flexible and cost effective environment.
This webcast is intended for technical and business professionals new to Informix as well as individuals familiar with the platform who are interested in learning how to gain incremental value within your environment.
Featuring live Q&A with: Tom Rieger & Scott Whalen, IBM Informix SWAT Team Leaders.
Please join us to learn more about our latest offers available to both existing and new Informix clients!
Informix blogs and things
The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG's membership database now exceeds 25,000 entries and enjoys the support and commitment of IBM's Data Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.
For comments, please send an email to firstname.lastname@example.org.