Oninit cdi / Archive
Talk to an expert →

Re: Problems With ESQLC on HP/UX 10.20

Posted in 2000

Topics: Installation, Setup & Upgrades, Storage & Space Management, Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Logging & Checkpoints, Platform-Specific Issues

Mark D. Stock — — source: Informix-list mailing list archive (1991-1998)

Tim Schaefer wrote: > > 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.... :-> > <History lesson snipped> > > 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. I still don't see the benefit of all that effort just to be able to use a browser. I find telnet far more robust, and it allows me to use my shell scripts, which I am certainly not converting to HTML. The only use for HTML output from onstat I could see would be WAP, but then what DBA is going to administer their database servers using a PDA or cell phone? :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+

↪ replying to Mark D. Stock
Tim Schaefer — — source: Informix-list mailing list archive (1991-1998)

See also http://www.webmin.com/webmin/ Whether or not "you" understand the benefits of HTML and browsers, apparently a lot of other people do. And not just for the sake of arguing. Tim "Mark D. Stock" wrote: > > I still don't see the benefit of all that effort just to be able to use > a browser. I find telnet far more robust, and it allows me to use my > shell scripts, which I am certainly not converting to HTML. > > The only use for HTML output from onstat I could see would be WAP, but > then what DBA is going to administer their database servers using a PDA > or cell phone? :-) > > Cheers, > -- > Mark. > > +----------------------------------------------------------+-----------+ > | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| > | http://www.informix.com http://www.informixhandbook.com |///// / //| > | http://www.iiug.org +-----------------------------------+//// / ///| > | |What year 2000 bug? year 2000 bug? |/// / ////| > | |year 2000 bug? year 2000 bug? year |// / /////| > | |2000 bug? year 2000 bug? year 1900 |/ ////////| > +----------------------+-----------------------------------+-----------+ -- . .- .-- .--- .---- Tim Schaefer .----- tschaefe@bellsouth.net .---- http://www.inxutil.com .--- .-- .- .

Glossary