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 IC71505 Status: Closed

DB2TOP CAN DISPLAY DB2EXFMT OUTPUT FOR WRONG USER, WORKS AS EXPECTED ON SUN
AND AIX

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
Db2top can display db2exfmt output for wrong user, shows correct 
information on SUN and AIX platform. 
 
Steps taken to get the explain output: 
* db2top -d <dbaname> 
* Use l option to list the application 
* Choose an agent of SQL application using option 'a' 
* Use option 'x' to generate a explain plan
Problem Summary:
See ERROR DESCRIPTION.
Local Fix:
Set USERNAME equal to USER environment variable, before 
executing db2top command: 
export USERNAME=$USER
Solution
Problem was first fixed in DB2 Version 9.8 FP0.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
27.09.2010
25.05.2011
25.05.2011
Problem solved at the following versions (IBM BugInfos)
9.8.FP0
Problem solved according to the fixlist(s) of the following version(s)