IC63441: TIVOLI STORAGE MANAGER 6.1 SERVER CAN CRASH WHEN DOING A DELETE CURSOR IF THE OPEN CURSOR COMMAND FAILED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Tivoli Storage Manager server crashes when doing a DELETE
    CURSOR if the OPEN CURSOR command failed during the processing
    of the SQL statement for that cursor (for instance due to an
    invalid SQL command syntax).
    
    Example from Tivoli Storage Manager server console:
    ANR2017I Administrator ADMIN issued command: DEFINE CURSOR
    C6e245f8
    SQL='SELECT bytes as REST_BYTES from summary and
    activity='RESTORE''
    ANR2017I Administrator ADMIN issued command: DISPLAY CURSOR
    C6e245f8
    ANR0162W Supplemental database diagnostic information:
    -1:42601:-104
    ([IBM][CLI Driver][DB2/NT] SQL0104N  An unexpected token "FROM
    SUMMARY"
    was found following "ELECT BYTES AS REST_BYTES".  Expected
    tokens may include:
    "<space>".  SQLSTATE=42601 .
    ).
    ANR2017I Administrator ADMIN issued command: OPEN CURSOR
    C6e245f8
    ANR0162W Supplemental database diagnostic information:
    -1:42601:-104
    ([IBM][CLI Driver][DB2/NT] SQL0104N  An unexpected token "FROM
    SUMMARY"
    was found following "ELECT BYTES AS REST_BYTES".  Expected
    tokens may include:
    "<space>".  SQLSTATE=42601 .
    ).
    ANR2017I Administrator ADMIN issued command: DELETE CURSOR
    C6e245f8
    Entering exception handler.
    [...]
    Leaving exception handler.
    
    
    Customer/L2 Diagnostics:
    The call stack from a Tivoli Storage Manager 6.1.2.0 Windows
    server crash dump looks as follows:
    adsmdll!DbiReleaseConnection+0x13
    adsmdll!tbSQLFreeAnchor+0x3d
    adsmdll!DiscardCursor+0x19
    adsmdll!AdmSQLDeleteCursor+0x120
    adsmdll!AdmCommandLocal+0x5dc
    adsmdll!admCommand+0xe15
    adsmdll!SmAdminCommandThread+0x20
    *** ERROR: Symbol file could not be found.  Defaulted to export
    symbols for msvcr90.dll -  adsmdll!startThread+0xb9
    WARNING: Stack unwind information not available. Following
    frames may be  wrong.
    msvcr90!endthreadex+0x44
    msvcr90!endthreadex+0xd8
    kernel32!GetModuleHandleA+0xdf
    
    
    Tivoli Storage Manager Versions Affected:
    All Tivoli Storage Manager 6.1 server on all platforms
    
    
    Initial Impact:
    Medium
    
    
    Additional Keywords:
    zz61 56378 ODBC crashing dumping dmp
    

Local fix

  • Correct the invalid SQL syntax so that message ANR0162W with SQL
    message identifier SQL0104N and SQLSTATE 42601 does not occur
    anymore.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Tivoli Storage Manager server users of   *
    *                 the Administrative Client.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: See error description                   *
    ****************************************************************
    * RECOMMENDATION: Apply fixing level when available. This      *
    *                 problem is currently projected to be fixed   *
    *                 in level 6.1.3. Note that this is            *
    *                 subject to change at the discretion of IBM.  *
    ****************************************************************
    *
    

Problem conclusion

  • This problem was fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC63441

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-09-30

  • Closed date

    2009-10-05

  • Last modified date

    2009-10-05

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

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

Fix information

  • Fixed component name

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager

Software version:

61W

Reference #:

IC63441

Modified date:

2009-10-05

Translate my page

Machine Translation

Content navigation