IC67593: DSMSERV CAN CRASH AFTER A DELETE CURSOR COMMAND

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The Tivoli Storage Manager server can crash after an
    administrator issues the DELETE CURSOR command.  This will only
    happen if the CURSOR contains a select command that is malformed
    
    and issued against an invalid database table.
    .
    Customer/L2 Diagnostics:
    Use a debugger to extract the failing call-chain from the
    coredump generated by the crash.  The following known failing
    call-chain has been associated with this problem(on AIX):
    .
      noname.strcmp()
      FindCursor()
      AdmSQLDeleteCursor()
      AdmCommandLocal()
      admCommand()
      SmAdminCommandThread()
      StartThread()
    .
    The activity log will also show that a cursor has been
    deleted using the DELETE CURSOR command just prior to the
    crash.  Review the CURSOR's defined prior to the crash to
    determine if one of them includes SQL statements against
    an invalid database table.  For example;
    .
    01/01/2010 01:02:03 ANR2017I Administrator ADMIN issued command:
                        DEFINE CURSOR A00000A0 SQL='SELECT
                        AR_COPYGROUPS.DOMAIN_NAME,
                        AR_COPYGROUPS.CLASS_NAME,
                        AR_COPYGROUPS.DESTINATION FROM
                        AR_COPYGROUPS,mgntclasses'
                        (SESSION: 300549, PROCESS: 1)
    .
    In this example, the ",mgntclasses" table does not exist.  It
    should be ".mgmtclasses".  Notice the "," instead of a ".",
    which allows the incorrect table to be accepted.
    .
    Initial Impact:
    High
    .
    Tivoli Storage Manager Versions Affected:
    All 6.1 Tivoli Storage Manager servers.
    .
    Additional Keywords:
    TSM CRASH ABEND ABORT FAILURE ZZ61 CURSOR SELECT
    ADMSQLDELETECURSOR FINDCURSOR
    .
    

Local fix

  • Disable or fix any malformed DEFINE CURSOR commands.
    

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.4, 6.1.4, 6.2.1. 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

    IC67593

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    61A

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-04-01

  • Closed date

    2010-04-05

  • Last modified date

    2010-04-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

  • R61A PSY

       UP

  • R61H PSY

       UP

  • R61L PSY

       UP

  • R61S PSY

       UP

  • R61W PSY

       UP

  • R62A PSY

       UP

  • R62H PSY

       UP

  • R62L PSY

       UP

  • R62S PSY

       UP

  • R62W PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager

Software version:

61A

Reference #:

IC67593

Modified date:

2010-04-05

Translate my page

Machine Translation

Content navigation