DB2 FOR LUW / DB2FORLUW / 970 - DB2

Depending on file systems mount order, DB2 instance may block if 
one or more NFS mounts become stale. If the NFS file system 
mount is stale and we need to open a file that is in a files 
ystem that is mounted after that NFS file system, we can hang. 
Another clue that you may be hitting this issue is that the 
thread that is hung will not produce a stack with db2pd -stacks 
(it will be missing from the stack files in the diagpath).  You 
can use an OS utility (pstack, gstack, procstack) to dump the 
stacks and you will then find the missing stack in a call to 
sqloFetchAndStoreFSInfoInFileHandle and ossGetDiskInfo. 
 
Example top of the thread stack: 
 
Thread 25 (Thread 47307022133568 (LWP 12073)): 
#0  0x00002b067436e115 in _xstat () from /lib64/libc.so.6 
#1  0x00002b06739cb288 in ossGetDiskInfo () 
#2  0x00002b066f7df779 in sqloFetchAndStoreFSInfoInFileHandle () 
#3  0x00002b066f7de1a8 in sqloopenp () from 
/db2/DLR/sqllib/lib64/libdb2e.so.1 
(...)

**************************************************************** 
* USERS AFFECTED:                                              * 
* Any where a stale NFS mount might occur                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6                        * 
****************************************************************

Changing the file system mount order to have NFS file systems 
mounted after local ones.

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
 

First fixed in DB2 Version 9.7 Fix Pack 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84316 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

16.12.2011
12.06.2012
12.06.2012

9.7.FP6