DB2 - Problembeschreibung
Problem IC87922 | Status: Geschlossen |
CORRUPTED TEXT IN THE OUTPUT FILE GENERATED BY 'DB2' CLP COMMAND WHEN BOTH (-L AND -Z) OPTIONS POINT TO THE SAME FILE. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 2. * **************************************************************** | |
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 | |
verfügbare FixPacks: | |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 Version 10.1 Fix Pack 2. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.11.2012 18.01.2013 18.01.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.2 | |
10.5.0.2 |