Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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
DB2 Version 9.1 Fix Pack 12  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 FixList