|
Problem IC69433
|
Status: Geschlossen |
THERE COULD BE -901 WHEN COMPILING A QUERY CONTAINING SCALAR AGGREGATE FUNCTIONS WITH PARTITION BY CLAUSE IN SMP |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
In SMP environment(ie. intra-partition parallelism is enabled),
if a query containing scalar aggregate functions with PARTITION
BY clause, eg. ROWNUMBER() OVER (PARTITION by
A.APLY_NO,A.POLICY_NO), then there could be -901 error
happening.
An error message may be left in db2diag.log looked like this:
=============================================================
2010-06-02-09.27.05.754479+480 I5761138A882 LEVEL: Severe
PID : 242136 TID : 136603 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-19720 APPID:
10.1.1.1.45113.100930183636
AUTHID : DB2INST1
EDUID : 136603 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_from[200]:rc( 0)
sqlerrp : SQLNO33E
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFF38 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
<...skipped...>
2010-06-02-09.27.14.272301+480 E5826893A719 LEVEL: Info
(Origin)
PID : 242136 TID : 136603 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-19720 APPID:
10.1.1.1.45113.100930183636
AUTHID : DB2INST1
EDUID : 136603 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x80310004=-2144272380=SQLNN_E_NFOUND
"Could not find an internal object required to process
the command"
DATA #1 : String, 153 bytes
Compiler error stack for rc = -2144272380:
sqlnn_cmpl[390]
sqlno_exe[2000]
sqlno_final_phase[50]
sqlnoSmpPlanMateOp[500]
sqlno_smp_create_part_from[200]
=============================================================
Corresponding call stack may look like this:
<StackTrace>
sqlno_smp_create_part_from_key_order
sqlnoSmpPlanMateOp
sqlnoSmpPlanPipeOp
sqlnoSmpPlanDummy1Op
sqlnoSmpPlanSortOp
sqlnoSmpPlanScanOp
sqlnoSmpPlanMateOp
sqlnoSmpPlanPipeOp
sqlno_smp_process_subsection
sqlnoSmpPlanPass
sqlnoSmpPostPassMain
sqlno_final_phase
sqlno_exe
sqlno_exe
sqlnn_cmpl
......
</StackTrace> |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All. *
****************************************************************
* PROBLEM DESCRIPTION: *
* In SMP environment(ie. intra-partition parallelism is *
* enabled), if a query containing scalar aggregate functions *
* with PARTITION *
* BY clause, eg. ROWNUMBER() OVER (PARTITION by *
* A.APLY_NO,A.POLICY_NO), then there could be -901 error *
* happening. *
* An error message may be left in db2diag.log looked like *
* this: *
* =============================================================
* 2010-06-02-09.27.05.754479+480 I5761138A882 LEVEL: *
* Severe *
* PID : 242136 TID : 136603 PROC : *
* db2sysc 0 *
* INSTANCE: db2inst1 NODE : 000 DB : SAMPLE *
* APPHDL : 0-19720 APPID: *
* 10.1.1.1.45113.100930183636 *
* AUTHID : DB2INST1 *
* EDUID : 136603 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_from[200]:rc( 0) *
* sqlerrp : SQLNO33E *
* sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) *
* 0x00000000 *
* (4) 0x00000000 (5) 0xFFFFFF38 (6) *
* 0x00000000 *
* sqlwarn : (1) (2) (3) (4) (5) (6) *
* (7) (8) (9) (10) (11) *
* sqlstate: *
* <...skipped...> *
* *
* 2010-06-02-09.27.14.272301+480 E5826893A719 LEVEL: Info *
* (Origin) *
* PID : 242136 TID : 136603 PROC : *
* db2sysc 0 *
* INSTANCE: db2inst1 NODE : 000 DB : SAMPLE *
* APPHDL : 0-19720 APPID: *
* 10.1.1.1.45113.100930183636 *
* AUTHID : DB2INST1 *
* EDUID : 136603 EDUNAME: db2agent (SAMPLE) 0 *
* FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, *
* probe:650 *
* MESSAGE : ZRC=0x80310004=-2144272380=SQLNN_E_NFOUND *
* "Could not find an internal object required to *
* process the command" *
* DATA #1 : String, 153 bytes *
* Compiler error stack for rc = -2144272380: *
* sqlnn_cmpl[390] *
* sqlno_exe[2000] *
* sqlno_final_phase[50] *
* sqlnoSmpPlanMateOp[500] *
* sqlno_smp_create_part_from[200] *
* =============================================================
* *
* Corresponding call stack may look like this: *
* <StackTrace> *
* sqlno_smp_create_part_from_key_order *
* sqlnoSmpPlanMateOp *
* sqlnoSmpPlanPipeOp *
* sqlnoSmpPlanDummy1Op *
* sqlnoSmpPlanSortOp *
* sqlnoSmpPlanScanOp *
* sqlnoSmpPlanMateOp *
* sqlnoSmpPlanPipeOp *
* sqlno_smp_process_subsection *
* sqlnoSmpPlanPass *
* sqlnoSmpPostPassMain *
* sqlno_final_phase *
* sqlno_exe *
* sqlno_exe *
* sqlnn_cmpl *
* ...... *
* </StackTrace> *
* *
* *
* *
* Local fix: *
* Disable intra-partition parallelism. *
****************************************************************
* RECOMMENDATION: *
* Update to db2 version 9.7 fixpack 4 or later fixpack. *
**************************************************************** |
| Local-Fix: |
Disable intra-partition parallelism. |
| verfügbare FixPacks: |
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
|
| Lösung |
This problem is first fixed in db2 version 9.7 fixpack 4. |
| Workaround |
Disable intra-partition parallelism. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.06.2010
28.04.2011
28.04.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
