Re: Suggestions for improving the 7.x OnLine Engine installation and configuration

In article <333560A4.60CB@mindspring.com>, Tim Schaefer <tschaefe@mindspring.com> writes >To all: > >I'm interested in what DBAs actually think about the 7.x Engine, >specifically the installation process, and configuring the ONCONFIG file. > >I'll be covering my own opinions of this in my April issue of my ezine, >located at www.mindspring.com/~tschaefe. I would love to include your >comments in my article, so please get them to me as soon as possible. This >is a bit short notice, but I really didn't think about what I was going to >write about till last week. :-) I've been busy. But I do have some ideas >in the form of a proposal that I'd like to share. I realize we're on to >greater versions, what with 8.0 and now Universal Server, but these two are >so minor hardly anybody I know uses them or even knows them. ( well one or >two people I know use them but really ) > >Maybe these suggestions can improve the product for everyone. > >What would you like to see improved in the 7.x install? > >What would you like to see improved in the 7.x ONCONFIG and operation? Automatic creation of sqlhosts, automatic addition to /etc/services. Program to verify the about (gets $INFORMIXSERVER, checks entry exists in $INFORMIXDIR/sqlhosts, does gethostbyname() to check host exists, does getservbyname fo check services exists). A program I'm planned to write as the next part of my toolkit (I've just finished a tool to dump the complete source to a program including inlining library functions and other modules). This tool I need to to check certain functions never get called in a transaction. Once I've built the second half of this tool + a parser for sqexplain.out to eliminate duplicate query plans from it (I'm fed up of scanning >50 queries most of which are duplicate to find the one I want...) Then I'll write the above!! (Oh yes and a 4GL replacement for onmonitor as it is not supplied with OWS!!!....leave me without my favuorite tool will you.......!!!) Plenty of ideas, too little time..... > >Your opinion counts, so speak up! > >Tim -- David Williams