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) |
