IBM Support

IC84721: CORRUPTED TEXT IN THE OUTPUT FILE GENERATED BY 'DB2' CLP COMMAND WHEN BOTH (-L AND -Z) OPTIONS POINT TO THE SAME FILE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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
    ----------
    

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
    

Problem summary

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

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IC84721

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-06-19

  • Closed date

    2012-10-24

  • Last modified date

    2012-10-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC87922

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
24 October 2012