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 IC62394 Status: Geschlossen

ERROR SQL0901 OR ABNORMAL TERMINATION WHEN ASSIGNING VALUE TO ARRAY
ELEMENT OF DBCLOB TYPE

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
A SET statement that assigns a value to an array element of 
type DBCLOB may report error SQL0901 at run time, or cause 
your database instance to terminate abnormally.  In the event 
of a -901 error, the reason string "bad element size" may be 
given. 
 
For example: 
 
create type arrtype as dbclob(5) array[] 
DB20000I  The SQL command completed successfully. 
 
create variable GV arrtype 
DB20000I  The SQL command completed successfully. 
 
set GV[1] = 'abc' 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "bad 
element size".) 
SQLSTATE=58004 
 
create procedure proc(OUT a dbclob(5)) 
begin 
declare arrv arrtype; 
set arrv[1] = dbclob('abc'); 
set a = arrv[1]; 
end 
DB20000I  The SQL command completed successfully. 
 
call proc(?) 
SQL0901N  The SQL statement failed because of a non-severe 
system error. 
Subsequent SQL statements can be processed.  (Reason "bad 
element size".) 
SQLSTATE=58004
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* NONE                                                         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A SET statement that assigns a value to an array element of  * 
*                                                              * 
* type DBCLOB may report error SQL0901 at run time, or cause   * 
*                                                              * 
* your database instance to terminate abnormally.  In the      * 
* event                                                        * 
* of a -901 error, the reason string "bad element size" may be * 
*                                                              * 
* given.                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* For example:                                                 * 
*                                                              * 
*                                                              * 
*                                                              * 
* create type arrtype as dbclob(5) array[]                     * 
*                                                              * 
* DB20000I  The SQL command completed successfully.            * 
*                                                              * 
*                                                              * 
*                                                              * 
* create variable GV arrtype                                   * 
*                                                              * 
* DB20000I  The SQL command completed successfully.            * 
*                                                              * 
*                                                              * 
*                                                              * 
* set GV[1] = 'abc'                                            * 
*                                                              * 
* DB21034E  The command was processed as an SQL statement      * 
* because                                                      * 
* it was not a                                                 * 
*                                                              * 
* valid Command Line Processor command.  During SQL processing * 
* it                                                           * 
* returned:                                                    * 
*                                                              * 
* SQL0901N  The SQL statement failed because of a non-severe   * 
*                                                              * 
* system error.                                                * 
*                                                              * 
* Subsequent SQL statements can be processed.  (Reason "bad    * 
*                                                              * 
* element size".)                                              * 
*                                                              * 
* SQLSTATE=58004                                               * 
*                                                              * 
*                                                              * 
*                                                              * 
* create procedure proc(OUT a dbclob(5))                       * 
*                                                              * 
* begin                                                        * 
*                                                              * 
* declare arrv arrtype;                                        * 
*                                                              * 
* set arrv[1] = dbclob('abc');                                 * 
*                                                              * 
* set a = arrv[1];                                             * 
*                                                              * 
* end                                                          * 
*                                                              * 
* DB20000I  The SQL command completed successfully.            * 
*                                                              * 
*                                                              * 
*                                                              * 
* call proc(?)                                                 * 
*                                                              * 
* SQL0901N  The SQL statement failed because of a non-severe   * 
*                                                              * 
* system error.                                                * 
*                                                              * 
* Subsequent SQL statements can be processed.  (Reason "bad    * 
*                                                              * 
* element size".)                                              * 
*                                                              * 
* SQLSTATE=58004                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.5, Fix Pack 5.                      * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
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

Lösung
Fix delivered in DB2 Version 9.5, Fix Pack 5.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.08.2009
17.02.2010
17.02.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP5
Problem behoben lt. FixList in der Version
9.5.0.5 FixList