|
Problem IC74900
|
Status: Closed |
CLIENT APPLNAME SPECIAL REGISTER IS NOT RESET TO BLANK ON THE FIRST SQL STATEMENT AFTER "DB2 -TVF" EXECUTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.5 FixPak 8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.03.2011
05.07.2011
05.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.,
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
