DB2 FOR LUW / DB2FORLUW / A10 - DB2

There is a new input parameter 'system_appls' added in V10.5 for 
the below table functions to return data about system 
applications: 
 
- MON_GET_APPL_LOCKWAITS 
- MON_GET_CONNECTION 
- MON_GET_CONNECTION_DETAILS 
- MON_GET_UNIT_OF_WORK 
- MON_GET_UNIT_OF_WORK_DETAILS 
 
From info center, 
system_appls 
    An input parameter of data type SMALLINT that specifies 
whether information for system applications is returned. The 
following values are valid: 
 
        0 or NULL: System application information is not 
returned. NULL is the default if a value for system_appls is not 
provided. 
        1: User and system application information is returned. 
 
This APAR adds these changes to V9.7 so that the users can view 
system applications.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users on DB2 LUW V10.1                                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Customer should upgrade to V10.1 FP5 where the fix is        * 
* included.                                                    * 
****************************************************************

Customer should upgrade to V10.1 FP5 where the fix is included. 
 
There is a new input parameter 'system_appls' added for the 
below table functions to return data about system applications: 
 
- MON_GET_APPL_LOCKWAITS 
- MON_GET_CONNECTION 
- MON_GET_CONNECTION_DETAILS 
- MON_GET_UNIT_OF_WORK 
- MON_GET_UNIT_OF_WORK_DETAILS 
 
The users can modify their SQL query by introducing a new input 
parameter 'system_appls' with a value of 1 to return the 
information about both user and system applications.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

23.04.2015
29.07.2015
29.07.2015