Re: Informix WGE with IBM DB2 Gold Bundle

Posted in 2004

Obnoxio The Clown — Wed, 30 Jun 2004 07:02:56 +0100 (BST) — source: Usenet: comp.databases.informix

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

↪ replying to Obnoxio The Clown

Data Goob — Wed, 30 Jun 2004 07:50:28 -0400 — source: Usenet: comp.databases.informix

"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

↪ replying to Data Goob

Captain Pedantic — Wed, 30 Jun 2004 13:44:07 +0100 — source: Usenet: comp.databases.informix

"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".

↪ replying to Captain Pedantic

Data Goob — Wed, 30 Jun 2004 09:09:39 -0400 — source: Usenet: comp.databases.informix

<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". > >

Glossary

UPDATE STATISTICS