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

CLIENT APPLNAME SPECIAL REGISTER IS NOT RESET TO BLANK ON THE FIRST SQL
STATEMENT AFTER "DB2 -TVF" EXECUTION

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Referring to DB2 Information Center, we know, when we run a 
CLP script file using the db2 -tvf filename command, it sets the 
special register CLIENT APPLNAME to CLP filename. 
 
 
And the special register CLIENT APPLNAME should be reset to 
blank on the first SQL statement of DB2 CLP after execution of 
db2 -tvf filename command, if back-end process of CLP (db2bp) 
used by "db2 -tvf <filename>" command is still active. 
 
 
But we have some sql statements in the "filename" script file of 
"db2 -tvf", the special register CLIENT APPLNAME is not reset to 
BLANK by the first db2 sql statement after "db2 -tvf" execution.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The special register CLIENT APPLNAME is not reset to its     * 
* previous value by the first db2 sql statement after "db2     * 
* -tvf" execution, it should get reset.                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version V9.5 FP8                              * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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.5 FixPak 8
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.03.2011
05.07.2011
05.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.,
9.5.FP8
Problem behoben lt. FixList in der Version
9.5.0.8 FixList