Embedding IBM Informix
An IBM Redbooks publication
Published 17 February 2011
ISBN-10: 0738435155
ISBN-13: 9780738435152
IBM Form #: SG24-7666-01
(502 pages)
View online
Authors: Whei-Jen Chen, Oluwatosin Ajayi, Mirav Kapadia, Alexander Koerner, Jacques Roy, Dick Snoke
Abstract
In this IBM® Redbooks® publication, we discuss and describe the capabilities for embedding Informix® into applications and software. We introduce the technological architecture and describe several of the functions and features that support Informix as a robust and powerful embeddable DBMS. Many of these features are unique in the industry today, enabling clients to create a business advantage.
The Informix database server can support the requirements of an embeddable DBMS, and is doing so for many companies today. The low administration requirements of the Informix database server enable clients to deploy thousands of Informix instances, embedded in applications in locations where there are no technical resources to support the database. The real requirement is for applications with embedded databases that require little or no administration, take minimum storage resources, have excellent performance, and are highly reliable.
As a mature and reliable DBMS, the Informix database server works well with small, growing, and large databases, and meets the key requirements for embedded databases, which include the ability to execute without needing any configuration or other DBA administrative activities, and the flexibility to work on all of the platforms commonly used in the marketplace today.
Table of contents
Chapter 1. Introduction
Chapter 2. Embeddability basics
Chapter 3. Preparing to embed IBM Informix
Chapter 4. Installation strategies
Chapter 5. Deployment
Chapter 6. IBM Informix configuration for embeddability
Chapter 7. The SQL administration API
Chapter 8. Memory and storage management
Chapter 9. Automating management through tasks and sensors
Chapter 10. Administration of an embedded IBM Informix system
Chapter 11. Embedding high availability IBM Informix configurations
Chapter 12. IBM Informix appliances
Appendix A. SQL administration commands and scripts
Appendix B. IBM Informix Version 11.50 installation and configuring client connectivity
Appendix C. Event classes and event IDs