Just as I was wishing there was more Informix support for Ruby, one of my colleagues unearthed this open source Informix driver for Ruby project. Kudos to Gerardo Santana for creating it.
Check out the Driver site for some programming examples and installation instructions.[Read More]
Administrating and Developing with Informix
gbowerman 100000B5T0 1,089 Visits
Informix marketing can be a contentious topic amongst Informix aficionados, the feeling in some quarters being that there should be more of it and it should be better, or to paraphrase Stuart Litel: "if Informix sold sushi they'd have called it raw dead fish".
I saw some interesting sales numbers this morning. The exact numbers are not public information but I can say with my clear technical support conscience that IDS sales and revenue experienced impressive growth in the last quarter, and that marketing is being stepped up.
All I've heard officially on the Q1 revenue is (and I quote):
"IBM is investing to grow the IDS business into the future. It is now a strategic server in the Information Management Portfolio. We have embarked on several initiatives including ISV revitalization and business partners enablement. Along with renewed customer confidence in IDS' future, we have seen very positive Q1 results in our efforts to grow the IDS business."
I've also seen the number of IDS development engineers grow (including many senior engineers coming back to IDS) recently, several of them here in Beaverton which is great for us, so right now I'm experiencing mildly elevated serotonin levels on the subject of where IDS is going, though that could be the cup of tea I just had.[Read More]
Currently trying (without much success) to ignore all distractions and work on my presentation for the Informix Tech Fair next week.
Question of the hour
Q. Is there an easy way to see which users have been granted dba privileges for a database?
A. Connect to the database and run the following query:
select username from sysusers where usertype = 'D' and username != 'informix';[Read More]
There isn't much to starting IDS on UNIX - set your environment (INFORMIXSERVER, INFORMIXDIR, ONCONFIG, PATH) and run oninit as user informix or root.
Making IDS start automatically when the machine is started can be a little more challenging as you need to edit the /etc/rc.d files to set the environment and launch oninit.
On Windows IDS is designed to run as a Windows service and there are more ways to start it. At least making IDS start automatically is easier, just locate the IDS service in Control Panel->Administrative Tools->Services and modify the Properties to set Startup Type to Automatic. Another good thing is that for most startup methods, there is no need to set the environment.
Here's a look at the methods of manually starting IDS on Windows and their relative merits:
The GUI method - fine for starting manually with GUI access to the machine.
net start %INFORMIXSERVER%
The standard command line method for starting a Windows service. Disadvantage: doesn't let you pass command line arguments to oninit.
Does what net start does but allows oninit command line arguments. For example to bring an IDS instance to quiscent mode:
starts %INFORMIXSERVER% -s
Run oninit from the command line.
The oninit.exe process can be launched in foreground by setting the IDS environment and running oninit directly. Unlike on UNIX where it will fork and return you to the command prompt, it will run in foreground and not return the DOS prompt to the command line. Generally this is not recommended but can be useful when:
1. Troubleshooting a problem with the IDS service - sometimes if the IDS service won't start, launching oninit in foreground can help eliminate possible causes - for example if the IDS Service informix user password is set incorrectly.
2. Launching IDS in a relative directory to run HDR between two instances on the same machine (see an earlier post).
Update June 9 '06:Run oninit.exe from a command shell in background.
I hadn't thought about this method until I saw a comp.databases.informixthread that mentioned it. If you start a command shell as informix (or use runas) and run start /b oninitthe oninit.exe process will be launched in a background command window. This is a way to see verbose output from oninit, but still keep the process running in background. Because it's not running as a Windows service, oninit will not get its environment from the HKEY_LOCAL_MACHINE/Software/Informix/Online/%INFORMIXSERVER%/Environment registry key but from the user's environment. This is not necessarily a disadvantage as long as it is understood - in fact sometimes it can be an advantage. The only inconvenience is the need to be the informix user when you run it. You could work around this by wrapping it in a runas script like this:
runas /env /user:informix "start /b oninit"
I typically use the starts method. For example the following batch file shuts down and re-starts IDS (assumes you have a gnu, Cygwin or equivalent tool like sleep installed), and takes command line arguments:
onmode -yksleep 4starts %INFORMIXSERVER% %*[Read More]
Back from vacation to find a nice brew of problems awaiting... meanwhile here's the flyer for the next Informix Tech Fair here in Beaverton:
Informix Tech Fair
FREE Informix Tech Fair
Talks include the following topics:
IBM Informix Advanced Support & Development Speakers:
Guy Bowerman, Ian Ilsley, Hyun-Ju Vega, John Miller
Come and see demos integrating several application technologies.
Free ConsultingHaving a problem or question about Informix? Talk to an engineer and get free advice about your specific issue. Time is limited.
WHEN: May 2, 2006 between 9:15 – 4:30
WHERE: IBM Beaverton
15300 SW Koll Parkway
Beaverton, OR 97006
If you're in the area drop by. If you have any questions post a comment here or RSVP.[Read More]