Informix Database




Informix is the traditional, object-relational database management system of IBM. Still it has its own footprint with dedicated customers and provides compact solutions. Let us get into the tutorial.

To understand the versioning,

Example Informix – Version: iif.12.10.FC7TL.linux-x86_64
12 – major, 10 – enhancement release, F – Architecture(64bit) , C7 – sub release number,  TL- fixpack number.

Architecture





A server has multiple instances, which has own set of resources, databases.
DBSpace – Set of one or more chunks that store data.can have multiple DBSpace.
Chunk – a file/device(Can be raw devices) pre-allocated(Size should be allocated while creating) for space that makes up a DBSpace. Can add more chunks to DBSpace to extend.
Bufferpool – memory hold retrieved data for faster processing.





Commands in Informix

Oninit – Central server core engine.
Onmode – manages the running engine.
Onstat – gives statistics & information about the current instance
Ontape – backup utility for restore/backup
Onspaces – create/deletes chunks
Onparams – manages logical & physical logs


Installation Steps

Create a separate user and directory for the fresh installation,



Download and untar the binary,


Run as root user and follow the command line prompt, below screenshots might help you to drive through,








Thus, Installation is complete. Please follow the next post for setting up the connectivity and database operations


Recent Posts

  • Cloud SQL
    What is Cloud SQL  It is a fully managed relational database service for PostgreSQL and MySQL database in the GCP. MySQL instance can be...
    May 17 2020 | Read more
  • Deploy an application to Google Kubernetes Engine
    Welcome back, this is the continuation post of the previous article, where we have discussed the Kubernetes and its concepts in detail. In this...
    May 13 2020 | Read more
  • Google Kubernetes Engine
    What is GKE? GKE is a managed, production-ready environment for deploying containerized applications. It is like a managed cargo container in...
    May 13 2020 | Read more
  • Google App Engine – Flexible
    In the previous article, we have discussed what is google app engine and how to deploy the application in the Google app engine – Standard. In...
    May 10 2020 | Read more