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

STORED PROCEDURE EXPLAIN_SQL WITH CURRENT SCHEMA INPUT PARAMETER RETURNS
SQLCODE -713

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Stored procedure EXPLAIN_SQL returns the following sqlca when 
CURRENT SCHEMA is passed as an input parameter: 
 
SQLCA Information 
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -713   sqlerrml: 14 
 sqlerrmc: CURRENT SCHEMA 
 sqlerrp : SQLNQ1CC 
 sqlerrd : (1) -2145779603      (2) 0                (3) 0 
           (4) 0                (5) -100             (6) 0 
 sqlwarn : (1)      (2)      (3)      (4)        (5)       (6) 
           (7)      (8)      (9)      (10)       (11) 
 sqlstate: 42815
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* After explaining the sql query, the stored procedure         * 
* EXPLAIN_SQL resets the original value of DB2 special         * 
* registers. While resetting the value of CURRENT SCHEMA it    * 
* passes a long schema name, most of which is blank character. * 
* The schema name is found invalid by the db2 engine because   * 
* it is longer than the supported length of schema names.      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to product Version 9.1 Fix Pack 8.                   * 
****************************************************************
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
Problem was first fixed in Version 9.1 Fix Pack 8. The schema 
name is truncated if its length exceeds 30 characters, which is 
the maximum length allowed for a schema name.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.11.2009
04.01.2010
04.01.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.1.FP8
Problem behoben lt. FixList in der Version
9.5.0.5 FixList