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 |