Hello I am using IBM Maximo application which is using DB2 database and I have created only one database. I heard that when paramtere NUMDB has value 8 it will divide all values in DB CONFIGURATION PARAMATERS because it will also get memory for other databases which does not exists. Is this true and should I change value from 8 to 1 because I have only one database? All I could find about this is on this link:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Information Center is pretty reliable, and I don't see any indication that it will divide memory for non-existent databases. Do you have another link that indicates that?
Otherwise, it is meant to be the maximum number of allowable activated/connected to databases. So there is no need to set it high (I believe by default it is set to something like 12).
Based on the page you have, it is recommended that you set it to the number of databases you have + 10% for room for growth. So if you have 1 database, you would want 1 database + 10% (which in this case would round up) so you would set it to 2.
The reason I believe IBM recommends this, is that you can sometimes get caught with
So I would follow IBM's recommendation, which in your case would be to set
I think this also might not be a "hot" setting, thus requiring you to run