DB2 FOR LUW / DB2FORLUW / 970 - DB2

If '-l' (Log commands in history file) and '-z' (Save all output 
to output file) options are used with 'db2' CLP command and both 
options point to the same file then text recorded in the output 
file gets corrupted. 
 
Example: 
 
$ db2 -z out.txt -l out.txt list command options 
 
Content of the out.txt file is: 
---------- 
  Command Line Processor Option Settin05/23/2012 04:06:52 
DB20000I The LIST COMMAND OPTIONS command completed 
successfully. 
 ect to backend (DB2BQTRY) = 60 
 Request queue wait time (seconds) (DB2RQTIME) = 5 
---------- 
 
Correct content should be: 
 
---------- 
06/19/2012 04:09:34 list command options 
06/19/2012 04:09:34 DB20000I  The LIST COMMAND OPTIONS command 
completed successfully. 
 
 
      Command Line Processor Option Settings 
 
 Backend process wait time (seconds)        (DB2BQTIME) = 1 
 No. of retries to connect to backend        (DB2BQTRY) = 60 
 Request queue wait time (seconds)          (DB2RQTIME) = 5 
----------

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 7.                       * 
****************************************************************

Use different file names with -l and -z options. Also, as a 
work-around, you could use this command on LU platform to get 
similar output: db2 -tvf t.sql | tee out.txt

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
 

Problem was first fixed in DB2 Version 9.7 Fix Pack 7.

keiner bekannt / siehe Local-Fix

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

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

19.06.2012
24.10.2012
24.10.2012

9.7.FP7