Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

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 FixList
9.5.0.7 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.