Re: Informix DBA on AIX
> From: epekarik@ix.netcom.com (Endre Pekarik) > Subject: Informix DBA on AIX > > What are the exact job functions of an Informix DBA on a Risc/6000 AIX > system? (Basic funtions to advanced) We must decide if an existing > employee could do the job or we need to hire someone. > > thnks epekarik If you are running Informix SE then very little DBA work is required, and one of your in-house people could do it (probably.) If you use OnLine, especially version >=6, you can expect a lot of work to make it all come out right. At our site the DBA does a tremendous amount of work, including: ---------------------------------------------------------------- Tune databases -set appropriate extent sizes for tables -define tables large enough to fit inside 8 extents (max) -monitor dbspace -adjust purges and db size IAW company requirements -adjust locks, logs, high-water marks, buffers, etc -move logs from same dbspace as main data -map db usage for each db (chunks, mirrors, sizes) -reduce test db resources -maintain DBA logs of tuning & adjustments -maintain backup copies of schemas, tbconfigs, startup, backup, and shutdown scripts, crontab entries -update statistics periodically Keep abreast -keep abreast of informix newsgroup on internet -attend user conferences -attend classes and upgrade seminars Maintain databases -maintain connection permissions at db level -maintain user permissions at table level (systabauth table) -provide backup of raw dbspace (do_ol_backup.sh) -institute "watcher" program (from internet) to automatically monitor database numbers -install new informix software -migrate databases to new platforms New Development -integrate all shop floor systems into "distributed db" -upgrade systems to latest versions all for EACH system (we have around 20 or 30). Good luck (you'll need it), __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|