An Entrepreneur, Coach, IT Consultant, Strategic Adviser, and a Traveler craving to explore and contribute to forming a better society.

Friday, March 4, 2011

Informix - How to Install - Step by Step Guide

1 comment :
Installing Informix Server

Download the Installer File

1. Download the informix server developer edition from

            a) You may have to create a new IBM id (if you don't have already) to download this installer.

2) Extract the downloaded zip file

Windows User Account

3) Create a windows user

            a) Right click "My Computer" -> Manager -> Local Users & Groups
            b) Create a new user called "informix" with password
            c) Ensure that the "password never expires" option is checked

3) Execute the "ids_install.exe" file to start informix server installation

Typical Installation

4) Click "Next" until you get the "Setup Type" screen, wherein please choose "Typical" installation

Informix User Password

5) The setup will ask for informix user password. Enter the same "password" as you'd provided in the step 3 (creating windows user)

6) The setup should now install the server, client sdk and other required softwares in your system. Complete the installation.

Thus Installation Completed


Post Installation Configuration

1) After the installation you should have two new menus in Start -> Programs

            a) IBM Informix 11.70
            b) IBM Informix Client SDK

2) Go to Start -> Programs -> IBM Informix 11.70 -> "Server Instance Manager"

            a) You should now see any existing server instances
            b) If not, create a new one with default values
            c) Note all the default values and click “continue”.

            Informix Server         
                        - Database server located on the host machine
            HostName [default: your-machine-name]  
                        - Name of the host machine with the Informix database server
            Protocolname [default: turbo]          
                        - Protocol determined by the configuration on the host machine
            Service Name          
                        - Service determined by the host configuration to communicate to the designated database instance

Select “Create New”

Note: Server number should be unique for every instance

Note: Server name should be unique for every instance

Note: Service name, port number should be unique for every instance

Provide the password of the Informix user created in windows

-         Continue with the default values

Select “Yes”

A new menu item called "server-name" in Start -> Programs -> IBM Informix 11.70 should have been created by now.


Access Informix Database

Now you are all set to access informix database.

1) Go to Start -> Programs -> IBM Informix 11.70

2) Select any of the server instances [Example: ol_chn2422]

3) Type “dbaccess” and press enter

4) You should now be able execute sql queries using “Query-language”

Note: dbaccess is a command line tool, can be used to execute queries, create databases, create tables, insert rows, alter tables etc.,

For more information:

1 comment :

nasreen basu said...

too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 7 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, informatica mdm training in hyderabad