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

INSERT/UPDATE/DELETE STATEMENT THAT FIRES A TRIGGER MAY RETURN SQL0901N
WITH "SECTION LENGTH MISMATCH"

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
During the firing of a trigger as part of an 
INSERT/UPDATE/DELETE (IUD) statement, implicit rebind will be 
driven if the trigger package is found to be invalid. Suppose 
the trigger package gets revalidated successfully, but the 
trigger action fails with an error causing a rollback, the 
changes to the catalog from the implicit rebind is undone, but 
the stale cached package is left in the package cache. The next 
IUD statement that fires the same trigger may hit SQL0901N with 
"Section length mismatch" when trying to load the section from 
the system catalog to the package cache. 
 
A diaglog entry similar to this will be produced: 
 
2014-02-21-03.08.06.712025-300 I6628233A914         LEVEL: 
Severe 
PID     : 13697272             TID : 19900          KTID : 
93192261 
PROC    : db2sysc 
INSTANCE:              NODE : 000           DB   : TPCDS 
APPHDL  : 0-138                APPID: 
AUTHID  :              HOSTNAME: 
EDUID   : 19900                EDUNAME: db2agent (TPCDS) 
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: 23 
 sqlerrmc: Section length mismatch 
 sqlerrp : SQLRA01D 
 sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 
0x00000000 
           (4) 0x00000000      (5) 0xFFFFFEA2      (6) 
0x00000000 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)        (11) 
 sqlstate: 
 
 
Stack Trace will show these functions: 
 
<StackTrace> 
sqlra_cache_fill_sec 
sqlra_find_sect 
sqlra_get_section 
sqlrr_sql_request_pre 
</StackTrace>
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running on DB2 Version 10.5 on Linux, Unix and     * 
* Windows platforms and using triggers.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to DB2 LUW Version 10.5 Fix Pack 4 or higher levels.  * 
****************************************************************
Local-Fix:
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 LUW Version 10.5 Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
26.05.2014
08.09.2014
08.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList