Re: Informix WGE with IBM DB2 Gold Bundle
Posted in 2004
A short joking exchange about the Informix WGE with DB2 Gold Bundle thread. Obnoxio The Clown quipped about UPDATE STATISTICS, Data Goob answered with DB2 equivalents (BUFFERPOOL, RUNSTATS), and Captain Pedantic remarked this is an Informix group. Data Goob replied he had understood the joke. No substantive answer.
Topics: Server Administration
Neil Truby said: > "Data Goob" <datagoob@hotmail.com> wrote in message > news:BUcEc.20531$S33.46@fe44.usenetserver.com... >> What might also be useful is for you to pick up two books from IBM: > >> DB2 Universal Database v8 for Linux, UNIX, and Windows Database >> Administration Certification Guide >> ISBN 0-13-046361-2 >> >> Advanced DBA Certification Guide and Reference for DB2 Universal >> Database v8 for Linux, UNIX, and Windows >> ISBN 0-13-046388-4 >> >> These are probably the only two books you'll need for a lot of >> great information on DB2. The advanced guide goes over the different >> HADR options. It also has on the CD a complete doc-set of all the DB2 >> documentation in PDF's. What you can't find in these books is online. >> If you have to choose between the two books get the advanced guide it >> also goes over a lot of other essential information like backups, >> partitioning, log management, etc. > > Have you tried increasing BUFFERS? Or UPDATE STATISTICS? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list
"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:cbtnc4$6lt$1@news.xmission.com...
>
>
> Neil Truby said:
>
> > Have you tried increasing BUFFERS?
>
> Or UPDATE STATISTICS?
>
>
For DB2 it would be:
Have you increased the BUFFERPOOL?
Or RUNSTATS?
:-)
Bonus round: db2pd == onstat
"Data Goob" <datagoob@hotmail.com> wrote in message
news:cQxEc.114469$Mr2.40053@fe03.usenetserver.com...
> "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message
news:cbtnc4$6lt$1@news.xmission.com...
> >
> >
> > Neil Truby said:
> >
> > > Have you tried increasing BUFFERS?
> >
> > Or UPDATE STATISTICS?
> >
> >
>
> For DB2 it would be:
>
> Have you increased the BUFFERPOOL?
> Or RUNSTATS?
>
> :-)
>
> Bonus round: db2pd == onstat
Bloody hell, you're not American too are you?
I think the point he was making - with too much subtlety evidently - is
"This is an Informix newsgroup, and we don't give a shit about books on
DB2".
<british_accent>
Geeezuz Foogin Chrys mate I bloody got the bloody joke, and was bloody rolling along with it.
( Foogin brits take this shite way too serious. )
</british_accent>
"Captain Pedantic" <theharlequin36@hotmail.com> wrote in message news:2kfqliF1rpa4U1@uni-berlin.de...
> "Data Goob" <datagoob@hotmail.com> wrote in message
> news:cQxEc.114469$Mr2.40053@fe03.usenetserver.com...
> > "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message
> news:cbtnc4$6lt$1@news.xmission.com...
> > >
> > >
> > > Neil Truby said:
> > >
> > > > Have you tried increasing BUFFERS?
> > >
> > > Or UPDATE STATISTICS?
> > >
> > >
> >
> > For DB2 it would be:
> >
> > Have you increased the BUFFERPOOL?
> > Or RUNSTATS?
> >
> > :-)
> >
> > Bonus round: db2pd == onstat
>
> Bloody hell, you're not American too are you?
> I think the point he was making - with too much subtlety evidently - is
> "This is an Informix newsgroup, and we don't give a shit about books on
> DB2".
>
>