DB2 - Problem description
| Problem IC81653 | Status: Closed |
DB2START FAILS WITH SQL10003 ON SOLARIS 10, SPARC T4 PROCESSOR WITH 2GB PAGE SIZE SUPPORT | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
| Problem description: | |
db2start fails with SQL10003 due to attaching the FMP memory set
to an invalid address on the Solaris 10 / Sparc T4 processor
combination with 2GB page size support. Solaris 10 update 4
(kernel patch 147440-04) enables 2GB pages by default.
The problem is due to an inconsistency in the way DB2 rounds up
shared segment sizes and then calculates the attach addresses of
"fixed address" segments. With 2GB page sizes available, DB2
tries to attach a shared memory segment at an address that is in
use by a previously attached segment. This is independent of
the actual backing page size used, it only matters what the
largest page size is determined to be available on the system
from the Solaris getpagesizes API.
expected db2diag.log messages:
2012-02-18-13.04.43.276604-360 I8210A728 LEVEL: Severe
PID : 17832 TID : 2 PROC : db2sysc
INSTANCE: db2inst2 NODE : 000
EDUID : 2 EDUNAME: db2sysc
FUNCTION: DB2 UDB, routine_infrastructure, sqlerInitFmpHeap,
probe:60
MESSAGE : Failed to create the memory segment used for
communication with
fenced routines. If re-starting db2, ensure no db2fmp
processes were
on the instance prior to start. Otherwise, you can
adjust this value
through DB2_FMP_COMM_HEAPSZ db2set value, or by
decreasing your
ASLHEAPSZ setting.
DATA #1 : Hexdump, 8 bytes
0xFFFFFFFF603FCDB8 : 0000 0000 015E 8480
.....^..
...
2012-02-18-13.04.43.278198-360 I9653A320 LEVEL: Severe
PID : 17832 TID : 2 PROC : db2sysc
INSTANCE: db2inst2 NODE : 000
EDUID : 2 EDUNAME: db2sysc
FUNCTION: DB2 UDB, oper system services, sqloWatchDogSetup,
probe:60
MESSAGE : ZRC=0xFFFFD8ED=-10003
...
2012-02-18-13.04.43.288489-360 I10469A906 LEVEL: Error
PID : 17827 TID : 2 PROC : db2wdog
0
INSTANCE: db2inst2 NODE : 000
EDUID : 2 EDUNAME: db2wdog 0
FUNCTION: DB2 UDB, SQO Memory Management, sqlocshr, probe:10
MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid
memory addr"
DIA8561C A invalid memory block was encountered.
DATA #1 : Pointer, 8 bytes
0x0000000000000000 | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Hardware: SPARC T4 * * Software: Solaris 10 with 147440-04 patch installed. This * * patch (or any one above) enables 2 GB memory pages. * **************************************************************** * PROBLEM DESCRIPTION: * * DB2 instance cannot be started with error message : * * SQL10003C There are not enough system * * resources to process the request. The request cannot be * * processed. * * SQL1032N No start database manager command was issued. * * SQLSTATE=57019 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 10 * **************************************************************** | |
| Local Fix: | |
| Solution | |
Problem first fixed in DB2 Version 9.5 Fix Pack 10 | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.02.2012 21.08.2012 07.12.2012 |
| Problem solved at the following versions (IBM BugInfos) | |
9.5.FP10 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.5.0.10 |
|