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) |