Q: What instances have I?

How does one find information about various instances that exist on one's machine? Specifically, say you go up to a new (to you) machine and want to answer the question, "What are my instances, and what are their configurations?" I'm having a little problem with this. For example, one can set the INFORMIXSERVER variable, then run "onstat -c", but if the ONCONFIG variable is not set, it always gives the contents of $INFORMIXDIR/etc/onconfig. If you set the ONCONFIG variable to something that does not correspond to the true configuration file associated with the INFORMIXSERVER setting, onstat will duly give you the information associated with the ONCONFIG setting. And one can't rely on using, say, "grep '^DBSERVERNAME' $INFORMIXDIR/etc/* | grep $INFORMIXSERVER" because several files like this might exist in that directory. Also, the instance files in $INFORMIXDIR/etc/.infos.* don't appear to be guaranteed accurate, either. These could be wiped out (the DBA Guide, vol. 2 tells how to regenerate *one* for a given INFORMIXSERVER), and the documentation also says that when an instance is taken offline, this file is removed. Please reply to the group or via e-mail. Thanks. -Charlie Kapp -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet