RE: Routine DBA activities for Informix!!!

Come in late. Leave early. Take long lunches. Be arrogant. Blame it on the developer. Actually from what I have seen (which isn't that much) the following seem to always apply. 1. Watch space usage. 2. Ensure backup and restore strategy is reliable. 3. Tune database. a. Try to get good cache rates. b. Try to shorten checkpoints. c. Make sure data is distributed in a good manner. d. Try to make use of all the CPU's. e. Watch for bugs which apply to your system. f. I am sure I do more than this, so there have to be other things :) In addition if you can actually get source code changed the following might also apply. 1. Look at long running queries and try to determine if there is a better way to retrieve the data. 2. Look at long running processes and see if there is anything which can be done to speed them up. You might have some system administration responsibilities as well... Thats all I can think of, Will >===== Original Message From hpandu <hpandu@miel.mot.com> ===== >Hi, > >Regarding DBA activities, Can anyone suggest me what are the routine >activities for Informix DBA. We are having a database of size 200MB in >Solaris. Also if there any site/url, where I can find the info, please >suggest. > >Thanx n regards, >Harish ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------