|
Problem IC65304
|
Status: Closed |
"TOTAL HOST RESPONSE TIME" AND "TOTAL ELAPSED TIMES FOR STMTS" ARE NOT FILLED |
| product: |
DB2 CONNECT / DB2CONNCT / 970 - DB2 |
| Problem description: |
USERS AFFECTED:
Systems using LUW clients and DB2 Connect servers connecting to
host databases.
PROBLEM DESCRIPTION:
When the monitor switch STATEMENT is ON, the commands
"GET SNAPSHOT FOR ALL DCS DATABASES" or "GET SNAPSHOT FOR ALL
DCS APPLICATIONS" report "Total Host response time" and "Total
elapsed times for stmts" of '0' (zero). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Systems using LUW clients and DB2 Connect servers *
* connectingto host databases. *
****************************************************************
* PROBLEM DESCRIPTION: *
* When the monitor switch STATEMENT is ON, the commands *
* "GETSNAPSHOT FOR ALL DCS DATABASES" or "GET SNAPSHOT FOR *
* ALLDCS APPLICATIONS" report "Total Host response time" *
* and"Total elapsed times for stmts" of '0' (zero). *
****************************************************************
* RECOMMENDATION: *
* install version 9.7 FP2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in version 9.7 FP2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.12.2009
23.04.2010
23.04.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.9
|
 |
| 9.7.0.2
|
|
