| Latest versions | fixlist |
| 11.1.0.7 |
 |
| 10.5.0.9 |
|
| 10.1.0.6 |
|
| 9.8.0.5 |
|
| 9.7.0.11 |
|
| 9.5.0.10 |
|
| 9.1.0.12 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
DB2 - Problem description
| Problem IT39374 | Status: Closed |
DB2START IS FAILED WITH -1677 ERROR WHEN EACH MEMBER HAS A CONFIGURED INSTANCE_MEMORY VALUE AND THERE IS A GLOBAL INSTANCE_MEMOR | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problem description: | |
In Purescale environment, when each member has a configured
instance_memory value and there is a global instance_memory
value
configured which is bigger than the physical memory limitation,
the members on this instance will report following error and
faile the initialization:
db2 update dbm cfg using INSTANCE_MEMORY 67528295
db2 update dbm cfg member 1 using INSTANCE_MEMORY 30828134
db2 update dbm cfg member 2 using INSTANCE_MEMORY 30828134
2021-10-17-08.29.54.630302+540 E10021006A475 LEVEL:
Severe
PID : 15138912 TID : 1 PROC :
db2star2
INSTANCE: db2ffp NODE : 003
HOSTNAME: pmsdar04
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:5546
MESSAGE :
ZRC=0x827301CD=-2106392115=HA_ZRC_IDLE_PROCESS_NOT_STARTED_ON_HO
ST
"Idle process is not started on the host"
DATA #1 : String, 47 bytes
An idle process was unable to start on the host
2021-10-17-08.29.54.630809+540 E10021482A360 LEVEL: Error
PID : 15138912 TID : 1 PROC :
db2star2
INSTANCE: db2ffp NODE : 003
HOSTNAME: pmsdar04
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:2
MESSAGE : ADM7502E Instance quiesce request has failed. The
SQLCODE is
"-1677".
2021-10-17-08.29.38.822317+540 E9341098A487 LEVEL:
Severe
PID : 25034862 TID : 1 PROC :
db2star2
INSTANCE: db2ffp NODE : 998
HOSTNAME: pmsdar04
EDUID : 1
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:6091
MESSAGE : ZRC=0xFFFFFB3C=-1220
SQL1220N The database manager failed to allocate
shared memory.
DATA #1 :
INSTANCE_MEMORY setting of 67528295 cannot exceed physical
memory limit of 44040192 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * The users running pureScale. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 V11.5.7.1. * **************************************************************** | |
| Local Fix: | |
Config all member instance_memory to automatic to avoid this design limitation. | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * The users running pureScale. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 V11.5.7.1. * **************************************************************** | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.12.2021 25.02.2022 25.02.2022 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
