DB2 FOR LUW / DB2FORLUW / 980 - DB2

db2trc may hang engine when it is invoked via a script. 
 
Reason for hang 
 
When you issue "db2trc -f <filename>" to trace to a file, a 
background daemon process is started to act as the trace record 
writer process.  When db2trc is turned on from within a script, 
the daemon process still has an association back to the script 
process.  So, when CTRL-C was issued against the script, that 
CTRL-C got propagated to the trc daemon process as well and so 
it terminated too.  Now since the trace record writer process is 
gone, all DB2 processes which still want to write out trace 
records end up waiting forever to write a buffer that no longer 
exists.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When you issue "db2trc -f <filename>" to trace to a file, a  * 
* background daemon process is started to act as the trace     * 
* record                                                       * 
* writer process.  When db2trc is turned on from within a      * 
* script, the daemon process still has an association back to  * 
* the script                                                   * 
* process.  So, when CTRL-C was issued against the script,     * 
* that CTRL-C got propagated to the trc daemon process as well * 
* and so                                                       * 
* it terminated too.  Now since the trace record writer        * 
* process is gone, all DB2 processes which still want to write * 
* out trace                                                    * 
* records end up waiting forever to write a buffer that no     * 
* longer exists.                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V10.                                              * 
****************************************************************

Do a "db2trc off" at any command prompt first and then CTRL-C 
the script after it is confirmed that db2trc is off.

keiner bekannt / siehe Local-Fix

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

01.07.2010
06.04.2011
06.04.2011