DB2 - Problembeschreibung
Problem IC66545 | Status: Geschlossen |
APPGROUP_MEM_SZ CAN NOT BE CONFIGURATED TO MORE THAN 524287 SQLO_MEM_SIZE ERROR REPORTED IN DB2DIAG.LOG. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 | |
Problembeschreibung: | |
When trying to change APPGROUP_MEM_SZ to more than 524287, the following error messages are reported in db2diag.log: 2010-02-17-15.35.17.046751-360 I1672A958 LEVEL: Severe PID : 4595730 TID : 1 PROC : db2agent (CRD_CNTG) 130 INSTANCE: db2bofa1 NODE : 130 APPHDL : 130-51 APPID: *N130.db2bofa1.100217213453 AUTHID : DB2BOFA1 FUNCTION: DB2 UDB, base sys utilities, sqleAllocateAppGroup, probe:21 MESSAGE : Failed to allocate App Ctl Shr Mem Set with following error. Reduce APPGROUP_MEM_SZ. On 32bit AIX, this problem may also happen when the DB memory set is too big that it spills over to the APPGROUP memory address. Try reducing the DB memory size by using smaller bufferpool(s), or reducing the values for the database configuration parameters that affect the size of the DB memory such as DBHEAP, CATALOGCACHE_SZ, LOCKLIST, PCKCACHESZ, etc... DATA #1 : Hexdump, 4 bytes 0x0FFFFFFFFFFEF6A0 : 820F 0004 .... 2010-02-17-15.35.17.046984-360 I2631A473 LEVEL: Severe PID : 4595730 TID : 1 PROC : db2agent (CRD_CNTG) 130 INSTANCE: db2bofa1 NODE : 130 APPHDL : 130-51 APPID: *N130.db2bofa1.100217213453 AUTHID : DB2BOFA1 FUNCTION: DB2 UDB, base sys utilities, sqleAllocateAppGroup, probe:20 RETCODE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt invalid size" DIA8563C An invalid memory size was requested. 2010-02-17-15.35.18.368710-360 I3105A466 LEVEL: Severe PID : 4595730 TID : 1 PROC : db2agent (idle) 130 INSTANCE: db2bofa1 NODE : 130 APPHDL : 130-51 APPID: *N130.db2bofa1.100217213453 AUTHID : DB2BOFA1 FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:140 RETCODE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt invalid size" DIA8563C An invalid memory size was requested. | |
Problem-Zusammenfassung: | |
Users Effected: All users on Unix/Linux/Windows Problem Description: PPGROUP_MEM_SZ CAN NOT BE CONFIGURATED TO MORE THAN 524287 QLO_MEM_SIZE ERROR REPORTED IN DB2DIAG.LOG. Problem Summary: When trying to change APPGROUP_MEM_SZ to more than 524287, the following error messages are reported in db2diag.log: 2010-02-17-15.35.17.046751-360 I1672A958 LEVEL: Severe PID : 4595730 TID : 1 PROC : db2agent (CRD_CNTG) 130 INSTANCE: db2bofa1 NODE : 130 APPHDL : 130-51 APPID: *N130.db2bofa1.100217213453 AUTHID : DB2BOFA1 FUNCTION: DB2 UDB, base sys utilities, sqleAllocateAppGroup, probe:21 MESSAGE : Failed to allocate App Ctl Shr Mem Set with following error. Reduce APPGROUP_MEM_SZ. On 32bit AIX, this problem may also happen when the DB memory set is too big that it spills over to the APPGROUP memory address. Try reducing the DB memory size by using smaller bufferpool(s), or reducing the values for the databas configuration parameters that affect the size of the DB memory such as DBHEAP, CATALOGCACHE_SZ, LOCKLIST, PCKCACHESZ, etc... DATA #1 : Hexdump, 4 bytes 0x0FFFFFFFFFFEF6A0 : 820F 0004 .... 2010-02-17-15.35.17.046984-360 I2631A473 LEVEL: Severe PID : 4595730 TID : 1 PROC : db2agent (CRD_CNTG) 130 INSTANCE: db2bofa1 NODE : 130 APPHDL : 130-51 APPID: *N130.db2bofa1.100217213453 AUTHID : DB2BOFA1 FUNCTION: DB2 UDB, base sys utilities, sqleAllocateAppGroup, probe:20 RETCODE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt invalid size" DIA8563C An invalid memory size was requested. 2010-02-17-15.35.18.368710-360 I3105A466 LEVEL: Severe PID : 4595730 TID : 1 PROC : db2agent (idle) 130 INSTANCE: db2bofa1 NODE : 130 APPHDL : 130-51 APPID: *N130.db2bofa1.100217213453 AUTHID : DB2BOFA1 FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:140 RETCODE : ZRC=0x820F0004=-2112946172=SQLO_MEM_SIZE "Mem Mgt invalid size" DIA8563C An invalid memory size was requested. | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows | |
Lösung | |
defect: wsdbu00622117 CSD: First fixed in DB2 UDB Version 9, FixPak 10 module: ENGN_SQE | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.02.2010 13.06.2011 13.06.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.0. | |
Problem behoben lt. FixList in der Version | |
9.1.0.10 |