Ingres MDB Considerations (CA MDB r1.0.4) › Set Ingres Configuration Parameters (CA MDB r1.0.4)

Set Ingres Configuration Parameters (CA MDB r1.0.4)

To simplify the Ingres configuration for the CA products that use the Management Database, the setupmdb utility is provided to set the II_MDB_SIZE parameter to one of the following values:

• small
• medium
• large

When you install a CA product, one of these settings is established automatically. Do not make any changes unless instructed to do so by the CA product documentation or CA technical support.

If you install a second CA product that uses an existing Management Database, you can use the configuration parameter utility to increase the Ingres configuration setting. The utility only allows increasing the setting. For example, you may go from small to medium, but not from medium to small.

The table below provides guidelines for specifying the Ingres MDB requirements and the machine sizes required to support them.

Note: The Large data model is not supported on Microsoft Windows 2000 systems.

II_MDB_SIZE should be set to one of the values in the previous table. You must ensure that the server hosting the Management Database has sufficient memory and number of processors. The configuration utility must be run on the server where Ingres is installed and you must shut Ingres down before running the configuration utility. For Ingres shutdown instructions, see the Ingres Getting Started guide. The new setting takes effect the next time Ingres is started.

Example

The setupmdb utility may be found on Microsoft Windows in the <II_SYSTEM>\ingres\MDB subdirectory or on Linux in $II_SYSTEM/ingres/mdb.

setupmdb -II_MDB_SIZE=medium -reinitcfg

In this example, the reinitcfg flag re-initializes the II_MDB_SIZE configuration setting to medium. Since the configuration size can only be increased, this example can only change a small to medium. If the previous setting was medium or larger, this example has no effect.

Ingres configuration settings are stored in the <II_SYSTEM>\ingres\files\config.dat (Microsoft Windows) file or $II_SYSTEM/ingres/files/config.dat (Linux) file. A backup copy of the previous file is saved.