Highlights: Informix Dynamic Server 11.70.xC4 Early Validation Program Announcement 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. Contents:
I wonder sometimes if in the era of social networks and blogs there is still a place for an old fashioned newsletter. I am advertising many blogs in the Insider. I visit them all. By the number of visits and comments not many of you do the same. Please do. There is a great deal of interesting stuff in them. On one hand I would like to see more blogs, on the other hand it becomes harder to follow. Without a good search capability many great technical articles posted in blogs are not available to you when you actually need them. I am sorry to say the same about the Insider. We have been promised a Web 2.0 site with search capabilities. I have lost my patience and am planning to post all technical articles from the past few years and put them on our site with an Index that will let you find things easily. Will presence in social networks and blogs help marketing Informix? I have no idea. The beauty of it is you can never tell. In Israel a post on Facebook started a movement that is shaking the country. I joined tonight a 15,000 people march in Jerusalem which was one of several marches across the country. It is encouraging to see young people getting out of the cyberspace and into the real world and making a difference. I doubt many of you are interested in Israeli internal affairs. But I wrote about it just to say that we have the power to change things, so keep up your good work and let's all hope it change things eventually. Gary Ben-Israel
Informix Dynamic Server 11.70.xC4 Early Validation Program Announcement We are pleased to announce the Informix Dynamic Server 11.70.xC4 managed Early Validation Program (EVP), which is now open for customers to submit nominations - the nomination process is described below. This will be a closed EVP test with a limited number of participants. Participants will be expected to actively engage in testing and provide timely feedback on the EVP releases. You might also have the opportunity to participate in early product usability studies. Program objectives The objectives of this Informix Dynamic Server 11.70.xC4 EVP are:
Key Features Nominations for the Informix Dynamic Server 11.70.xC4 EVP program, are welcome from both existing and new customers, particularly those who have an interest in testing solutions for matters such as the following:
Program Schedule These are planned dates, however please note that they are subject to change, as planning progresses. (Dates subject to change)
Support The following support will be provided during the beta program:
Participant Selection Criteria
Nomination Process To nominate yourself for the Informix Dynamic Server 11.70.xC4 managed Early Validation Program (EVP), please send email to Anita McKeithen expressing your interest in participating in this program. The manager for this program is: Anita McKeithen If you have any queries concerning this beta program and the nomination process, please contact any of the above.
IIUG Members save $100 on Information On Demand Global Conference 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 and being a privileged member of the IIUG, you can get a discount of $100 by using the Discount Code G11IIUG, which has been exclusively created for the IIUG members. In addition, take advantage of the Early Bird Registration discount of $300. That's a total savings of $400if you register before August 31, 2011. Don't miss out - Register today! http://www.ibm.com/software/data/2011-conference
FASTEST Informix DBA Training from Lester Knutsen and Art Kagel Advanced DataTools As IT professionals, we are constantly asking ourselves how can we do our jobs better? How can we improve the database systems for which we are responsible? Do you wonder how taking advantage of Informix's Timeseries, Geospacial, and custom designed data types might help your projects soar but don't know how to get started? Have you wondered how to leverage your existing 4GL source code into modern graphical, web based, and mobile applications? Can the Informix Flexible Grid feature improve the security, safety, and performance of your databases? Is there any way to reduce our storage costs? How can we leverage our existing databases and perform complex Decision Support queries without affecting our production applications and without the complexity of setting up and maintaining a separate Data Warehouse? Advanced Datatools has to expertise to help you evaluate all of the new features in Informix version 11.70 and to make best use of the features and facilities you have available to you. Call us to arrange a free consultation conference with one of our experts. We have the experience to recognize opportunities for improvement that you may have been passing up. For information and to register visit http://www.advancedatatools.com or call (703) 256-0267 Ext.101 FASTEST Informix DBA Training 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. Do you want to learn how to be the FASTEST Informix DBA? This is the course our Fastest Informix DBA contest was developed from, and 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. For information and to register visit http://www.advancedatatools.com/Training/InformixTraining.html or call (703) 256-0267 Ext.101
Informix Chat with the Lab
In the 11.70 release, Informix has introduced the ability to install and run as a "Private Server", i.e. without access to user root or user informix. Since running as an unprivileged user makes OS authentication of users impossible, IDS has also introduced the concept of "Mapped Users". This allows creation of users that are not necessarily known to the OS. Note that "Mapped Users" is not restricted to "Private Server". Watch for the announcement of this upcoming Chat with the Lab at the new Informix Chat with the Lab home page on DeveloperWorks: https://www.ibm.com/developerworks/wikis/display/ifmxchatwithlab/Home New in DeveloperWorksWhat's new in Informix MACH 11 high-availability features for secondary servers
Recommended practices for using Cognos with Informix, Part 2: Deploy Informix with IBM Cognos BI Server 10
Evaluate: IBM Informix Growth Edition
Evaluate: Informix Express Edition
For more information go to DeveloperWorks - Informix: http://www.iiug.org/url/devworks.html Database Master 4 for Informix DatabaseDatabase Master is a modern, powerful and easy to use IBM Informix client application, with a consistent interface that simplifies managing, querying, editing, visualizing, designing and reporting database systems. Using Database Master, you can execute SQL, LINQ, JSON queries. You can create, edit and delete all database objects such as tables, views, procedures, columns, indexes, collections and triggers. Database Master provides powerful and intuitive SQL, LINQ and JSON query editor. It supports code highlighting, Intelli Sense and text find/replace features. You can export data into most popular file formats like XML, HTML, CSV, MS Excel, MS Word, MS PowerPoint Open Office Calc and Writer, RTF, PDF, XPS, JSON and dBASE. You can also export whole database data and structure (Table, View, and Procedure) as a SQL Script. Database Master also supports MongoDB, DB2, SQLServer, Oracle, Ingres, PostgreSQL, MySQL, FireBird, SQLite, ODBC and OleDb connectios. For more info: http://www.nucleonsoftware.com
Article Managing Time Series Data with Informix Case study Coldset Printing Partners
Reserve memory for prevent out of memory situation MOut of memory is an undesired state of any database operation where no additional memory can be allocated for use by database. Historically, the out of memory condition is more common in embedded environment, where database server configured to run in low memory configuration. The out of memory situation may lead to database server hung or abnormal outage. Informix introduced a new mechanism to efficiently handle the out of memory situation. It provides more control over the database configuration in low memory condition. Now you can reserve a specific amount of memory to allows Informix to continue with critical database activities even in out of memory situation. Examples of some critical activities are event logging, rollback operation etc. Use the LOW_MEMORY_RESERVE configuration parameter to reserve a specific amount of memory in kilobytes for use when critical activities are needed and the server has limited free memory. For example:
You can also dynamically adjust the value of the LOW_MEMORY_RESERVE configuration parameter with the onmode -wm or -wf command. No matter how the LOW_MEMORY_RESERVE configuration parameter is set, the maximum size of reserved memory is 20 percent of the value of the SHMVIRTSIZE configuration parameter. By default, the LOW_MEMORY_RESERVE is set to 0, which means disabled. If the value is less than 128, the following messages are displayed:
Look for the last two lines in the onstat -g seg command to monitor the LOW_MEMORY_RESERVE value. The first of these lines shows the size of reserved memory in bytes. The second of these lines shows the number times that the server has used this memory and the maximum memory needed.
The online.log also displays appropriate messages each time low memory reserve change. For example:
The low memory reserve is one of the many features that introduced in Informix version 11.70.xC3. - Sanjit Chakraborty
Informix Bootcamp Informix Warehouse Bootcamp
For more details and registration: Informix Performance Tuning Bootcamp
For more details and registration: Informix 11.7 Bootcamp
For more details and registration:
For more details and registration:
Informix blogs and things
http://www.iiug.org/quicklinks.html
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 gary@iiug.org. |