IBM Support

JR27782: STOP BUTTON IN COMMAND EDITOR FAILS TO STOP RUNNING QUERY.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Unable to stop a running query from the DB2 Command Editor
    when the stop button is pressed.
    
    Recreate:
    1) Start DB2 Command Editor.
    2) Connect to database.
    3) select * from sysibm.systables a, sysibm.syscolumns b,
    sysibm.syscolumns c where a.createdts=b.statstime and
    b.statstime=c.statstime
    4) Press the stop button.
    

Local fix

  • Open the script used to startup the DB2 Command Editor
    C:\Program Files\IBM\SQLLIB\bin\db2cc.bat
    
    Then change from:
    
    IF "%1" == "wait" GOTO WAIT
    IF "%1" == "-ic" GOTO WSWB
       db2javit -j:CC -s: -i: -l: -o:"%RUNTIME_FLAGS%" -a:"%1 %2 %3
    %4 %5 %6 %7 %8"
       GOTO END
    
    :WAIT
       db2javit -j:CC -s: -w: -i: -l: -o:"%RUNTIME_FLAGS%" -a:"%2 %3
    %4 %5 %6 %7 %8 %9"
       GOTO END
    
    :WSWB
       db2icdocs.exe
       GOTO END
    
    :end
    
    to:
    
    IF "%1" == "wait" GOTO WAIT
    IF "%1" == "-ic" GOTO WSWB
       start /MIN db2javitcmd -j:CC -s: -i: -l: -o:"%RUNTIME_FLAGS%"
    -a:"%1 %2 %3 %4 %5 %6 %7 %8"
       GOTO END
    
    :WAIT
       start /MIN db2javitcmd -j:CC -s: -w: -i: -l:
    -o:"%RUNTIME_FLAGS%" -a:"%2 %3 %4 %5 %6 %7 %8 %9"
       GOTO END
    
    :WSWB
       db2icdocs.exe
       GOTO END
    
    :end
    

Problem summary

  • see problem description
    

Problem conclusion

  • First fixed in DB2 UDB Version 9.5, FixPak 1
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR27782

  • Reported component name

    DB2 UDB ESE WIN

  • Reported component ID

    5765F4101

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-11-06

  • Closed date

    2008-05-16

  • Last modified date

    2008-05-16

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

    JR26279

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

Fix information

  • Fixed component name

    DB2 UDB ESE WIN

  • Fixed component ID

    5765F4101

Applicable component levels

  • R910 PSY

       UP

  • R950 PSY

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

Document Information

Modified date:
16 May 2008