|
Problem IC69406
|
Status: Closed |
THERE COULD BE -901 WHEN COMPILING A QUERY CONTAINING SCALAR AGGREGATE FUNCTIONS WITH PARTITION BY CLAUSE IN SMP |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| 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> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL. *
****************************************************************
* PROBLEM DESCRIPTION: *
* ABSTRACT: THERE COULD BE -901 WHEN COMPILING A *
* QUERYCONTAINING SCALAR AGGREGATE FUNCTIONS WITH PARTITION *
* BYCLAUSE IN SMPIn SMP environment(ie. intra-partition *
* parallelism isenabled), if a query containing scalar *
* aggregate functionswith PARTITION BY clause, eg. ROWNUMBER() *
* OVER (PARTITION byA.APLY_NO,A.POLICY_NO), then there could *
* be -901 errorhappening.An error message may be left in *
* db2diag.log looked *
* likethis:=====================================================
* I5761138A882 LEVEL:SeverePID : 242136 *
* TID : 136603 PROC :db2sysc 0INSTANCE: db2inst1 *
* NODE : 000 DB : SAMPLEAPPHDL : 0-19720 *
* APPID:10.1.1.1.45113.100930183636AUTHID : DB2INST1EDUID *
* : 136603 EDUNAME: db2agent (SAMPLE) 0FUNCTION: *
* DB2 UDB, relation data serv, sqlrr_dump_ffdc,probe:300DATA *
* #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytessqlcaid : SQLCA *
* sqlcabc: 136 sqlcode: -901 sqlerrml: 58sqlerrmc: *
* sqlno_smp_create_part_from[200]:rc( 0)sqlerrp : *
* SQLNO33Esqlerrd : (1) 0x00000000 (2) 0x00000000 *
* (3)0x00000000(4) 0x00000000 (5) 0xFFFFFF38 *
* (6)0x00000000sqlwarn : (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 0INSTANCE: db2inst1 *
* NODE : 000 DB : SAMPLEAPPHDL : 0-19720 *
* APPID:10.1.1.1.45113.100930183636AUTHID : *
* DB2INST1EDUID : 136603 EDUNAME: db2agent *
* (SAMPLE) 0FUNCTION: DB2 UDB, SW- common services, *
* sqlnn_cmpl,probe:650MESSAGE : *
* ZRC=0x80310004=-2144272380=SQLNN_E_NFOUND"Could not find an *
* internal object required toprocessthe command"DATA #1 : *
* String, 153 bytesCompiler error stack for rc = *
* -2144272380:sqlnn_cmpl[390]sqlno_exe[2000]sqlno_final_phase[50
* call stack may look like *
* this:<StackTrace>sqlno_smp_create_part_from_key_ordersqlnoSmpP
* intra-partition parallelism. *
****************************************************************
* RECOMMENDATION: *
* Update to version 9.7 or later. *
**************************************************************** |
| Local Fix: |
Disable intra-partition parallelism. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This problem is first fixed in version 9.5 fixpack 7. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69433 IC69434
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.06.2010
08.11.2010
08.11.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP7,
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
