IC67593: DSMSERV CAN CRASH AFTER A DELETE CURSOR COMMAND

IBM Tivoli Storage Manager V6.1 Fix Pack 4 (6.1.4) Server Downloads

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