DB2 - Problembeschreibung
Problem IT03725 | Status: Geschlossen |
MAX_COORDAGENTS CANNOT BE SET TO 0 VALUE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
When we activate the database, the DB2 system need to start up couples of system applications. If MAX_COORDAGENTS is set to 0,the database will not able to activate and it will hung. The code that automatically adjust the MAX_COORDAGENTS will not able to execute because the database system have not come up and running. Hence we should not allow this MAX_COORDAGENTS to set to 0 and it should throw an error in case it is tried to be set to 0 via some user or any defect inadvertently. However due to APAR IC97753 is inadvertently set to 0,which made the DB unusable and hung state. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * db2 luw users * **************************************************************** * PROBLEM DESCRIPTION: * * When we activate the database, the DB2 system need to start * * up * * couples of system applications. * * * * If MAX_COORDAGENTS is set to 0,the database will not able * * to * * activate and it will hung. The code * * * * that automatically adjust the MAX_COORDAGENTS will not * * able to * * execute because the database * * * * system have not come up and running. * * * * * * * * Hence we should not allow this MAX_COORDAGENTS to set to * * 0 * * and it should throw an error in * * * * case it is tried to be set to 0 via some user or any * * defect * * inadvertently. * * * * However due to APAR IC97753 is inadvertently set to * * 0,which made the DB unusable and hung state. * **************************************************************** * RECOMMENDATION: * * will be fixed in future fixpacks. * **************************************************************** | |
Local-Fix: | |
db2 update dbm cfg using MAX_CORDAGENTS to any non zero value. | |
Lösung | |
Workaround | |
db2 update dbm cfg using MAX_CORDAGENTS to any non zero value. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.08.2014 21.07.2015 21.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |