I just noticed something quirky about using Firefox while installing IDS Developers Edition from the DVD's handed out at the IOD conference. When I click the install link, Firefox only lets me save/copy the setup.exe file from the DVD to my computer. But if you do that, then the resulting setup.exe file doesn't actually do anything when you run it. It must need some companion files on the DVD. The workaround is pretty simple. Copy the link location for the setup.exe file on the DVD, and run that directly from the DVD. On my machine the link location is file:///D:/IDS/win_de/setup.exe When I clicked Start -> Run... and ran the setup.exe program that way, everything worked fine. I also experimented with Internet Explorer (IE), and saw a choice of Run or Save. The "Run" option worked fine. One other thing. When choosing a password for your Informix account during installation, make sure whatever password you enter meets the security policies for your machine/company. It's one of those simple things that are obvious in hindsight, but easy to forget while you're doing the installation. -Kevin

When trying to create index on a table with 150 million records onstat -g ckp displays:- IBM Informix Dynamic Server Version 11.10.FC1 -- On-Line (CKPT INP) -- Up 01:17:20 -- 272384 Kbytes Blocked:CKPT AUTO_CKPTS=On RTO_SERVER_RESTART=Off Critical Sections Physical Log Logical Log Clock Total Flush Block # Ckpt Wait Long # Dirty Dskflu Total Avg Total Avg Interval Time Trigger LSN Time Time Time Waits Time Time Time Buffers /Sec Pages /Sec Pages /Sec 416 11:33:26 CKPTINTVL 7:0x1359e2cc 0.5 0.4 0.0 1 0.0 0.0 0.0 2741 2741 19 0 20 0 417 11:38:36 CKPTINTVL 7:0x1413d018 6.7 6.6 0.0 0 0.0 0.0 0.0 53316 8024 95 0 2975 9 418 11:43:56 CKPTINTVL 7:0x151e7728 12.1 12.1 0.0 0 0.0 0.0 0.0 80903 6688 121 0 4266 13 419 11:49:01 CKPTINTVL 7:0x151e803c 0.4 0.4 0.0 0 0.0 0.0 0.0 4799 4799 0 0 1 0 420 11:54:16 CKPTINTVL 7:0x167693b0 12.8 12.8 0.0 0 0.0 0.0 0.0 74155 5796 176 0 5505 18 421 11:59:16 CKPTINTVL 7:0x1676b304 0.5 0.5 0.0 0 0.0 0.0 0.0 3791 3791 15 0 2 0 422 12:04:33 CKPTINTVL 7:0x17749204 11.9 11.8 0.0 0 0.0 0.0 0.0 98065 8282 9 0 4062 13 423 12:09:45 CKPTINTVL 7:0x1774a03c 0.4 0.4 0.0 0 0.0 0.0 0.0 5403 5403 0 0 1 0 424 12:14:55 CKPTINTVL 7:0x18d11644 9.9 9.9 0.0 0 0.0 0.0 0.0 80966 8214 4 0 5575 18 425 12:20:00 CKPTINTVL 7:0x18d1203c 1.1 1.1 0.0 0 0.0 0.0 0.0 6901 6345 0 0 1 0 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 200 200 13 6006 131 0 The oninit processes remain running at all but 100% cpu. We have left it running for a few hours but never returns. If we try setting the checkpoint interval to say 1 hour, it manages to create the index within 30 mins. Tried increasing the physical log size up to 500mb, as some articles recommend higher than 1GB, but still fails to create. Database logging is set to none, until we have the data imported. The data is in one db space with the index data in another. Any ideas ? Running on solaris 10, with cooked chunks, fibre raid. Thanks

Thanks to all of the participants and Informix engineers that helped to make this open beta a TOTAL success. As most of you know, this is the first time an open beta program was run for an Informix product - but we will SURELY be doing it again! Among many other statistics I could share with you, the most impressive is that we increased our exposure to customers prior to release more than 6,500% over the previous IDS release (yes, that's right - more than sixty-five thousand percent)!!!! That kind of exposure translates directly into dollars (which translates into MORE features for future IDS releases!)! Please note that the download site will not be available for downloads after July 30. Remember to visit the IDS information site often for the latest information: www.ibm.com/informix/new. And continue to frequent this forum to see what other customers are doing with IDS. Thanks to all - customers and IBMers both - for making this IDS 11 Open Beta program such a huge success! Message was edited by: scofer_admin

I executed some command to test but showed below message. $ onstat - IBM Informix Dynamic Server Version 11.10.UC1 $ dbaccessdemo stores_demo -dbspace datadbs : : Cannot open file 'cshell.iem'. $ /informix/demo/esqlc>esql demo1.ec -0 demo1 Cannot open file 'csql.iem'. What I need more setting?