Friday, March 4, 2011
Informix - How to Install - Step by Step Guide
Installing Informix Server
Download the Installer File
1. Download the informix server developer edition from http://www.ibm.com/developerworks/downloads/im/ids/dev.html
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:
Subscribe to:
Post Comments
(
Atom
)
1 comment :
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
Post a Comment