DB2 - Problembeschreibung
| Problem IC67957 | Status: Geschlossen |
UNABLE TO EXECUTE NON-SQL STORED PROCEDURES ON SYSTEM WITH HIGH NUMBER OF CPUS | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
| Problembeschreibung: | |
On systems with a high number of CPUs the following error
message calling a non-SQL routine (stored procedure/user defined
function) may hang or return SQL1042.
The db2diag.log will also contain messages indicating that the
call to sqlochsr failed with the error SQLO_NOSEG such as the
example below. Note the example was from Windows so on
Linux/UNIX the CALLED and OSERR parts of the message may differ
slightly.
2010-01-01-11.00.36.987000-400 I6620F560 LEVEL: Severe
(OS)
PID : 1224 TID : 3924 PROC :
db2fmp64.exe
INSTANCE: DB2 NODE : 000
EDUID : 3924
FUNCTION: DB2 UDB, SQO Memory Management, sqlocshr, probe:140
MESSAGE : ZRC=0x850F0005=-2062614523=SQLO_NOSEG
"No Storage Available for allocation"
DIA8305C Memory allocation failure occurred.
CALLED : OS, -, OpenFileMapping
OSERR : 2 "The system cannot find the file specified."
DATA #1 : String, 21 bytes
Global\DB2SHMDB2_0DBM | |
| Problem-Zusammenfassung: | |
| Local-Fix: | |
| Lösung | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Kommentar | |
Closed because it is a duplicate of IC67246 opened for DB2 v9.8 as well. | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 15.04.2010 04.06.2010 13.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |