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

ON AIX DUIRNG DB2DIAG LOG CONTENTION, THE RETRY-OPENING DB2DIAG.LOG MAY
TAKE TOO LONG IF DB2DIAG.LOG WAS LOCKED BY ANOTHER PROCE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
On AIX, duirng db2diag.log contention, when db2diag.log is 
locked by another process,  the retry-opening db2diag.log will 
take very long time ( almost 10 hours ) before giving 
up.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users of version 9.7 on AIX                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* On AIX, duirng db2diag.log contention, when db2diag.log is   * 
* locked by another process,  the retry-opening db2diag.log    * 
* will                                                         * 
* take longer time ( 4 - 5 minutes ) before giving up.         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6.                       * 
****************************************************************
Local Fix:
Release the db2diag.log file lock by moving or archiving 
db2diag.log
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
Problem was first fixed in Version 9.7 Fix Pack 6.
Workaround
Release the db2diag.log file lock by moving or archiving 
db2diag.log
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
02.04.2012
04.06.2012
04.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