DB2 FOR LUW / DB2FORLUW / A10 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL PLATFORMS                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 10.1 and Fix Pack 4 or higher.        * 
****************************************************************

- remove trailing blanks from host variable 
or 
- flush stalled sections by issuing drop command with trailing 
blanks: 
$ db2 "drop package '<IDENTIFIER>'.<PACKAGE_NAME> "

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

Problem was first fixed in DB2 version 10.1 and Fix Pack 4.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

03.03.2014
02.06.2014
02.06.2014