Calculating initial catalog store cache size when start_iq server option -c is not specified

If you do not provide a value for the start_iq server option -c switch (either on the command line or using the start_iq default), the database server computes the initial catalog store cache allocation as follows:

  1. The database server uses 32MB as the minimum default cache size.

  2. The database server computes a runtime-specific minimum default cache size, which is the lesser of the following items:

    • 25% of the physical memory of the machine.

    • The sum of the sizes of the main database files specified on the command line. Additional dbspaces apart from the main database files are not included in the calculation. If no files are specified, this value is zero.

  3. The database server allocates the greater of the two values computed.