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

A TRANSACTION REMAINS RUNNING EVENT AFTER CANCELLING OF AN APPLICATION.

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
If access plan has HSJN with Residual Predicates and DB2 need to 
process millions of rows during execution, 
then interrupt of such query can take a very long time.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running DB2 v9.5 FP9 and earlier                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v9.5 FP10                                     * 
****************************************************************
Local Fix:


Solution


The problem was first fixed in DB2 v9.5 FP10


Workaround


not known / see Local fix


BUG-Tracking


forerunner  : APAR is sysrouted TO one or more of the following: IC81952 IC84593 
follow-up : 


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.02.2012
20.10.2012
20.10.2012


Problem solved at the following versions (IBM BugInfos)


9.5.FP10



Problem solved according to the fixlist(s) of the following version(s)


9.5.0.10

FixList