home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IC63123 Status: Closed

STATUS OF QUEUED WLM APPLICATIONS WILL BE SHOWN AS "UOW QUEUED"
IN APPLICATION SNAPSHOTS

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Workload management allows applications to be "queued". The 
application status for such applications in queued state is 
incorrectly shown as UOWEXEC. The application status could be 
displayed incorrectly by workload management, snapshot monitor, 
event monitor, and snapshot UDFs that have an application 
status element.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Workload management allows applications to be "queued". The  * 
* application status for such applications in queued state is  * 
* incorrectly shown as UOWEXEC. The application status could   * 
* be displayed incorrectly by workload management, snapshot    * 
* monitor, event monitor, and snapshot UDFs that have an       * 
* application status element.                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Customers should upgrade to DB2 for LUW Version 9.7 Fix Pack * 
* 1                                                            * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows

Solution
With this APAR, the existing functionality has been enhanced to 
correctly reflect the status of a queued application as "UOW 
Queued", rather than "UOWEXEC". This fix affects application 
status reported in the following invocations -- 
1) CLP list applications 
2) CLP application snapshot 
3) SNAP_GET_APPL_INFO_V95 table function and 
SYSIBMADM.SNAPAPPL_INFO administrative view 
4) user programs calling the db2GetSnapshot api for generating 
application and applinfo snapshots
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
10.09.2009
24.02.2010
24.02.2010
Problem solved at the following versions (IBM BugInfos)
9.7.FP*
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.1 FixList