|
Problem IC66545
|
Status: Closed |
APPGROUP_MEM_SZ CAN NOT BE CONFIGURATED TO MORE THAN 524287 SQLO_MEM_SIZE ERROR REPORTED IN DB2DIAG.LOG. |
| product: |
DB2 FOR LUW / DB2FORLUW / 910 - DB2 |
| Problem description: |
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 Summary: |
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: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
|
| Solution |
defect: wsdbu00622117
CSD: First fixed in DB2 UDB Version 9, FixPak 10
module: ENGN_SQE |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.02.2010
13.06.2011
13.06.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.10
|
 |
