Re: Dumb DBA mistakes

Posted in 2006

Topics: Performance & Tuning, Stored Procedures & SPL, Server Administration, Java & JDBC Development

Davorin Kremenjas — Thu, 18 May 2006 09:29:09 +0200 — source: Usenet: comp.databases.informix

Don't comment out PC_POOLSIZE and PC_HASHSIZE config params (ie. bringing 'em down to defaults) if you're using a lot of stored procedures, for example for implementing business logic in database (Java architects, please don't comment on this :-)). I've learned this the VERY hard way, after practically bringing the performance down to a crippled snail speed... "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.48.1147795903.19084.informix-list@iiug.org... > > Paul Watson said: >> Following a couple of conversations with 'new' DBAs in Tampa about dumb >> mistakes that they made and learnt from the hard way I offered to >> collate a list of 'dos and do nots' for newbies, I suppose a mini-FAQ of >> dumb DBA mistakes. Therefore, I'm asking all the great and good on CDI >> for their pearls of wisdom, anidotes etc. The idea might die of natural >> causes i.e. lack of interest :-)

↪ replying to Davorin Kremenjas

Colin Dawson — Thu, 18 May 2006 09:15:35 +0000 — source: Usenet: comp.databases.informix

Never use the '-y' option on utilities, the "Do you really want to do this" warning can be a reality check Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Davorin Kremenjas" <davorin.kremenjas@alfatec.hr> >To: informix-list@iiug.org >Subject: Re: Dumb DBA mistakes >Date: Thu, 18 May 2006 09:29:09 +0200 > >Don't comment out PC_POOLSIZE and PC_HASHSIZE config params (ie. bringing >'em down to defaults) if you're using a lot of stored procedures, for >example for implementing business logic in database (Java architects, >please >don't comment on this :-)). >I've learned this the VERY hard way, after practically bringing the >performance down to a crippled snail speed... > >"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message >news:mailman.48.1147795903.19084.informix-list@iiug.org... > > > > Paul Watson said: > >> Following a couple of conversations with 'new' DBAs in Tampa about dumb > >> mistakes that they made and learnt from the hard way I offered to > >> collate a list of 'dos and do nots' for newbies, I suppose a mini-FAQ >of > >> dumb DBA mistakes. Therefore, I'm asking all the great and good on CDI > >> for their pearls of wisdom, anidotes etc. The idea might die of >natural > >> causes i.e. lack of interest :-) > > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://join.msn.com/messenger/overview