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

DROP TABLE COMMANDS ARE SOMETIMES SLOW IN DB2 PURESCALE ENVIRONMENTS

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
DROP TABLE commands may take longer in purescale environments. 
This APAR addresses the issue and improves the performance of 
the DROP TABLE commands especially in 
those cases where the group buffer pool (GBP) is large.
Problem Summary:
DROP TABLE commands may take longer in purescale environments. 
This APAR addresses the issue and improves the performance of 
the DROP TABLE commands especially in 
those cases where the group buffer pool (GBP) is large.
Local Fix:
If the same table will be created again after the drop, then 
rename the table to be dropped and create the new table. 
Drop the renamed table later in a maintenance window.
Solution


Workaround


If the same table will be created again after the drop, then 
rename the table to be dropped and create the new table. 
Drop the renamed table later in a maintenance window.


BUG-Tracking


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


Timestamps


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

15.03.2012
19.04.2013
19.04.2013


Problem solved at the following versions (IBM BugInfos)




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


9.8.0.5

FixList