DB2 FOR LUW / DB2FORLUW / 970 - DB2

You may see following severe message in the db2diag.log : 
 
2012-08-22-14.11.47.121000+120 I6229343F540       LEVEL: Severe 
PID     : 10364                TID  : 11768       PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : DBNAME 
APPHDL  : 0-31650              APPID: 
10.11.110.210.4934.120822120652 
AUTHID  : DB2INST1 
EDUID   : 11768                EDUNAME: db2agntp 0 
FUNCTION: DB2 UDB, Self tuning memory manager, 
stmmReleaseUnthrottledSharedSortSpace, probe:2615 
MESSAGE : Trying to release more pages than were held -  2 - 
786556 - 
         4294705272 - 
 
Message is related to some other warnings of type: 
 
2012-08-22-15.25.17.207000+120 I6242572F1073      LEVEL: Warning 
PID     : 10364                TID  : 2224        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : DBNAME 
APPHDL  : 0-32116              APPID: 
10.11.110.210.1724.120822131417 
AUTHID  : DB2INST1 
EDUID   : 2224                 EDUNAME: db2agent (DBNAME) 0 
FUNCTION: DB2 UDB, sort/list services, 
sqlsReleaseSharedSortSpace, probe:10 
DATA #1 : String, 46 bytes 
Sort shared memory counter underflow detected 
DATA #2 : unsigned integer, 4 bytes 
260642 
DATA #3 : unsigned integer, 4 bytes 
260640 
CALLSTCK: 
  [0] 0x000000018010B885 pdLog + 0x353 
  [1] 0x0000000003A349D6 sqlsfshp + 0x9FE 
  [2] 0x0000000003A2C753 sqlsopen + 0xC57 
  [3] 0x00000000034FDF35 sqlrsopen + 0xCD 
  [4] 0x000000000361AFDE sqlrisrt + 0x2D0 
  [5] 0x00000000034D6BFF sqlriSectInvoke + 0x139 
  [6] 0x0000000003219314 sqlrr_process_fetch_request + 0x1A8 
  [7] 0x0000000003214D47 sqlrr_open + 0x531 
  [8] 0x00000000023D92EB sqljs_ddm_opnqry + 0x447 
  [9] 0x00000000023B8021 sqljsParse + 0x2B85 
 
 
and: 
 
2012-08-23-23.44.03.058000+120 I6566317F1115      LEVEL: Warning 
PID     : 10364                TID  : 6988        PROC : 
db2syscs.exe 
INSTANCE: DB2                  NODE : 000         DB   : DBNAME 
APPHDL  : 0-6810               APPID: *LOCAL.DB2.120823213457 
AUTHID  : DB2INST1 
EDUID   : 6988                 EDUNAME: db2agntp (DBNAME) 0 
FUNCTION: DB2 UDB, sort/list services, 
sqlsReleaseSharedSortSpace, probe:10 
DATA #1 : String, 46 bytes 
Sort shared memory counter underflow detected 
DATA #2 : unsigned integer, 4 bytes 
94440 
DATA #3 : unsigned integer, 4 bytes 
91830 
CALLSTCK: 
  [0] 0x000000018010B885 pdLog + 0x353 
  [1] 0x0000000003A2F8A2 sqlsReleaseSharedSortSpace + 0x1E4 
  [2] 0x0000000003516F09 sqlriReleaseSortSpace + 0x1D 
  [3] 0x000000000350935A sqlri_hsjnClose + 0xCA0 
  [4] 0x000000000362DB31 sqlrihsjn + 0x329 
  [5] 0x00000000034D6BFF sqlriSectInvoke + 0x139 
  [6] 0x00000000032DFFF4 sqlrr_smp_router + 0x184 
  [7] 0x00000000032E2C8B sqlrr_subagent_router + 0xE6F 
  [8] 0x000000000220A77E sqleSubRequestRouter + 0xA32 
  [9] 0x000000000220962A sqleProcessSubRequest + 0x200 
 
 
Warnings are recorded with different stacks (and stack might be 
different than the ones above). 
Severe message is informational (no other symptoms of problem 
except mentioned severe message).

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 fixpack 8                         * 
****************************************************************

DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 version 9.7 fixpack 8

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC91744 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

24.12.2012
09.04.2013
09.04.2013

9.7.FP8