I have been doing some reading, according to what I found the embedded database is DB2. but the appliance does NOT support external SQL / DB2 database only Oracle 10/11G are allowed.
That's not a problem, but if you want to use the embedded DB2 database (I assume this isn't the same as IBM DB2??!?) be aware that you may see people incorrectly show the support as 5 hosts / 50 VM's.
PG. 43, vCenter host / management guide (VM Ware documentation page):
Hi RParker,
thanks for sharing this, this is very interesting.
People are indeed spreading the "50 vms support" information, but VMware too, considering this :
Are you actually run more than 50 vms/5 esxi hosts with a vCSA 5 vappliance/internal database ?
Thanks for your feedback
The 5hosts and 50 VMs is not a technical limit... you can easy have more than this number.
The problem (at least with SQL Express) is the DB size limit, that mean that if could fill faster with a lot of hosts and/or VMs.
I don't know the size limit of the embedded DB2 of VCSA...
Andre
There is no limit on database size in DB2 Express. The limits are on the number of CPUs used (2) and the amount of memory used (2GB).
http://www-01.ibm.com/software/data/db2/express/about.html
Otherwise, this is a full-up version of IBM DB2. The old advice was for 5 hosts and 50 VMs when using Microsoft SQL Express ... but it is not at all clear that the same limits should apply to the vCSA when using the embedded DB2 Express instance. I suspect the old advice got carried over, but does not in fact apply.
A mere 5 hosts / 50 VMs sure looks like small data to me....