Re: Re: Dumb DBA mistakes

What about: Don't get some kind of support by IBM or any other VAR. Even worse don't subscribe to c.d.i or iiug. J. -----Original Message----- From: "bozon" <curtis@crowson1.com> To: informix-list@iiug.org Date: 16 May 2006 09:57:29 -0700 Subject: Re: Dumb DBA mistakes Don't bring up IDS with the PDQPRIORITY environment variable set on an OLTP system. It was very ugly for me. 3000 users all trying to run queries at PDQPRIORITY of 1. In fact Jonathan Leffler showed a really nice way to bring up the server in his paranoid DBA class in Tampa. Prevents these kinds of mistakes. Check to make sure chunks are not being used by another instance on the box before allocating them to an instance. (I never did this one personally but I have heard about it.) Of course be very careful with oninit -iy. Make sure that your logs are backing up correctly so that the server doesn't hang when it runs out of logs. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Jean Sagi jeansagi@myrealbox.com jeansagi@gmail.com