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

TRAILING SPACES ON PACKAGE IDENTIFIERS ARE NOT IGNORED, WHICH MIGHT LEAD TO
-901 ERROR: SECTION LENGTH MISMATCH

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
Trailing blanks on package identifiers are not being trimmed and 
ignored as they should be. 
When using certain statements such as "SET CURRENT PACKAGE SET 
=:HV", where the host variable has trailing blanks, DB2 will 
include the trailing blanks into the cached package name and 
load the trailing blank identifier into the APM cache. 
This is an issue when subsequent actions on the package (such as 
BIND) are done. As the flushing of the package will be skipped 
due to mismatching caused by the trailing blanks, the package 
will not be flushed as per design. The next time the package is 
loaded, DB2 will load the cache package with trailing blanks 
which has different section information than the SYSPLAN. This 
causes a discrepancy between SYSPLAN and the cached package 
raising the defensive -901 error and one of following messages 
will be logged to db2diag.log: 
 
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 
 
or: 
 
FUNCTION: DB2 UDB, runtime interpreter, sqlriSectRelink, 
probe:505 
DATA #1 : <preformatted> 
Section relink failure: Relink ID 56607C20 @ 0A00010000220080 to 
ID 50657930 @ 0A00010020760080
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.5 and Fix Pack 4 or higher.        * 
****************************************************************
Local-Fix:
- remove trailing blanks from host variable 
or 
- flush stalled sections by issuing drop command with trailing 
blanks: 
$ db2 "drop package '<IDENTIFIER>'.<PACKAGE_NAME> "
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
Problem was first fixed in DB2 version 10.5 and Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
05.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