|End of Support Dates|
Highlights: 2014 IIUG Informix conference in Miami April 27 thru May 1
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.
As you probably know I am at the 2014 IIUG Informix conference. It was a pleasure meeting so many old friends and a special pleasure meeting Gibi whom I haven't seen in quite a while.
Gibi was cheerful as usual. "Did you see the Oracle definition in TL;DR Wikipedia?" he asks. "No." I replied, so he handed it to me. I later looked at TL;DR Wikipedia and couldn't find it. It may have been removed but I heavily suspect Gibi just made it up. In any case I liked it so I'm sharing it with you.
TL;DR Wiki is hilarious. If you are not familiar with it take a look at:
When I write this editorial I usually have in mind my many friends at the IIUG. This time I would also like to address IIUG members who are not only new to Informix but new to the computer business.
What Do We REALLY Mean?! — The Newbie Guide to Tech Lingo
So you just started working in a tech company. Congratulations. Even though it's your first day, you probably already noticed that there are many of phrases and terms, which you don't really truly understand. Well, this guide is meant to provide you with all the tools you need to properly understand what we REALLY mean when we're saying something. Enjoy!
2014 IIUG Informix conference in Miami April 27 thru May 1
I am writing this Insider from the IIUG Informix conference in Miami. What a marvelous event. Great sessions, great atmosphere and a great location. It is wonderful to meet so many friends and colleagues. For all of you who missed it make sure you come next year.
Today is the first day and I'v already attended many interesting sessions. I'm sure there are many good sessions I missed but that's how it is. There is one session I would like to mention - the session by Sheng Huang from the IBM research lab in China. It was a great session but the reason I'm mentioning it is to share with you my enthusiasm for the fact that Informix is the database of choice for IBM research and that their cutting edge technology is in becoming part of Informix. The great things that are already in and the great things that will be soon make me more optimistic than ever about the future of Informix.
See you at the 2015 IIUG Informix conference!
IIUG 2014 Miami, Florida!
The Conference Planning Committee would like to thank IBM, our sponsors and speakers and especially our attendees for coming to Miami for this event. This event remains the largest gathering of Informix technical and user experts in the world. A huge thanks to the JW Marriott for allowing us to use their beautiful hotel for this event.
It was great to see so many familiar faces and a lot of new faces this year.
There are over 90 technical sessions over 3 days and many sessions were well attended. Sadly the Conference concludes tomorrow after a full day of tutorials.
We also want to thank those of you who completed your conference surveys. Believe it or not we do read these and take into consideration those comments that help us make the conference better each year. After all this conference is for you!
We will begin planning for next year's conference within a few weeks. Once we have a destination selected and confirm our dates we send out the announcement so you can begin your planning. We will follow that up with a call for speaker request. So, it is never too early to think about a presentation for next year.
For those of you who could not attend this year we missed you and hope to see you at next year's event so keep looking for our announcement.
Rhonda Hackenburg and the Entire Conference Planning CommitteeIBM Information on Demand is now Insight 2014!
The name of the conference has changed for a reason: It.s no longer just about information; it.s what you can do with the information. Insight is the ideal forum to share your experiences and best practices in Big Data & Analytics with more than 13,000 of your peers. Areas of interest will include Information Management, Business Analytics and Enterprise Content Management, plus dozens of business and industry tracks and roadmaps.
Submit your proposal today to speak at Insight and take a larger role in this world-class event. All accepted speakers may be eligible to receive a free conference pass.
Submit your proposal by May 22, 2014.
Gazzang Data Security Solutions Certified on IBM Informix
BusinessWire - April 16
Youtube - April 24
Youtube - April 30
Webcast: Informix: Intelligent Database for Internet of Things
Date: June 5th, 2014
Speaker: Kevin Brown
Abstract: Internet of Things: what it is, the marketplace drivers, consumer and business needs and how Informix solutions address those needs with our unique capabilities (embedded/connected devices, cloud, hybrid database).
IBM Internet-of-Things / NoSQL & 2014 Spring / Summer Informix Roadshows
Coming to a location near you
A series of free two day technical events designed to give you insight into the proven IBM. technology that solves some of the toughest business problems in the world today. For the first time, this roadshow series incorporates two different types of events.
The first event:
For all IBM customers and is oriented to solving the massive change that is occurring in computing environments around the world. Specifically, unstructured data is flooding into organizations and companies are struggling to choose between a relational or NoSQL database to handle it. While NoSQL offers the ability to have dynamic elasticity with data and its organization, these databases lack essential elements common to enterprise class databases such as scalability, security, flexible deployment, transaction support and full data integration. Today, IBM offers a solution that can natively handle NoSQL and structured data simultaneously providing a single system with the seamless integration of all data within the enterprise.
This day is designed to help you understand how application developers can use native JSON and BSON data types as well as other NoSQL functions (including sharding) for complete plug-and-play compatibility with MongoDB and other NoSQL databases. But that.s not all. With IBM's solution, application developers can access structured and unstructured data in a single statement and join them together as needed. NoSQL applications can use the enterprise-level capabilities of a structured database system including transaction support, backup and recovery, H/A, compression, enhanced scalability, security and access control. IBM's solution enables the execution of comprehensive analytics using Cognos or other BI tools on NoSQL data in IBM's market-leading in-memory data warehouse acceleration technology, commonly referred to as BLU. Best of all, this solution has a flexible deployment model including public or private cloud environments or hosted within the company's data center.
It's been said that you can't have your cake and eat it too. That's not true any more. You can have all the advantages of development and deployment in a NoSQL environment with the enterprise-class database technologies to store and analyze all data types with extreme performance, scalability, availability and flexibility while securely protecting the data in devices or in clouds.
A partial list of topics includes:
The second day:
Oriented specifically for Informix customers, this day is for those interested in learning about the full spectrum of Informix.s storage management and efficiency technologies. You'll gain hands-on experience with dynamic and manual expansion of storage spaces. You'll compress, repack and shrink data and indexes to see how these functions contribute to faster SQL performance. You'll learn about proper space planning and sizing for maximum efficiency, database backup deduplication, and much, much more.
A partial list of topics includes:
Each day will begin at 9:00 A.M. Breakfast and lunch will be provided each day.
Register now for the event closest to you by clicking below:
We look forward to seeing you there!!!
Tune logical and physical log automatically
Starting with version 12.10.xC3 Informix can automatically tune the logical and physical log as needed.
You can set the AUTO_LLOG configuration parameter to enable Informix to dynamically add logical logs when lack of logical logs causes frequent checkpoints, blocking checkpoints, long checkpoints etc. In addition, with AUTO_LLOG configuration parameter you can specify a dbspace in which to create new logical log files and the size of all logical log files at which the server stops adding logs for performance.
You are most probably thinking what about the the DYNAMIC_LOGS configuration parameters that exists since Informix version 10. The AUTO_LLOG and the DYNAMIC_LOGS configuration parameters works in different situations and do not interact with each other. When the AUTO_LLOG configuration parameter is enabled, logical logs are added to improve checkpoint performance. When the DYNAMIC_LOGS configuration parameter is enabled, logical logs are added under more urgent conditions, such as when a long transaction threatens to block the server. For example, the maximum size that is specified in the AUTO_LLOG configuration parameter does not affect the amount of log space that can be added by the DYNAMIC_LOGS configuration parameter. Similarly, the value of AUTO_LLOG configuration parameter does not affect the amount of log space that you can add manually.
Now, Informix also allows to expand the size of the physical log as needed to improve performance by creating an extendable chunk for the physical log. An extendable chunks can be automatically extend when additional storage space is required.
Typically, physical log get created in the root dbspace, unless you create an Informix instance during installation. However, for optimal performance it is better to create a separate dedicated dbspace for physical log on a different disk from the root dbspace and move the physical log out of root dbspace. In case, an instance created during installation the physical log create in a separate dbspace called plogspace with a default size that depends on the value of the AUTO_TUNE_SERVER_SIZE configuration parameter.
By default, the chunk that you assign to the plogspace is extendable, therefore, the initial size of the chunk can be small. The database server automatically expands the chunk when the physical log requires more space.
- Sanjit Chakraborty
IBM Informix home page Informix blogs and wikis
Blogs and Wikis that have been updated during the last month
More Blogs and Wikis
Forums, groups, videos, and magazines
There is now an Informix group on LinkedIn. The group is called "Informix Supporter", so anyone loving Informix can join, from current IBM employees, former Informix employees, to users. It will also be a good occasion to get in touch with others or long-time-no-seen friends. If you fancy showing the Informix logo on your profile, join.
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 email@example.com.