home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)