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 IC68205 Status: Closed

A SORT THAT ENCOUNTERS AN ERROR MIGHT ALSO SEGFAULT IN
STMMSTOPSORTLISTMONITORONFAILURE()

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
A operation require SORT services that encounters an error (such 
as disk full when the sort spills to a temp tablespace, or other 
legitimate others) might segfault and bring down the instance. 
 
You will likely see some kind of legitimate sort related error, 
like so: 
 
2010-01-01-19.45.03.278076+480 I45881212A2803     LEVEL: Severe 
PID     : 471692               TID  : 14788       PROC : db2sysc 
30 
INSTANCE: db2inst1              NODE : 030         DB   : SAMPLE 
APPHDL  : 0-4287               APPID: 
132.228.87.19.40456.09122910292 
AUTHID  : DB2INST1 
EDUID   : 14788                EDUNAME: db2agntp (SAMPLE) 30 
FUNCTION: DB2 UDB, sort/list services, sqlsusda, probe:50 
MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full." 
          DIA8312C Disk was full. 
DATA #1 : String, 14 bytes 
SRT file error 
DATA #2 : Hexdump, 296 bytes 
0x0700000010605310 : 0000 0003 0000 0004 0700 0001 1DBC CC80 
0x0700000010605320 : 0000 00AA 0000 0000 0700 0000 104F 7A20 
0x0700000010605330 : 0001 0005 2F64 6232 6461 7461 2F64 6232 
<...skipped...> 
 
The stack trace will show stmmStopSortListMonitorOnFailure() 
near the top of the stack: 
 
 
<StackTrace> 
@102@3@stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE 
Si 
+ 0x460 
.sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo_fdprpro_clone_1685 + 0x3C 
</StackTrace> 
 
<StackTrace> 
stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE 
sqlsinsr__FP8sqeAgentPcPUcP12sqlri_vectorPP10SQLD_VALUE + 0x44 
sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo + 0x44 
sqlrisr2__FP8sqlrr_cb + 0xFC 
sqlischf__FP7SQLI_CBUsUi + 0x184 
sqliFirstTreeSearch__FP7SQLI_CBP11SQLI_SFGLOB + 0x4C 
sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQLI_ 
sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x38 
sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID@glueC17 + 0x70 
sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT 
sqlritaSimplePerm__FP8sqlrr_cb - 0x4C8 
sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x30 
sqlrihsjn__FP8sqlrr_cb + 0xC 
sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C 
sqlrihsjn__FP8sqlrr_cb + 0xC 
sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C 
sqlrihsjn__FP8sqlrr_cb + 0xC 
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x814 
sqlrr_dss_router__FP8sqlrr_cb + 0x464 
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF68 
sqleSubRequestRouter__FP8sqeAgentPUiT2 + 0x7E8 
sqleProcessSubRequest__FP8sqeAgent + 0x120 
RunEDU__8sqeAgentFv + 0x300 
EDUDriver__9sqzEDUObjFv + 0x94 
sqloEDUEntry + 0x57C 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All.                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A operation require SORT services that encounters an error   * 
* (such as disk full when the sort spills to a temp            * 
* tablespace, or other legitimate others) might segfault and   * 
* bring down the instance.                                     * 
*                                                              * 
* You will likely see some kind of legitimate sort related     * 
* error, like so:                                              * 
*                                                              * 
* 2010-01-01-19.45.03.278076+480 I45881212A2803    LEVEL:      * 
* Severe                                                       * 
* PID     : 471692              TID  : 14788      PROC :       * 
* db2sysc 30                                                   * 
* INSTANCE: db2inst1            NODE : 030        DB   :       * 
* SAMPLE                                                       * 
* APPHDL  : 0-4287              APPID:                         * 
* 132.228.87.19.40456.09122910292                              * 
* AUTHID  : DB2INST1                                           * 
* EDUID   : 14788               EDUNAME: db2agntp (SAMPLE) 30  * 
* FUNCTION: DB2 UDB, sort/list services, sqlsusda, probe:50    * 
* MESSAGE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."  * 
*           DIA8312C Disk was full.                            * 
* DATA #1 : String, 14 bytes                                   * 
* SRT file error                                               * 
* DATA #2 : Hexdump, 296 bytes                                 * 
* 0x0700000010605310 : 0000 0003 0000 0004 0700 0001 1DBC CC80 * 
* 0x0700000010605320 : 0000 00AA 0000 0000 0700 0000 104F 7A20 * 
* 0x0700000010605330 : 0001 0005 2F64 6232 6461 7461 2F64 6232 * 
* <...skipped...>                                              * 
*                                                              * 
* The stack trace will show stmmStopSortListMonitorOnFailure() * 
* near the top of the stack:                                   * 
*                                                              * 
*                                                              * 
* <StackTrace>                                                 * 
* @102@3@stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SL 
* + 0x460                                                      * 
* .sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo_fdprpro_clone_1685 +    * 
* 0x3C                                                         * 
* </StackTrace>                                                * 
*                                                              * 
* <StackTrace>                                                 * 
* stmmStopSortListMonitorOnFailure__FP8sqeAgentP10SQLS_SLDE    * 
* sqlsinsr__FP8sqeAgentPcPUcP12sqlri_vectorPP10SQLD_VALUE +    * 
* 0x44                                                         * 
* sqlrsinsr__FP8sqlrr_cbP10sqlri_iudo + 0x44                   * 
* sqlrisr2__FP8sqlrr_cb + 0xFC                                 * 
* sqlischf__FP7SQLI_CBUsUi + 0x184                             * 
* sqliFirstTreeSearch__FP7SQLI_CBP11SQLI_SFGLOB + 0x4C         * 
* sqlirdk__FP8sqeAgentP10SQLI_IXPCRP9SQLD_IXCBUlP8SQLD_KEYP12SQL 
* sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID + 0x38                 * 
* sqldIndexFetch__FP8SQLD_CCBP8SQLZ_RID@glueC17 + 0x70         * 
* sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RI 
* sqlritaSimplePerm__FP8sqlrr_cb - 0x4C8                       * 
* sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x30  * 
* sqlrihsjn__FP8sqlrr_cb + 0xC                                 * 
* sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C  * 
* sqlrihsjn__FP8sqlrr_cb + 0xC                                 * 
* sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm@glue10AA + 0x3C  * 
* sqlrihsjn__FP8sqlrr_cb + 0xC                                 * 
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x814          * 
* sqlrr_dss_router__FP8sqlrr_cb + 0x464                        * 
* sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xF68    * 
* sqleSubRequestRouter__FP8sqeAgentPUiT2 + 0x7E8               * 
* sqleProcessSubRequest__FP8sqeAgent + 0x120                   * 
* RunEDU__8sqeAgentFv + 0x300                                  * 
* EDUDriver__9sqzEDUObjFv + 0x94                               * 
* sqloEDUEntry + 0x57C                                         * 
* </StackTrace>                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v97fp3 or later.                                  * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
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

Solution
This problem is first fixed in version 9.7 fixpack 3.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.04.2010
24.09.2010
24.09.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP3
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.3 FixList
9.7.0.3 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.