home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT02546 Status: Geschlossen

COMPILING A SQL STATEMENT CAN RETURN SQL0901N WITH REASON "TOO MANY
COLUMNS OR RECORD LENGTH EXCEEDED."

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Compiling an SQL statement can return SQL0901N with Reason "Too 
many columns or record length exceeded." when all of the 
following conditions are met: 
 
(1) intra-partition parallelism is enabled (i.e. DBM 
configuration parameter INTRA_PARALLEL is set to YES). 
(2) DB2 chooses zigzag join in the query plan. 
(3) DB2 chooses to SMP-parallelize the zigzag join. 
(4) There is a dimension table, in which the join column data 
type is either INT or BIGINT. 
(5) The query needs to access a column whose data type is 
DECIMAL from the dimension table. 
 
For example, in the following query, if d1.key1 is int data type 
and d1.col1 is decimal data type, and if DB2 chooses zigzag join 
and SMP-parallelize the zigzag join, then DB2 can return the 
SQL0901 error when compiling this query. 
 
   select d1.col1 
   from fact f, dimension1 d1, dimension2 d2 
   where d1.c1 = 10 and d2.c1 = 30 
   and d1.key1 = f.key1 
   and d2.key2 = f.key2
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Cancun Release 10.5.0.4                       * 
****************************************************************
Local-Fix:
Disable intra-partition parallelism. To disable intra-partition 
parallelism at application or statement level, set special 
register "current degree" to 1. For example: SET CURRENT DEGREE 
= '1'
verfügbare FixPacks:
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
First fixed in DB2 Cancun Release 10.5.0.4
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
13.06.2014
09.09.2014
09.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList