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

DB2 MAY TRAP WHEN UNFIXING THE LAST PAGE OF A TEMP TABLE DUE TO A TIMING
HOLE ISSUE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
When dropping a TEMP table, db2 will unfix pages from buffer 
pool. There exist a timing hole issue when two unfixers try to 
unfix the last page of a TEMP table without the page latch 
protection which in turn causes db2 trap. 
 
The issue can be identified from the stack trace. 
 
<StackTrace> 
sqlbufix 
sqlbufix 
sqldDropTable 
sqldDropTable 
sqldTableDrop 
sqlrl_userTempDrop 
sqlrl_userTempCleanup 
sqlrr_appl_term 
AppStopUsing 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When dropping a TEMP table, db2 will unfix pages from buffer * 
*                                                              * 
* pool. There exist a timing hole issue when two unfixers try  * 
* to                                                           * 
* unfix the last page of a TEMP table without the page latch   * 
*                                                              * 
* protection which in turn causes db2 trap.                    * 
*                                                              * 
*                                                              * 
*                                                              * 
* The issue can be identified from the stack trace.            * 
*                                                              * 
*                                                              * 
*                                                              * 
* <StackTrace>                                                 * 
*                                                              * 
* sqlbufix                                                     * 
*                                                              * 
* sqlbufix                                                     * 
*                                                              * 
* sqldDropTable                                                * 
*                                                              * 
* sqldDropTable                                                * 
*                                                              * 
* sqldTableDrop                                                * 
*                                                              * 
* sqlrl_userTempDrop                                           * 
*                                                              * 
* sqlrl_userTempCleanup                                        * 
*                                                              * 
* sqlrr_appl_term                                              * 
*                                                              * 
* AppStopUsing                                                 * 
*                                                              * 
* </StackTrace>                                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 v97fp6                                        * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
The fix will be included in DB2 v97fp6
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.11.2011
06.06.2012
06.06.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.6 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.