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 | |
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 |