DB2 - Problem description
| Problem IC77905 | Status: Closed |
DB2 GET SNAPSHOT FOR APPLICATION AGENTID XXXXXX MAY RETURN SQL1611W | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 910 - 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: | |
Fix | |
| Local Fix: | |
Use application id instead of agentid to get the snapshot info. | |
| available fix packs: | |
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows | |
| Solution | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2011 08.12.2011 08.12.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.1.0.11 |
|