|
Problem IC84721
|
Status: Closed |
CORRUPTED TEXT IN THE OUTPUT FILE GENERATED BY 'DB2' CLP COMMAND WHEN BOTH (-L AND -Z) OPTIONS POINT TO THE SAME FILE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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
---------- |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 7. *
**************************************************************** |
| Local Fix: |
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 |
| available fix packs: |
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 DB2 Version 9.7 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC87922
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.06.2012
24.10.2012
24.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
