Hi,
Currently our project is considering building 10 OCR applications that run on Datacap 9.1.9.
That means there will be 30 databases (admin, engine, fingerprint) all together.
According to Db2 manual, 1GB RAM is recommended for each database.
So, do you think 32GB of memory size is good for 30 Datacap databases?
I am going to give this Db2 server 4 CPU cores. So, 4 CPU cores and 32GB RAM.
On the other hand, I don't think a single Datacap database will ever need 1GB RAM. I think 512MB should be enough.
I mean, Datacap doesn't issue complex SQLs and the table record size never becomes so big.
Do you think 16GB-24GB is the optimal memory size for 30 Datacap databases?
Memory requirements are affected by the size and complexity of your database system, the extent of database activity, and the number of clients accessing your system. At a minimum, a Db2 database instance requires 512MB of RAM, plus an additional 512MB of RAM per database. However, 1 GB or greater of RAM per instance and per database is recommended for improved performance.
https://www.ibm.com/docs/en/db2/11.5?topic=servers-disk-memory-requirements ------------------------------
dsakai
------------------------------