IBM Support

IT21982: DB2CMD.EXE MAY NOT WORK PROPERLY WHEN THE COMMAND LINE IS EXTREMELY LONG

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An example command line:
    'db2cmd /i /w /c test.bat """(extremely long, in the range of
    2000 bytes)"""
    
    Here is a sample message on Eventlog_system.txt
    -----
       Error	2017/05/08 7:30:26	Application Error	1000	(100)
    Faulting application name: db2cmd.exe, Version: 9.7.1000.565,
    time stamp: 0x544030bf, Faulting module name: db2cmd.exe,
    Version 9.7.1000.565,
    time stamp: 0x544030bf, Exception code: 0xc0000005, Fault
    offset: 0x0000159a,
    Process ID: 0x1ce0, Faulting application start time:
    0x01d2c781860c2c84?
    -----
    
    An associated Windows user dump file may have below information:
    -----
        :
    FAULTING_IP:
    db2cmd!main+59a [NT\db2cmd.C @ 346]
    0040159a 8807            mov     byte ptr [edi],al
    
    EXCEPTION_RECORD:  ffffffff -- (.exr 0xffffffffffffffff)
    ExceptionAddress: 0040159a (db2cmd!main+0x0000059a)
       ExceptionCode: c0000005 (Access violation)
      ExceptionFlags: 00000008
    NumberParameters: 2
       Parameter[0]: 00000001
       Parameter[1]: 00130000
    Attempt to write to address 00130000
        :
    STACK_TEXT:
    0012ff38 2e303230 9e89ce91 4991d28e 8692e892 db2cmd!main+0x59a
    [NT\db2cmd.C @ 346]
    WARNING: Frame IP not in any known module. Following frames may
    be wrong.
        :
    -----
    
    When the command line is extremely long, which is over the size
    of our buffer, and when
    doing a strcat, it wrote pass our 2312 bytes buffer and causes
    overwriting invalid
    memory (c0000005).
    

Local fix

  • Shorten the command line.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 Version 11.1                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 Version 11.1 Mod 3 Fix Pack 3.                *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Db2 Version 11.1 Mod 3 Fix Pack 3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT21982

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-11

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

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

    IT21170

  • 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

  • RB10 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":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 March 2018