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 IC68934 Status: Closed

SQL0901N MAY BE ISSUED COMPILING AN UPDATE OF A UNION ALL VIEW THAT HAS A
DATA-PARTITIONED TABLE

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
SQL0901N may be issued during compilation of an UPDATE on a 
UNION ALL view (UAV) that has a data-partitioned table (DPT) in 
one of its legs. 
 
The following additional conditions must be satisfied for this 
to occur: 
- At least one leg of the UAV is a simple base-table (has no 
distribution keys associated with it) 
- The database instance is serial 
- Only part of the DPT's partitioning key columns are updated 
in the UPDATE statement 
 
The SQL0901N issued will be: 
 
SQL0901N The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed. (Reason "column 
number out of range".) SQLSTATE=58004 
 
The stack trace from the SQL0901N may look something like: 
 
sqlnq_ftb::num2fcs 
sqlnq_qun::change_to_lower_box 
sqlnr_upddelpd_action 
sqlnr_comp 
sqlnr_seq 
sqlnr_rcc 
sqlnr_magic_detail_action 
...
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 9.7 fixpack 2                          * 
****************************************************************
Local Fix:
Alter the CURRENT QUERY OPTIMIZATION special register or the 
dft_queryopt database configuration parameter to a value less 
than 5.
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
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 has been fixed DB2 9.7 fix pack 2 onwards. 
Behavior changes lead to successful updating of union all view.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
31.05.2010
22.06.2010
22.06.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP2
Problem solved according to the fixlist(s) of the following version(s)
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.