DB2 - Problem description
| Problem IC67957 | Status: Closed |
UNABLE TO EXECUTE NON-SQL STORED PROCEDURES ON SYSTEM WITH HIGH NUMBER OF CPUS | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 | |
| Problem description: | |
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 Summary: | |
| Local Fix: | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| Comment | |
Closed because it is a duplicate of IC67246 opened for DB2 v9.8 as well. | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.04.2010 04.06.2010 13.09.2010 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |