Re: Senior Oracle DBA now Learning Informix by Request

> I recently worked for The Wigwam Depot as an Informix DBA. We maintained > 6000+ Informix instances in 2000+ retail locations and 100+ corporate > Informix instances with 2.5 full time Informix DBAs (2 full time DBAs and a > Team Lead who split time between IDS administration and management type > stuff). It is my understanding that they are currently maintaining the same > configuration with 1.5 DBAs with help from 5 "Other DB Engine" DBAs to help > with the after hours on call rotation. Cool - finally something real. I assume Wigwam Depot is Home Depot. I assume the 6000+ instances are the instances in the stores (3 per store ?)? Can you describe a little what they do (i.e product catalogs, POS data stores, etc etc). Workload profile ? Peak Transaction rates ? What release/version of Informix ? Is every instance the same in each store ? How often are they upgraded ? How are they initially provisioned ? Are they centrally managed ? Do they replicate back to a central server ? If you can give me some generic guidelines I can then try to match that to similar customers doing similar things with Oracle.