IBM Support

IT02269: DB2BATCH CHANGED THE HEADER OUTPUT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The issue is described below:
    
    1- DB2BATCH output on  previous DB2 version  in this case "DB2
    v9.7.0.3"
    
    select distinct trim(col1) from t1 fetch first 10 rows only ;
    
    1
    ------------------------------
    0
    0000512
    001
    00103
    00105
    00107
    00108
    00112
    00113
    00118
    
    2-DB2BATCH output  on "DB2 v9.7.0.8"
    
    select distinct trim(col1) from t1 fetch first 10 rows only ;
    
    1
    ----------------------------------------------------------------
    --------------------------------------------------------
    0
    0000512
    001
    00103
    00105
    00107
    00108
    00112
    00113
    00118
    
    4- If the SELECT is executed on CLP the header output is the
    same on both FPs
    
    - FP3
    $ db2 "select distinct trim(col1) from t1 fetch first 10 rows
    only"
    
    1
    ------------------------------
    0
    0000512
    001
    00103
    00105
    00107
    00108
    00112
    00113
    00118
    
    
    - FP8
    
    db2 "select distinct trim(col1) from t1 fetch first 10 rows
    only"
    
    1
    ------------------------------
    0
    0000512
    001
    00103
    00105
    00107
    00108
    00112
    00113
    00118
    
    In this example the db2batch header size is 30 on v9.7fp3 and on
    v9.7fp8 is 120. On CLP the header size is 30 on both version.
    

Local fix

  • As workaround you can use the option "-w" in the db2batch
    command. This option specifies
    the maximum column width of the result set.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 10.5fp5 or higher                             *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 10.5fp5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT02269

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-06-05

  • Closed date

    2020-07-20

  • Last modified date

    2020-07-20

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

    IT01562

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 August 2020