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) |