Content Management and Capture

 View Only
  • 1.  Db2 database sizing for Datacap

    Posted Thu January 05, 2023 09:42 AM
    Edited by dsakai Thu January 05, 2023 09:43 AM
    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
    ------------------------------


  • 2.  RE: Db2 database sizing for Datacap

    Posted Thu January 19, 2023 09:39 AM
    Hi Dsakai, that would be overkill check this out from documentation where you can use one database for admin, eng and fingerprint.

    "You can run the SQL scripts for these Datacap application databases separately to create a separate DB2 , SQL Server, or Oracle database for each of the application databases. Alternatively, you can run the SQL scripts together to create just one database that contains the Administration, Engine, and Fingerprint database schemas. This procedure creates a single DB2 database user for all of the Datacap application databases."

    Creating a single DB2 database for a Datacap application - IBM Documentation

    ------------------------------
    Jay Bowen
    ------------------------------



  • 3.  RE: Db2 database sizing for Datacap

    Posted Fri January 20, 2023 01:52 AM
    Thank you. I've never tried that one database containing admin, engine, and fingerprint tables.
    This will surely require less memory size. Is there any demerit to this configuration?
    We've always created a separated database for admin, engine, and fingerprint tables.

    ------------------------------
    dsakai
    ------------------------------