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 | |
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 |