Home

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IC96305	Status: Closed
UNDER RARE CIRCUMSTANCES A QUERY MIGHT FAIL WITH -901 WHEN COMPILING IN SMP
product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
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)
Problem Summary:
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v10.5 FP3 or latest release. * ****************************************************************
Local Fix:
No local fix
available fix packs:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
Solution

Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	26.09.2013 07.08.2014 07.08.2014
Problem solved at the following versions (IBM BugInfos)

Problem solved according to the fixlist(s) of the following version(s)
10.5.0.3
10.5.0.3