Getting Started with Informix on Windows - Installing and getting up and running in no time

Submitted by anil.mahadev on Fri, 2010-05-21 11:24


Installing Informix on Windows - A Primer

 By

Anil Mahadev

This short blog post will introduce newbies on installing and setting up Informix on their machines.

This is done with little or no configuration.

Step 1: Getting Informix downloaded to your Machine

1) Visit the following URL to download Informix for Windows 

http://www.ibm.com/developerworks/downloads/im/ids/dev.html

2) Sign in with your IBM ID and download it using Download Director

3) After downloading it, extract the zip file to a temporary directory

4) Upon extraction, Click on the Launch.exe

 

 

 5) Now click on Install products

 6) Once the Installshield Wizard is launched choose the following options as shown in the screen shots below and click on the

appropriate options.

 

 

 

 

 

 

Note: I have already installed , that's the reason, why the screen options are disabled.

For Security purposes: Please create a informix user and assign a *Strong password* for the informix user.

 

 

Note: Before clicking on Next, verify everything is fine and begin the installation. 

 

After the setup completes click on Finish.

 

 

 

 

After the Informix Server setup is completed, launch the Server Manager to validate the same as shown below.

 

Next Ensure that the server was actually created as defined during the installation

Next Reboot your machine.

Now launch the Informix Server Command Prompt from the Start Menu --> Informix Dynamic Server 11.50--> Server Name Cmd Prompt

Once in the Command Prompt, issue the following command to ensure that Informix is running

 onstat -m

You must see a message stating that the server is Online

You now have Informix installed and running on your Windows machine Wink.

 Congratulations!

In my next installment, I shall walk you folks to getting started with .NET Development using Informix.

Until Next Time, Happy Informix DBAing :=)

 

error when issuing command onstat -m

Submitted by huahsin68 on Sat, 2011-12-10 12:53.

I got an error when input the command onstat -m, below is the output:

shared memory not initialized for INFORMIXSERVER 'ol_ids_1150_1'

Message Log File: C:\PROGRA~1\IBM\IBMINF~1\11.50\ol_ids_1150_1.log

Thread(7, main_loop(), 0, 1)

File: rspartn.c Line: 9431

15:08:29 Results: Chunk 1 is being taken OFFLINE.

15:08:29 Action: For all spaces other than temporary dbspaces, restore the space containing the chunk from the archive. If this chunk belongs to a temporary dbspace and if it is not the only chunk in that dbspace, then drop and re-create the chunk. Otherwise drop and re-create the temporary dbspace.

15:08:30 stack trace for pid 2388 written to C:\PROGRA~1\IBM\IBMINF~1\11.50\tmp

\af.3ef056c

15:08:40 See Also: C:\PROGRA~1\IBM\IBMINF~1\11.50\tmp\af.3ef056c

15:08:43 Releasing server from system block

15:08:49 chunk failed sanity check

15:08:51 chunk failed sanity check

15:08:51 I/O error, Primary Chunk 'C:\IFMXDATA\ol_ids_1150_1\rootdbs_dat.000' -

- Offline (sanity)

15:08:51 oninit: Fatal error in shared memory initialization

15:08:51 IBM Informix Dynamic Server Stopped.

 

May I know what is going on to my Informix? Any clue would be appreciated.

.net development using informix

Submitted by ptn77 on Fri, 2011-12-02 00:19.

Hello,

Have you posted your blog on getting started with .NET Development using Informix yet?

Thanks!