Re: Problems With ESQLC on HP/UX 10.20

From: Tim Schaefer <tschaefe@bellsouth.net> > >By the way, the Informix Server Administrator works well on AIX and HP/UX. >ISA has a few interesting features, and I've actually come to liking the >tag-along apache web server and perl, it paves the way to piggy-back other >web stuff on to machines that were previously void of apache and perl, >especially in cases where you don't have time to do a full-blown apache >& perl installation or the circumstances wouldn't normally allow such >things to be installed without a major amount of attention. I sincerely hope you have officially apologised to everyone who's head you ripped off.... :-> ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Obnoxio The Clown wrote: > > From: Tim Schaefer <tschaefe@bellsouth.net> > > > >By the way, the Informix Server Administrator works well on AIX and HP/UX. > >ISA has a few interesting features, and I've actually come to liking the > >tag-along apache web server and perl, it paves the way to piggy-back other > >web stuff on to machines that were previously void of apache and perl, > >especially in cases where you don't have time to do a full-blown apache > >& perl installation or the circumstances wouldn't normally allow such > >things to be installed without a major amount of attention. > > I sincerely hope you have officially apologised to everyone who's head you > ripped off.... :-> Did they do that in the French Revolution too?? :-) If I remember my history lessons Marie Antoinette mentioned cake at a time when it was inappropriate and got her head cut off. Similarly, if Informix wants people to eat cake, i.e. no marketing, bad choices in press releases about products that don't matter, stupid installation media tricks, etc. I really don't think it sits well for end users while there are so many things they need to fix organizationally speaking, as well as their marketing and some of the engine problems in 7.3. ISA is a pretty face for onstat, but in a lot of ways wastes a web page with a lot of nothing. On balance I like the way much of ISA works server side, it would be great if there were fewer clicks to real information rather than just being pretty. Onstat has a few reports that really tell you something but in most cases unless there is detailed documentation, the reports are of little value. For example, which of these two reports is really useful: Fri Mar 24 07:16:21 EST 2000 INFORMIXSERVER: reef_2k_shm ONCONFIG: reef_2k_shm.cfg HOST: reef PAGE_SIZE: 2048 -------------------------------------------------------------------------------- No Uniqid SZ KB Used % Used Flags Status DBspace Chk Drive -------------------------------------------------------------------------------- 1 1 1536000 1536000 100.00 5 U-B--- rootdbs 1 /opt/data/rootdbs 2 2 1536000 1536000 100.00 5 U-B--- rootdbs 1 /opt/data/rootdbs 3 3 1536000 1536000 100.00 5 U-B--- rootdbs 1 /opt/data/rootdbs 4 4 1536000 1536000 100.00 5 U-B--- rootdbs 1 /opt/data/rootdbs 5 5 1536000 153600 10.00 3 U--C-L rootdbs 1 /opt/data/rootdbs 6 0 1536000 0 0.00 0 F----- rootdbs 1 /opt/data/rootdbs OR Informix Dynamic Server 2000 Version 9.20.UC1 -- On-Line -- Up 2 days 12:16:38 -- 10700 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 16 57 11 5.18 phybegin physize phypos phyused %used 100107 1000 291 0 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-3 0 16 210 26 26 8.1 1.0 Subsystem numrecs Log Space used OLDRSAM 210 15080 address number flags uniqid begin size used %used 10049688 1 U-B---- 1 1004ef 750 750 100.00 100496a4 2 U-B---- 2 1007dd 750 750 100.00 100496c0 3 U-B---- 3 100acb 750 750 100.00 100496dc 4 U-B---- 4 100db9 750 750 100.00 100496f8 5 U---C-L 5 1010a7 750 76 10.13 10049714 6 F------ 0 101395 750 0 0.00 Do I really need to know the address of a logical log for this particular moment?? Or maybe I don't need all that information about the physical log right now. The format is difficult to read from onstat, ugly at best. It could be a lot better. I've found a better way in actually hitting the SMI tables and writing scripts that give me information that makes sense, or displaying onstat output ONLY when not able to hit SMI tables. If you want to see my own version of an ISA stop by my web site. My own WebTop DBA is still under construction, as well as its documentation, but certainly allows a faster path to information a DBA could actually use, and what it doesn't have you can add to it very easy. ISA simply paves the way for an add-on such as this. It's nice that you can still use ISA for the stuff that could change things, and use other things to report with. I need add only a few lines to the httpd.conf and other pages like WebTop DBA can be added to ISA--rather than attempting to use the "Custom" feature in ISA. ;-) Thanks, Tim -- . .- .-- .--- .---- Tim Schaefer .----- tschaefe@bellsouth.net .---- http://www.inxutil.com .--- .-- .- .