DB2 FOR LUW / DB2FORLUW / 970 - DB2

Under rare circumstances a query might fail with SQL0901N error 
in SMP enabled environment. 
 
The following stack is reported: 
 
pthread_kill 
sqloDumpEDU 
sqldDumpContext 
sqldDumpContext 
sqlrr_dump_ffdc 
sqlzeDumpFFDC 
sqlzeSqlCode 
sqlnn_erds 
sqlno_smp_create_part_or_replicate 
sqlno_smp_mgjn_part_repl 
sqlnoSmpPlanMGJNOp 
sqlnoSmpPlanMateOp 
sqlnoSmpPlanPipeOp 
sqlnoSmpPlanMateOp 
sqlnoSmpPlanPipeOp 
sqlno_smp_process_subsection 
sqlnoSmpPlanPass 
sqlnoSmpPostPassMain 
sqlno_final_phase 
sqlno_exe 
 
db2diag.log entries are reported: 
 
 
2012-XXXXXXXXXXXXXXXXXXXXXXXX          LEVEL: Severe 
PID     : 29425712             TID  : 12923       PROC : db2sysc 
0 
INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE 
APPHDL  : 0-59                 APPID: 
*LOCAL.db2xxxx.121122152943 
AUTHID  : DB2INST1 
EDUID   : 12923                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:200 
MESSAGE : ADM0001C  A severe error has occurred.  Examine the 
administration 
          notification log and contact IBM Support if necessary. 
 
2012-XXXXXXXXXXXXXXXXXXXXXXXX          LEVEL: Severe 
PID     : 29425712             TID  : 12923       PROC : db2sysc 
0 
INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE 
APPHDL  : 0-59                 APPID: 
*LOCAL.db2xxxx.121122152943 
AUTHID  : DB2INST1 
EDUID   : 12923                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:250 
RETCODE : ZRC=0x00000000=0=PSM_OK "Unknown" 
 
2012-XXXXXXXXXXXXXXXXXXXXXXXX          LEVEL: Severe 
PID     : 29425712             TID  : 12923       PROC : db2sysc 
0 
INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE 
APPHDL  : 0-59                 APPID: 
*LOCAL.db2xxxx.121122152943 
AUTHID  : DB2INST1 
EDUID   : 12923                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:275 
MESSAGE : MASTER TIME INFO 
DATA #1 : Hexdump, 32 bytes 
0x07000001108BB610 : 0000 0000 50AE 4569 028B 0000 0009 F293 
....P.Ei........ 
0x07000001108BB620 : 000C BF89 CE3E 3F3E 0000 0000 001F 4000 
.....>?>......@. 
 
2012-XXXXXXXXXXXXXXXXXXXXXXXX          LEVEL: Severe 
PID:29425712 TID:12923 NODE:000 Title: MASTER TIME INFO 
Dump File: 
xxxxxxxxxxxxxxxxx/sqllib/db2dump/FODC_AppErr_2012-xxxxxxxxxxxxxx 
xxxxxxxxx_000/29425712.12923.000.dump.bin 
 
2012-XXXXXXXXXXXXXXXXXXXXXXXX          LEVEL: Severe 
PID     : 29425712             TID  : 12923       PROC : db2sysc 
0 
INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE 
APPHDL  : 0-59                 APPID: *LOCAL.XXXXXXXXXXXXXXXX 
AUTHID  : DB2INST1 
EDUID   : 12923                EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, 
probe:300 
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 58 
 sqlerrmc: sqlno_smp_create_part_or_r[100]:rc(     0) 
 
 sqlerrp : SQLNO347 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFF9C      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
 
           (7)      (8)      (9)      (10)        (11)

**************************************************************** 
* USERS AFFECTED:                                              * 
* SMP enabled environment                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

No local fix

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 Fix Pack 9.

not known / see Local fix

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

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

24.01.2013
21.10.2013
21.10.2013

9.7.FP9