|
Problem IC76734
|
Status: Closed |
DB2 GET SNAPSHOT FOR APPLICATION AGENTID XXXXXX MAY RETURN SQL1611W |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
After upgrade to DB2 v9.7 FP4 users may receive SQL1611W warning
instead of actual data where the application handle is a very
large number.
At the same time the data will be returned by using the
application id as follows:
$db2 get snapshot for application agentid 6526250
SQL1611W No data was returned by Database System Monitor.
$db2 get snapshot for application applid
10.6.186.231.1640.110511163054|more
Application Snapshot
Application handle = 6526250
Application status = UOW Waiting
Status change time = 05/11/2011
12:31:46.090946
Application code page = 1208
Application country/region code = 1
DUOW correlation token =
10.6.186.231.1640.110511163054
<snip> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description Above *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 5. *
**************************************************************** |
| Local Fix: |
Use application id instead of agentid to get the snapshot info. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 Version 9.7 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC77905 IC77906
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.06.2011
02.12.2011
02.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
